When sending an e-mail from an Access program using 'DoCmd.SendObject', and using 'False' for the 'EditMessage' option, Outlook Express still requests an answer to 'Send' or 'Don't Send' before transmission. Is there a way of sending the e-mail from Access so that it is transmitted automatically? Alternatively is there a way of switching off the Outlook Express message?
I am using Access 2007 and Windows XP. I am an experienced user.


 

---

Answer from Richard Rost:

There is no way that I know of to bypass the Office 2007 security popup that appears when you try to send automated email. That's a security "feature" that Microsoft insisted upon to cut down on spam. If you want to send automated BULK email from Access without the annoying prompt, you'll either need a third-party email solution OR an older copy of Office. I still keep Office 2000 on one of my machines JUST to send bulk emails to my customers using Access/Outlook.