• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3274
  • Last Modified:

"Copy" or Install Outlook Macro from one computer to another

I have a few macros I wrote and use in Outlook 2003. I want to share them with my co-workers. What's the easiest in transfering them? Is there an easy way to make the 'install'? If so, can it include the button I created for them?
1 Solution
David LeeCommented:
Hi, thelarster.

There is no simple way to share code in Outlook.  You have two options.  One, give them a copy of the code and they can copy and paste it into Outlook.  Two, export the code to a file, send them the file, they import the code.  The button question depends on what type of button you're talking about.  If it's a button on a form, then the answer is yes.  If it's a toolbar button, then the answer is no.
Patrick MatthewsCommented:
Hello thelarster,

Expanding on David's answer...

1) If you have Visual Studio, create a COM add-in that you can districute to yur co-workers.  I have
never done this, so I cannot give you guidance on how.

2) If all of your code is in VBA modules and/or UserForms (I am *not* referring to Outlook forms
here), then as David suggests, export the modules/UserForms to files, send those files to your
co-workers, and explain to them how to import them into the VB Project.

If your code includes Outlook forms (*not* VBA UserForms), I cannot help you there.

As for your "button", it may be possible to use code to create tool bar/menu bar items to
activate the procedures in your code.  I do this frequently in Excel.  I have not done it
in Outlook, but it should work similarly.


Forced accept.

EE Admin

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now