running macros in rules

  • Thread starter Thread starter Mickey Ferguson
  • Start date Start date
M

Mickey Ferguson

I can't seem to get my VBA macros to be able to run in Outlook 2003. I'm
sure it's a security or permissions issue, but I don't know where to look,
and figured someone here would know. I've searched the newsgroup (at least
as much as it will download to me from news.microsoft.com), and found this
information:

"This is exactly why I asked you to conduct a simple test to see whether any
VBA code runs at all. Check Help | About | Disabled Items and Tools | Macro
| Security. You may also need to exit Outlook and shut down any external
programs, such as PDA sync utilities, that use Outlook. Use the Task Manager
to make sure Outlook.exe has shut down completely before you restart it and
try your code again."

This was actually directed at me last July, and I got things working on my
system then. Unfortunately, the hard drive where I did that work died, and
now I've got a new system.

I created a very simple HelloWorld sub that just performs a MsgBox call. I
created a rule that runs that macro and also plays a wave file. When I
execute that macro, the wave file plays, but no MsgBox. I've checked the
two items above. There are no disabled items. What should the macros
setting be set to? It's currently at Medium.

Anything else I should check?
 
What about the other check? Does any VBA code run at all?

Unless you have signed the project, macro security needs to be set at Low or Medium. Restart Outlook if you changed it.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
No VBA code runs at all. Macro security setting is at Medium, and has
always been there. Anything else for me to check?

What about the other check? Does any VBA code run at all?

Unless you have signed the project, macro security needs to be set at Low or
Medium. Restart Outlook if you changed it.
 
OK, I saw in one of Sue's articles that by hitting Alt-F8, it would take you
to your macros, and I did that instead of my usual path of going to Tools |
Macros | Macro. By doing that, it popped up a dialog telling me that macros
were disabled. When I enabled them through this interface, then they
started running. I could have sworn I had enabled them properly before, but
I guess you can't argue with results! So now they are working...
 
Shut down Outlook. Make sure it's really shut down in Task Manager. Shut down any PDA sync or fax program that might be using Outlook. Then restart and try again.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
Back
Top