Macros and VBA code in general are not well suited to being distributed. COM
addins are a far better choice for that.

In your Outlook VBA project put your macro in a code module of its own. Use
File, Export to export that module to the file system. Send it to whoever
and have them open their VBA project and Import the module. They then have
your macro.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm


"RSteph" wrote in message
...
I've built a small macro in Outlook to handle managing some settings for
contact lists. Specifically placing 4 different "Public Contact Lists"
into
the favorites folder, and making them viewable in the Address Book. I've
tested the macro on my own machine and it works perfect.

Now I would like to make the macro useable to the rest of the people in my
office. So that they could simply run it, rather than my halving to go
around
to each person and alter the settings, or have them do it themselves. (The
office has a diverse level of computer knowledge).

The only way I know of to do this is to send the macro, as a file, via
e-mail to everyone, have them save it in the appropriate folder, and run
it.
This option causes problems as it requires changing macro security level,
and
placing a file in a hidden folder. I've tried turning the macro into a VB
executable, but I'm having problems getting it to run, and I don't have
the
appropriate software at work to make changes to the VB project.

Is there another, better, option that would accomplish this task? Is there
perhaps a way for me to put this macro on the Administrator account, and
then
somehow make it accessible to other people accounts; or perhaps put it on
the
mail server, and force run it for everyone's account?

Any advice would be greatly appreciated.