Enable Macro usage in Outlook 2007 1

[markdmac]

Hi everyone, wondering if anyone knows how to overcome this Office "feature" I am battling.

I have created a macro that empties the Junk Email folder in Outlook. I'm using Outlook 2007. I created a button to run the macro and it works great. The problem is that the first time it is run it requires you to "enable content." Not so bad except that you must enable each time Outlook is started.

Is there any way to authorize specific macros?

I think that maybe I need a code signing certificate and wonder if there is any way to auto generate one for my own personal use so I don't have to pay huge sums of money for a certificate.

Any advice would be greatly appreciated.

Regards,

Mark

 

[dallen43]

To supress alerts try the following at the beginning of your macro:

Application.DisplayAlerts = wdAlertsNone

Then reset this value at the end of the macro:

Application.DisplayAlerts = wdAlertsAll


Try looking at thread68-820546 for signing certificate.

 

[markdmac]

Thanks dallen43. Just what I needed.

I hope you find this post helpful.

Regards,

Mark

Check out my scripting solutions at

http://www.thespidersparlor.com/vbscript

 

[dallen43]

Thanks for the star.

Deb

 

[markdmac]

My pleasure. Well deserved.

I hope you find this post helpful.

Regards,

Mark

Check out my scripting solutions at

http://www.thespidersparlor.com/vbscript