Hello Friends, In this week's training I will share with you something I have never taught before. I will open up the VBA In Outlook and show you the most amazing Email Automation you have ever seen. When you get done with this video and training, you will automatically be able to save your emails AND attachments in Excel. After this 60 minute training you will learn how to: ☑️ Open Excel From Outlook VBA ☑️ Create a macro in outlook each time an email arrives ☑️ Send detailed email data right t

📧 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

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