I receive a warning message when creating an email from Access VBA. I have many records, for which I want to create a customised email. I can do all this successfully, but when I execute the commands I receive an message:

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

I would like to switch this off. Can anyone help please.

Paul

Paul

__________________
Paul

Sorry. That can't be turned off. That's a prompt from Outlook to avoid unwanted programs (e.g. worms or viruses) from using Outlook to blast emails.

If you're going to use Outlook, your best bet is to batch the requests so the person responding can allow the "program" to work for up to 10 minutes.

Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group
http://www.pnwadg.org

Thanks for your reply. I have written a LOOP which processes each recipient one at a time. This effectively means that an individual message is sent, one at a time, causing me to respond to Access for each message sent.

Are you suggesting I could batch these messages somehow and thereby reduce the overhead required responding to Access? How could this be done?

Thanks
Paul


Paul

Have you tried looking at the Outlook Redemption Library?

It seems to allow some bypassing of the Object Model Guardian restrictions.

See http://www.dimastr.com/redemption/ for further information.