VBA to eliminate Microsoft Outlook’s dreaded "security warnings".

Examples of using Redemption library in Access.
https://www.experts-exchange.com/questions/26236829/retrieving-messages-from-Outlook-Outlook-express.html
https://www.experts-exchange.com/questions/25474771/Send-email-to-send-on-behalf-email-address.html

Example of using CDO to send messages and not using Oulook at all
https://www.experts-exchange.com/questions/24987051/Sending-emails-from-an-MS-Access-MDB-bypassing-Outlook-Security.html

Outlook Redemption website
http://www.dimastr.com/redemption/
see there for more examples.


OM Gang

Is this what you are looking for:

http://www.dimastr.com/redemption/

?

mx

For automation, I understand that I need to use the Redemption library but can you please provide a VBA example of how to turn off the "security warnings" message?

CFMI, as Peter says and what I said in my first post you cannot do it. The link I gave you in my initial post gives you three options that you can use, what others have also said. So either use 3rd party s/w like ClickYes, use Redemption or use CDO or live with the security message.

Another option:MAPILab Advanced Outlook Securityhttp://www.mapilab.com/outlook/security/A free COM add-in for Outlook.  I am using it now and I like itI've used both Click Yes and Redemption in the past, and liked them both.

"dreaded " is a strong word.
;-)

This security is there for a reason, ...to protect users form malicious code sending out emails.

If your code is digitally signed, this "Dreaded" alert would be irrelevant.
http://support.microsoft.com/kb/286159

;-)

JeffCoachman

In other words,...

It is only "dreaded" because it keeps popping up and is annoying.

If you set up your database and security correctly (following any of the Experts advice above)

Then it is never an issue...

;-)

JeffCoachman

Thank you very much!