You can use YAMM to re-send a mail merge, to the same contacts list and with the same email draft, by using the same Google sheet without having to set up a new one.
To use the same Google sheet, you need to clean up the data in the cells of the Merge status column. If tracking was enabled for the previous mail merge, cleaning up the Merge status cells for a contact resets their tracking status which is also excluded from the Tracking Report.
After you re-send the mail merge in which you keep tracking enabled, the new tracking status (sent emails, opened emails, and so on) is again updated for each contact and is included in the Tracking Report.
Prerequisites
The email draft you used with the first mail merge is still available in the Drafts folder in Gmail.
Procedure
- Open your Google sheet.
- Select the contacts to which you want to re-send the mail merge by cleaning up their Merge status cell.
-
- To re-send to all contacts, select all cells in the Merge status column and press Delete to delete their status.
- To re-send only to specific contacts, select only their Merge status cells and press Delete to delete their status.warning Each status deleted under the Merge status column will disable the Tracking Report.
Step result
The Google sheet is now ready. When you send the next mail merge, you will send only to the contacts with cleaned up status in the Merge status column.
- To re-send to all contacts, select all cells in the Merge status column and press Delete to delete their status.
-
- To re-send, select Add-ons > Yet Another Mail Merge: Mail Merge for Gmail > Start Mail Merge.
The Start Mail Merge pop-up opens with the first mail merge's configuration.
- With the pop-up indicating that rows with valid merge status are skipped, click Send emails to re-send only to the contacts whose merge status you cleaned up.
When your new mail merge is sent, a confirmation pop-up appears and the data in the Tracking Report refreshes. - Click Close in the confirmation pop-up.
Result
Your mail merge is now re-sent by using the same Google sheet. The Tracking Report is updated with the new statuses for each contact.
Related articles