Outlook macro deployment

Posted on 2005-03-09
Medium Priority
Last Modified: 2008-02-01

I got some outlook macros I'd like to make available for several users (on ~ 120 machines),

All users run Outlook 2003 on Windows XP Prof. SP2 and connect to an exchange server over which we got no control.

Is there a good (and/or easy) way to programmatically deploy the macros without the need to go from PC to PC or require the user to do anything (except for probably click to trust the macros)?

Thanks for your input in advance.
Question by:QTCCK
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
LVL 76

Accepted Solution

David Lee earned 2000 total points
ID: 13502038

If there is a way to do it easily, then I have yet to discover it.  Macros are stored in a file called VbaProject.Otm in each user's profile.  If you're certain that the staff on the 120 machines don't have any Outlook macros, then you could simply overwrite this file and deploy your macros.  Otherwise, there is no good solution I know of.  Here's what Sue Mosher, author of a book on Outlook programming, has to say about this: http://www.outlookcode.com/threads.aspx?forumid=4&messageid=9752


Author Comment

ID: 13512776
I did some research on this before I asked and was not too optimistic already. In this case, deploying the otm is doable, as it are very fresh and absolutely equal installations. For future projects I probably should get into COM programming, which seems to be the only proper way to do so.

Thanks, BlueDevilFan, for your input.
LVL 76

Expert Comment

by:David Lee
ID: 13513326

You're welcome.  Thanks for the 'A'!

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Finding original email is quite difficult due to their duplicates. From this article, you will come to know why multiple duplicates of same emails appear and how to delete duplicate emails from Outlook securely and instantly while vital emails remai…
When you have clients or friends from around the world, it becomes a challenge to arrange a meeting or effectively manage your time. This is where Outlook's capability to show 2 time zones in one calendar comes in handy.
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Suggested Courses

752 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