How to create VBA code in Excel to send Emails through Outlook automatically | VBA
21.8 هزار بار بازدید -
4 سال پیش
-
Send your emails automatically from
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://learnhowto.excelspreadsheet-s...
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: LinkedIn: excel-spreadsheet-support
Facebook: Facebook: excelspreadsheetsupport
Products & Services: https://excelspreadsheet-support.com/
Portfolio: https://portfolio.excelspreadsheet-su...
How-To Lessons: https://learnhowto.excelspreadsheet-s...
#excelspreadsheetsupport #exceltutorials #excelvba #excelvbatutorial
Practice Workbook:
https://learnhowto.excelspreadsheet-s...
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: LinkedIn: excel-spreadsheet-support
Facebook: Facebook: excelspreadsheetsupport
Products & Services: https://excelspreadsheet-support.com/
Portfolio: https://portfolio.excelspreadsheet-su...
How-To Lessons: https://learnhowto.excelspreadsheet-s...
#excelspreadsheetsupport #exceltutorials #excelvba #excelvbatutorial
4 سال پیش
در تاریخ 1399/04/06 منتشر شده
است.
21,875
بـار بازدید شده