Catch 22 Accessing Outlook?

[KenWK]

Most of what we send out goes via email and we work through a "schedule" set up in Excel. I know how to write code in Excel to check the "Sent Items" in Outlook but as I loop through the messages in the "Sent Items" box in Outlook it displays this message once for EACH MESSAGE in the Sent Items:

"A program is trying to access e-mail addresses you have stored in Outlook. Do you want to allow this?"

I DO want Outlook to be watching other programs like that, but is there any way to "override" that feature through a password or something so that my programs won't cause the above message?

Thanks,
Ken

 

[PHV]

Do a google search for outlook object model guard

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[KenWK]

Thanks PH, tried a few searches but didn't find anything that seemed pertinent. This certainly did the trick.

Now to wade through all the hits!

Thanks again,
Ken