SendObject Function

[Arthur Weiner]

I'm using the SendObject function to email reports in
Microsoft Access. Outlook continues to send up a warning
message indicating "A program is trying to automatically
send email on your behalf, do you want to allow this?"

The answer is yes... Is there any way to turn off this
warning?

I've tried the sendkeys function to send a "y" character,
but that doesn't work.

Help please!!

 

[Steve Schapel]

Arthur,

This is not related to Access or to your database directly. It is a
security feature of Outlook. You could try posting a question to one of
the Outlook newsgroups, someone there might have an idea. The only way
I know of getting around it is to use a third-party utility called
ClickYes http://www.contextmagic.com/express-clickyes