Sending Out Bulk Email with Personalized Content and Certificate to multiple recipients at once
In this video, I will show you how to sending out bulk email with personalized content and individual certificate (pre-generated) to multiple recipients at once.
👋 Resources called out in this video:
1) Google Account
2) Google Addons - File Cabinet (by Awesome Table): https://ss88.my/file-cabinet
3) Microsoft Excel: https://ss88.my/excel
4) SendInBlue Account: https://ss88.my/sendinblue
⌚ Timestamps:
0:00 Introduction
01:29 Preparation
02:05 Steps Required
02:13 [Step1] Database Contacts Preparation (Excel)
03:15 [Step2] Upload Certs to Google Drive - specific folder
03:52 [Step3] Install & Activate Files Cabinet (Google Addons)
05:40 Create Google Sheet to List Out all Path
08:10 Tip: All Certificates Share Permission change to "Anyone with link"
08:48 [Step4] Copy Cert View Path to Database (Excel)
10:20 [Step5,6] Import Contacts (database) to SendInBlue
11:45 Database Mapping
15:20 [Step7] Setup Email Merge Fields & Create New Email Campaign
19:20 Mail Merge Specific Setup
21:45 Broadcast to pre-scheduled time
23:30 Broadcast Email Campaign Report
24:00 Wrap Up
🎁 To bulk generate certificates (using Microsoft Word & Excel), refer my previous video:
https://ss88.my/w4BP
🚩 Connect with me on social:
ss88 (Social Bio Link) : https://ss88.my/u/technologysimplicity
Facebook: / technologysimplicity
Instagram: / technologysimplicity
LinkedIN: / technology-simplicity
🔔 Subscribe to my YouTube channel
https://ss88.my/BVCg
🎬 Want to watch again? Navigate back to my YouTube channel quickly
https://ss88.my/ts-youtube
💝 Support me with your Google Play Book purchase https://ss88.my/pshX. (Purchasing through this link gives me a small commission to support videos on this channel -- the price to you is the same)
🤝Special thanks to the people who assisted me along the journey:
1) Transition Animation Powered by KenFX Studio