troubleshooting Question

Sending emails from an MS Access MDB . . . bypassing Outlook Security...

Avatar of BCreen
BCreen asked on
Microsoft AccessMicrosoft Applications
10 Comments1 Solution645 ViewsLast Modified:
How do I bypass the message: "A program is trying to automatically send e-mail on your behalf. Do you want to allow this?"  This appears when I execute the folowing VBA code:

DoCmd.SendObject , , , "bcreen@American-services-inc.com", , , "Nightly-Run - Your attention is requested!", strMsg, False

strMsg is a message string for the body of the email.

THIS USED TO WORK FINE!  I suspect a security patch (for Outlook) no longer allows this.  There are 3rd-party "Outlook Security managers" available for purchase, which alegedly allow you to place a few lines of code into your VBA, to bypass this problem.

Is there a way to do this differently, without paying for a 3rd party solution?
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 10 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 10 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros