How to track email using Mail merge from Docs using Another Sheet Data Add on
Updated: January 11, 2023
1. You need to insert an Email Status column into the Google Sheet file
Mail merge will write email status in this column. Only premium user can track email status 2. Choose Email Status Column
Go to Mail Merge Campaign menu, choose Track Email Status Column column
3. Send Mail Merge Campaign
Choose Email Address column and enter all necessary information and click Send button to send mail merge campaign
Sent Time will be updated in the Email Status column
4. View Open Email Status
After several days, you want to view how many emails are openned and when they are viewed. Click on Tracking Email Status menu
Click on Refresh Email Tracking Status button of Tracking Email Status form
Email Status will be automatically updated in the Email Status column. For example, Hoang Hai Anh just opened email seven minutes ago. The Mail Merge Campaign status will be shown as the following: