Email warning - 5 second delay

  • Thread starter Thread starter Shelley Ventura
  • Start date Start date
S

Shelley Ventura

We finally upgraded to XP and Access 2002 this past
weekend. Quite a few of my operations use the
docmd.sendobject function to send emails automatically.
Now we get this warning every time that code is
encountered with a five second delay to say "YES, I meant
to send that!" How do I turn that warning off?

Thanks, Shelley
 
Shelley Ventura said:
We finally upgraded to XP and Access 2002 this past
weekend. Quite a few of my operations use the
docmd.sendobject function to send emails automatically.
Now we get this warning every time that code is
encountered with a five second delay to say "YES, I meant
to send that!" How do I turn that warning off?

I think it can only be turned off if you are using Exchange Server and then
it is your Exchange admin that can change a setting to turn it off.
Otherwise you have to automate a different Email client.

Do a web search for a product called Redemption to see if that might work
out for you. It utilizes the CDONTS library instead of standard CDO and
has the ability to "get around" the security warning. There is also a free
utility available that essentially presses the [OK] button for you, but you
still have to wait the five seconds.
 
The easiest work-around that I have found is to install the free ClickYes
utility found at:

http://www.express-soft.com/mailmate/clickyes.html

This utility has been extremely helpful in applications that send
individualized emails or which have to run unattended. It can be
incorporated into VBA code and will automatically click the 'Yes' button of
the security prompt. The writers of this software have included code at
their website which shows you how to turn the Utility on and - most
important - turn it off from within your code. (The biggest "problem" I
have had in using this utility is to train my users to keep their hands off
the mouse.)

hth,
 
Thanks for the information on ClickYes.

It took less than fifteen minutes to download, install and
integrate it into an Access application.

Oh Goody! One less button to click.

Thanks again.

Rand
 
Back
Top