We have just upgraded from Office 97 to 2003.

I have an Excel macro that sends an email with Outlook to inform of client changes. This worked fine in 97, but in 2003 you now get a message box saying:

You have a program trying to access addresses stored in Outlook. Do you want to allow this?

If you choose the Yes button 3 times it works, but choosing No brings up a VB error. I have tried reducing the security level in Outlook, but the message still appears.

Is it possible to hide this box and get it to choose Yes by default?

Paul