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

Deploying a macro in Outlook using Group Policy

I've been using the Move to Folder macro from BlueDevilFan as described on this post: http://www.experts-exchange.com/Microsoft/Applications/Q_22406876.html. I would like to deploy it to my entire organization as I have found it very useful. Is there a way to do a mass deployment like this? We're running Server 2003 with Exchange 2007. Clients are on XP Pro SP2 with Outlook 2003.

Thanks,

Andrew
0
NCTETech
Asked:
NCTETech
  • 3
  • 2
1 Solution
 
David LeeCommented:
Hi, Andrew.

Unfortunately, the answer is no.  Microsoft provided no automated means of deploying macros to other computers.  You'd have to send the code to each user with instructions on how to add it to Outlook.  The only automated way of distributing code is to create an add-in, either Outlook or COM.  Personally, I prefer COM, but then I also program in VB6, so it's easy for me.  If you have access to a copy of VB6, then I'd be glad to help you turn this into an add-in.
0
 
NCTETechAuthor Commented:
Thanks for the response BDF. I was afraid the answer was no. I do have VB6, so if you have the time and interest then I would be very appreciative of your help. Since the solution sounds as though it will require a bit more of a time investment, let me know if you think that more points are appropriate.

Thanks again,

Andrew
0
 
David LeeCommented:
Andrew,

No, I don't mind helping out.  The point value of the question is entirely up to you.

Here are a pair of links that'll help us with this.  The first is to a VB6 COM add-in template.  Download a copy and have a look.  It's a huge time saver in building COM add-ins with Visual Basic.  Link number two is to a page at Outlookcode.com that provides information on and links to other resources for building add-ins.

http://www.microeye.com/resources/template.htm
http://www.outlookcode.com/article.aspx?ID=36
0
 
NCTETechAuthor Commented:
I apologize for the slow response. Server problems got the best of me  yesterday.

I see that that the template only mentions Outlook 2000 and 2002. We're running 2003. Will this present any different challenges or is the code the same?

I also noticed on the OutlookCode website that VS Tools for Office is referenced and they even have a sample for creating a toolbar and button for completing an Outlook command. The sample is in C#, so I hesitate to get involved with it. So I guess my question is, do you still think that a VB6 COM add in is the way to go since we are using Outlook 2003?

Thanks,

Andrew

0
 
David LeeCommented:
> I see that that the template only mentions Outlook 2000 and 2002. We're running 2003. Will this present any different challenges or is the code the same?
No, the template works fine for Outlook 2003 too.  Apologies, I should have mentioned that.

> So I guess my question is, do you still think that a VB6 COM add in is the way to go since we are using Outlook 2003?
Functionally it's no problem.  VB6 has been superceded by VS2005 and is dated technology.  From an operational standpoint that's not a problem.  But, it does mean that at some point you'll have to re-build this using something newer than VB6 if you plan to keep using it.  

It's your choice.
0

Featured Post

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

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