How to create VBA code in Excel to send Emails through Outlook automatically | VBA

Send your emails automatically from Excel via Outlook using VBA. Only 5 Steps to make this happen. A detailed step by step instruction is provided in this tutorial, as an Excel user you only need to know the basics to creating a macro, how the WITH operator is used and defining variables.

Practice Workbook: https://excelspreadsheet-support.com/...

Do you like what we offer? Please consider buying us a few coffees: https://ko-fi.com/excelspreadsheetsup...

**TIMESTAMPS**
0:00 What to expect in this tutorial
0:30 Step1 - Creating a new empty email with Excel VBA
3:02 Step2 - Adding TO/CC/BCC and Subject line to the Email created
4:36 Step3 - Adding the Body Text to the Email created
11:15 Step4 - Adding Attachments to the Email created & How to find the full address of the files you want to attach
13:27 Step5 - Navigating between SEND/DISPLAY/SAVE and changing the FROM address if you have more than 1 email address setup in Outlook
17:44 What to expect in the next tutorial

EMAIL US:
[email protected]

********* SOFTWARE I USE FOR RECORDING AND EDITING *********
Screen & Audio Recorder & Video Editor (20% discount on first year subscription):
https://screencast-o-matic.com/refer/...

Microsoft 365
https://microsoft-us.evyy.net/c/23790...

******** Let’s connect ********
LinkedIn:   / excel-spreadsheet-support  
Facebook:   / excelspreadsheetsupport  
Our Website: https://excelspreadsheet-support.com

#excelspreadsheetsupport #exceltutorials #excelvba #excelvbatutorial