Outlook Email

[mlr0911]

I am sending a mass report to different people based off of my query. However, I am getting the following message after 5 emails have been sent.

"A Program is trying to automatically send e-mail on your behalf. Do you want to allow this?"

Since I built my database to run a SQL automatically and email each person a report based off of the SQL, I don't want any manual intervention. How can I work around this issue? I know that this is an issue with Outlook and thought that I had a workaround earlier, but I can't seem to find it or get anything to work from Googling.

I am using the docmd.sendobject command.

Thanks for your time.

 

[pbaldy]

You only get it after 5 emails have gone out? If you get that warning, it should be on each email. In any case, I've used a free program called ClickYes to get around it. There's also Outlook Redemption, CDO, and probably others.

 

[nikalopolis]

take a look at this, it should explain what happened as a result of MS updating the security model in Outlook
http://www.outlookcode.com/article.aspx?ID=52

if you are running in an Active Directory environment then you can do this group policy
http://support.microsoft.com/kb/885682

 

[nikalopolis]

looking around the site i found this thread within this forum.
looks like using mapi can avoid all of the grief with outlook object model.
http://www.access-programmers.co.uk/forums/showthread.php?t=131584