Sending Gmails using Excel VBA
Bottom Line: Learn how to send Gmails using Excel VBA , with attachments and body text, to predefined or dynamic list of recipients. Important aspects such as configuration changes, that need to be done in Gmail and Visual Basic Editor , for the code to work as expected, are also covered here. Note : Macro Template and other useful links related to Gmail configuration changes are included within/at the end of the post. Please make use of them. Skill Level: Beginner Sample File: VbaToSendGmail.xlsm Prerequisite: Basic VBA Hands-on knowledge Gmail configuration changes Enabling Microsoft CDO for Windows 2000 Library 1. Basic VBA Hands-on knowledge: Assuming you already have some basic knowledge on how to enable Developer option, accessing different objects in Visual Basic Editor and basics programming knowledge, providing some useful links relevant to the topic. Please go through the below links to quickly brush up the concepts: Getting starte...