Use Word mail merge to send emails, with all the missing features added back in. Features like adding attachments, having a custom subject, using the CC and BCC fields, using "Send As" (e.g. send as the CEO, you know you want to), and best of all you can save to drafts to check the emails before they go out.

We take you through how to add in a Word macro, set up your data, and create a set of emails. At the end we will also go through the VBA code.

Macro code is found on our website here: https://imnoss.com/enhanced-mail-merg...

0:00 Introduction
3:13 Initial setup
3:42 Setting up the email template in Word mail merge
4:28 Adding the macro to Word
6:56 Prepare the mail merge data in Excel
19:34 First run of the macro, creating emails in draft and reviewing
21:55 Second run of the macro, sending emails immediately
22:55 Reviewing the macro code line by line
37:30 Thanks for watching