From: Craig on
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.
From: Brian Tillman [MVP-Outlook] on
"Craig" <Craig(a)discussions.microsoft.com> wrote in message
news:E7886D91-143F-4129-9B30-00C068A8DB2E(a)microsoft.com...

> 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/
--
Brian Tillman [MVP-Outlook]