YAMM makes it easy for you to send emails to remaining rows without sending duplicates to former recipients. Read this article to know how to do so.
Completing (or resuming) your mail merge on the same sheet without sending duplicates to previous recipients is useful if:
- You sent a first mail merge in your spreadsheet but didn't complete it (because of quota limits or else)
- You have added new recipients to your mailing list
- The add-on stopped for some reasons (server errors, YAMM froze etc.)
info If you want to segment your mailing list and only send to parts of your list, please consult this article: 'Segment your list and only send emails to specific people / rows'
How to (re)send your campaign to remaining rows?
In the following example, we want to send our campaign to the last four rows (row 12 to 15), as the previous ones have already received our emails:
To do so, start your mail merge as usual by going to Add-ons > Yet Another Mail Merge > Start Mail Merge.
Depending on the information under your 'Merge status' column, you shoud then get one of those two pop-up windows:
- 'Rows with a valid merge status will be skipped' if your 'Merge status' column contains 'EMAIL_SENT' or other tracking stats
- 'Only filtered rows will be processed' if your 'Merge status' column contains 0 or if you added filters
Valid merge statuses that trigger YAMM to skip corresponding rows
Here is the full list of all valid merge statuses, which will be skipped by YAMM:
- EMAIL_SENT
- EMAIL_OPENED
- EMAIL_CLICKED
- RESPONDED
- BOUNCED
- UNSUBSCRIBED
- Adding '0' under 'Merge status'. Learn more
error 'EMAIL_NOT_SENT' and 'ERROR' will not be skipped.
warning This feature only works with the valid merge statuses listed above. Any tiny change (even lower case) will break this option, and YAMM might send duplicates. So please make sure you don't delete or modify the merge statuses when sending your next mail merges on the same spreadsheet.
Comments
2 comments
First -- thank you for this software. I love it. I'm just evaluating the free version right now and it's great.
This help article is very pertinent to me. I'm about to send a "second batch" of mails from a spreadsheet that I already sent a "first batch" from yesterday. I want to be sure I won't re-send mail to any in the "first batch." However, when I start the mail merge, I don't see the information which indicates that 'Rows with a valid merge status will be skipped'. Instead, I just get one that says "You don't have enough quota to send all emails now." (screenshot below)
Please note that my "first batch" rows all have a "Merge Status" column with valid values for all records I sent yesterday.
I believe this is all working as expected but perhaps the UI changed a bit and you no longer show the information described in this article. I'd just like your confirmation before sending my second batch. Thanks!
This is helpful except when we want to re-use a data sheet. Then it will only send to those that have not previously been sent to.
Please sign in to leave a comment.