Avoiding an Outlook message

[Craig]

Hi

I have an Access macro that sends a different Access report to many
different people on Outlook via a Send Object action within the Access macro.

Yet each time the Send Object action is taken during the Access macro run, I
get an Outlook message that states:

"A program is trying to send an e-mail message on your behalf. If this is
unexpected, click Deny...."

I have to click the "Allow" button for each report to be sent while the
macro runs...how can I avoid that and just have reports get sent via the Send
Object action without me having to click Allow?

thank you!

Craig

Note: I sent this also to Outlook VBA programming group and to Access Macro
group as I did not know what group was best to send to...my apologies if I
cross paths.

 

[Brian Tillman [MVP-Outlook]]

I have an Access macro that sends a different Access report to many
different people on Outlook via a Send Object action within the Access
macro.

Yet each time the Send Object action is taken during the Access macro run, I
get an Outlook message that states:

"A program is trying to send an e-mail message on your behalf. If this is
unexpected, click Deny...."

I have to click the "Allow" button for each report to be sent while the
macro runs...how can I avoid that and just have reports get sent via the
Send
Object action without me having to click Allow?

Here are your options with respect to the Outlook Object Model Guard:
http://www.outlookcode.com/article.aspx?id=52

Here's a tool that can help if you can't write the code properly:
http://www.mapilab.com/outlook/security/