How to track email using Mail merge from Docs using Another Sheet Data Add on

Updated: January 11, 2020

1. You need to insert an Email Status column into the Google Sheet file
Insert email status column
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
    choose email status column
    3. Send Mail Merge Campaign
  • Choose Email Address column and enter all necessary information and click Send button to send mail merge campaign
    send mail merge campagin
  • Sent Time will be updated in the Email Status column
    sent time
    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
    track email status menu
  • Click on Refresh Email Tracking Status button of Tracking Email Status form
    track email status button
  • 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:
    openned status