Send personalized bulk emails for free

Hi! I blogged about mail merge a while ago and I keep getting private messages from people asking how to send personalized bulk emails to clients, potential investors, etc. So I decided to make a video of the entire process, for posterity 😁. You can use this method to message your clients about promotions, upcoming events, fundraising drives, and so on.

Chapters:
Intro: 00:00
Get a copy of the mail merge sheet: 01:05
Customize the sheet: 01:52
Send test email: 04:56
Create the email draft: 05:15
Explaining the double curry brackets or markers: 05:49
Copy the subject line form email draft: 08:16
Click Mail Merge in the Google Sheet and authorize the Mail Merge: 08:30
Click Mail Merge again and paste the email draft subject line: 09:03
Run the script: 09:49
Check your email inbox: 10:00
Outro: 10:35

Please note: After a successful test email, you can proceed to add the details of all the other email recipients.

Don't forget to like, comment and subscribe if you are interested in more content like this.

#MsExcel #GoogleSheets #MailMerge

Who am I?
A health professional turned data scientist who really just loves living my best life and using technology to solve problems. I use a variety of software in my work, so every now and then I like to share what that looks like. On this channel, I will share anything that constitutes work-life balance. Could be an Excel video one week, and a mountain hike the next week. Please stick around if this might interest you; otherwise, I am glad you made it thus far.
Cheers!

[mrsmay]

Thank you for sharing and educating us!