Confirmation when sending email from MS Access through Outlook XP

[royaltg]

I've got a Access XP database that sends email via Outlook XP after it finishes certain tasks. I use the "docmd.sendobject" method, and it works except for the fact that I get a message box that pops up and says "A program is trying to automatically send email on your behalf. Do you want to allow this?" You have to choose "yes" to get your email sent (the yes button isn't enabled for five seconds).

Does anyone know how to turn off this feature? If not, does anyone know how to go around it? Can you use SendKeys to tell Outlook it's OK?

Is there an alternative to using the sendobject function?

 

[mp9]

You need Outlook Redemption - check out

http://http://www.dimastr.com/redemption/

for more info on this excellent freeware product.

And no, I'm not affiliated with this product in any way, so this isn't an ad!

http://www22.brinkster.com/accessory/