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) = “[email protected]” Config(cdoSendPassword) = “yourgmailpass

📧 Send emails directly from Excel? Yep. With just a few lines of VBA, you can auto-populate the recipient, subject, body — even add attachments — and fire it off in one click. Outlook will think you hired a secretary. 😉 #ExcelTips #VBACode #ExcelAutomation #ExcelShorts | Excel For Freelancers