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

Posted on 2007-10-01
Last Modified: 2012-06-27
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?
Question by:thelarster
    LVL 76

    Accepted Solution

    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.
    LVL 92

    Expert Comment

    by:Patrick Matthews
    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.


    LVL 1

    Expert Comment

    Forced accept.

    EE Admin

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Suggested Solutions

    Get an idea of what you should include in an email disclaimer with these Top 5 email disclaimer tips.
    Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
    Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now