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:

Do you like what we offer? Please consider buying us a few coffees:

***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:

********** SOFTWARE I USE FOR RECORDING AND EDITING **********
Screen & Audio Recorder & Video Editor (20% discount on first year subscription):

Microsoft 365

********* Let’s connect *********

#excelspreadsheetsupport #exceltutorials #excelvba #excelvbatutorial

[helenasvensson]

Fantastic! Exactly what I was looking for! Thank you!

[laura-jeannuno]

Wonderful. Is there a way to have it send on specific date?

[mailyngabionza]

Thank you so much for this.. very helpful.. 😊😊😊

[dhawalghia]

Hi Team, thanks for this video. I need one help. If some one sends me a request and i want to send him an auto email reply saying "Hi we have ack the receipt of your mail. Someone from the team will revert on your request. Kindly note the ticket number 0001" can we automate this and once the ticket is closed then he will get the email "Hi your ticket number 0001 has been closed". How can we do this using excel and outlook ?

[diegoortuso]

Good morning, I'm wondering if the VBA code for the video can be downloaded.

[ajaystomar]

how can we send it to multiple email ID's individually ?

[louiselansbury]

Hi I am stuck on >Display, when I press enter it gives me compile error: Expected: Line number or label or statement or end of statement. Why is this happening please? I am very new at this. Thanks

[RjHridoyBD]

But how to send same with gmail software.

[diegoortuso]

Buonasera vi chiedo se il codice si può scaricare

[kingprovise]

i already encoded it. why it wont work. my excel version is 2007