Excel VBA | Total Automation of Sending eMails

If you just want to automate outgoing email messages using gmail and avoid using sendkeys and the outlook security dialogs. Skip to 17:46 to see the construction of the gmail CDO function.

This video will show a few different methods of sending an eMail using VBA inside of Excel. The final method shown (using gmail CDO) is the recommended method. (As the others may [or may not] work for you.)

Source Code: http://vb4excel.blogspot.com/2013/10/excel-vba-automate-sending-emails.html

Rates : 0