Forum Discussion

Copper Contributor

Jan 27, 2022

"Allow / Deny" Dialogue when sending email using MS Access VBA using DoCmd.SendObject thru outlook

When sending email (through Outlook) in MS Access VBA using DoCmd.SendObject I keep getting the "Allow / Deny" Dialogue window for each and every email. I want to send multiple emails programma...

Iron Contributor

Jan 28, 2022

mjbkcks

there are recommendation here:

https://docs.microsoft.com/en-us/outlook/troubleshoot/security/a-program-is-trying-to-send-an-email-message-on-your-behalf

isladogs

MVP

Jan 29, 2022

Alternatively, it is possible to send email direct from Access without using Outlook or other email client.
The method used is called Collaborative Data Objects (CDO).
See my article with an example database you can use for test purposes CDO Email Tester