How to Send Emails From Excel Using Gmail & VBA. Code: ‘Set a reference to Microsoft CDO for Windows 2000 Private Sub CommandButton1_Click() Dim Mail As New Message Dim Config As Configuration: Set Config = Mail.Configuration Config(cdoSendUsingMethod) = cdoSendUsingPort Config(cdoSMTPServer) = “smtp.gmail.com” Config(cdoSMTPServerPort) = 25 Config(cdoSMTPAuthenticate) = cdoBasic Config(cdoSMTPUseSSL) = True Config(cdoSendUserName) = “youremail@gmail.com” Config(cdoSendPassword) = “yourgmailpass

📩 Still sending emails manually from Excel? That ends today. → https://www.excelforfreelancers.com/automated-email-marketing-fb-page I’ll show you how to build your own automated email system using Excel VBA — with personalized emails, campaign scheduling, contact management, and more. All in one workbook. ⚡ Works like Mailchimp. But it’s Excel. And it’s free. 🎁 Includes a free template so you can follow along and build it fast. 👉 Watch the training download your free workbook now #ExcelEmail