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

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

Рет қаралды 21,448

Күн бұрын

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: excelspreadsheet-support.com/...
Do you like what we offer? Please consider buying us a few coffees: 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:
info@excelspreadsheet-support.com
********* SOFTWARE I USE FOR RECORDING AND EDITING *********
Screen & Audio Recorder & Video Editor (20% discount on first year subscription):
screencast-o-matic.com/refer/...
Microsoft 365
microsoft-us.evyy.net/c/23790...
******** Let’s connect ********
LinkedIn: / excel-spreadsheet-support
Facebook: / excelspreadsheetsupport
Our Website: excelspreadsheet-support.com
#excelspreadsheetsupport #exceltutorials #excelvba #excelvbatutorial

Пікірлер: 16

@OnlyOnyinye-vp2gf 2 ай бұрын

Thank you :) Helped me a lot

@mixtape8476 Жыл бұрын

Thanks, you have helped me a lot man

@excelspreadsheetsupport Жыл бұрын

Happy to be of service 🙂

@rrki Жыл бұрын

Thanks, I like it. good job

@mailyngabionza Жыл бұрын

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

@excelspreadsheetsupport Жыл бұрын

My pleasure, glad it helped 🙂

@diegoortuso6304 4 ай бұрын

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

@dhawalghia 6 ай бұрын

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 ?

@ajaystomar4842 2 жыл бұрын

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

@dadada3195 2 жыл бұрын

@diegoortuso6304 4 ай бұрын

Buonasera vi chiedo se il codice si può scaricare

@RjHridoyBD Жыл бұрын

But how to send same with gmail software.

@louiselansbury 4 ай бұрын

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

@kingprovise418 Жыл бұрын

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

@excelspreadsheetsupport Жыл бұрын

Thanks for your message. Is Outlook already setup with your account and being used on your computer? If yes, can you please send a screenshot of the of the code where the error pops up so I can see what part is not working on the 2007 version as mine was made on version 365.