Prob sending email via Automation from Access

[Dave]

All,

I'm trying to send email from MSAccess2K using Outlook2K via
automation. Our WAN has stringent security set up on Outlook, and I'm
hitting a problem I haven't been able to overcome.

When the .Send in my code executes, Outlook responds with a message
"...program is trying to send email ... do you want to allow this?"

If I respond "Yes" to this message, I get a second message "Warning -
cursor must be located on message body"; clicking OK to this message
aborts what Outlook was doing, cancels the pending message, and
returns to my code.

I have also tried using the Access SendObject method, which does not
support as many Outlook options as I'd like.

Does anybody have any suggestions (I have to work within the Outlook
constraints imposed by security, so changing things on that end will
not be an option)?

Thanks
Dave

 

[Sue Mosher [MVP-Outlook]]

See http://www.outlookcode.com/d/sec.htm for your options with regard to the
"object model guard" security in Outlook 2000 SP2 and later versions.