How to create VBA code in Excel to send Emails through Outlook automatically | VBA
HTML-код
- Опубликовано: 4 июн 2024
- 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
Thank you :) Helped me a lot
Thanks, I like it. good job
Thanks, you have helped me a lot man
Happy to be of service 🙂
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
Thank you so much for this.. very helpful.. 😊😊😊
My pleasure, glad it helped 🙂
Good morning, I'm wondering if the VBA code for the video can be downloaded.
how can we send it to multiple email ID's individually ?
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 ?
Buonasera vi chiedo se il codice si può scaricare
But how to send same with gmail software.
i already encoded it. why it wont work. my excel version is 2007
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.