Automating Emails

[grenee]

Good Day all,

I am writing a procedure to generate and send emails to various persons by one mouse click. Each person is to receive a unique document.

My problem is that Outlook pauses me for every mail, making the process a manual one. I want all the emails to go by one mouse button click.

Can anyone provide a solution?

This is the pop up message from Outlook:

The program is trying to send an email message on your behalf. If this is unexpected press Deny and verify your antivirous software is uptodate.

 

[pr2-eugin]

Well this is a well known problem, this feature was added in Outlook 2007 and up, if I am correct. You can use Third Part software or use CDO.

 

[grenee]

Thanks for the info. But what is CDO and can you recommend any 3rd party software

 

[grenee]

Thanks for the info. But just what is CDO and can you recommend any 3rd Party software?

 

[pr2-eugin]

Here is how you send email from Access VBA using CDO (Collaboration Data Objects) : http://www.blueclaw-db.com/access_email_gmail.htm

I would not go for Third party myself. Here is some info. http://www.outlook-apps.com/disable-outlook-security-warning/

 

[spikepl]

Using Redemption is popular way of bypassing the Outlook warning - google it. It's not free.

I think this is yet another example of collusion between Microsoft and the industry: Microsoft introduces features, and the rest of the industry makes a living countering the "features". Here at the AWF forums, we fight multivalued fields, spaces and weird characters in object names, etc etc

 

[Mile-O]

In Access/Outlook 2010, I just add a reference to the Outlook library from Access, and use VBA to send emails. Don't get given the Outlook warning, like I used to back in the Access 2000/2002 days.