Скачать или смотреть Send Bulk Email (Excel VBA) & the Whole Emailing Process

If you have to email documents to your clients every once in a while (and there are hell a lot of them!) & this whole repetitive process is taking a toll on you, this tutorial is for you.

What tools we use:
// Excel - VBA Code
// Outlook

What you're going to learn:
// How to gather & link all the informations in Excel:
Email addresses
Email subjects
Email contents
Attachment
// By just clicking a button in Excel, it will send out all the emails for you.

Sample Excel template & sample documents can be obtained here (Google Drive link): https://shorturl.at/bjMU0

0:00 Introduction
0:51 Send Bulk Email Excel
3:19 Step 1 - Master Data
4:00 Step 2 - File Name
7:14 Step 3 - VlookUp
11:52 Step 4 - Send Bulk Email
14:52 - Change VBA Code