MACRO TO GENERATE AN EMAIL

[Darrin]

When the macro is launched in Access, it is suppose to
launch an email. I receive an Outlook warning box
stating "A program is trying to automatically send e-mail
on your behalf. Do you want to allow this?"

The problem with this is that there is a time delay before
the option of 'Yes' is available to be selected. is there
a way to skip this warning box and allow the emails to be
sent?

 

[Steve Schapel]

Darrin,

This is the result of a security feature of Outlook, and has nothing to
do with Access or with your database. As far as I know, it can't be
disabled in Outlook, although a post to an Outlook newsgroup may get you
a more authoritative answer on that. I know some people have had good
success with using a third-party utility called ClickYes to handle this.
See http://www.contextmagic.com/express-clickyes