YAMM makes it easy for you to send emails to remaining rows in your sheet without sending duplicates to former recipients. Read this article to learn 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, for example)
- you have added new recipients to your mailing list
- the add-on stopped for some reason (server errors, YAMM froze, for example)
How to resend your campaign to the remaining rows?
In the following example, we want to send our campaign to the two last rows (row 7 and 8), as the previous ones have already received our emails.
To do so, start your mail merge as usual by selecting Add-ons > Yet Another Mail Merge > Start Mail Merge.
Depending on the information in your Merge status column, one of these pop-up windows opens:
- 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 (zero) 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 that are skipped by YAMM:
- EMAIL_SENT
- EMAIL_OPENED
- EMAIL_CLICKED
- RESPONDED
- BOUNCED
- UNSUBSCRIBED
- 0 (zero) added manually in the Merge status column. Learn more
error EMAIL_NOT_SENT and ERROR are not 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. Make sure you don't delete or modify the merge statuses when sending your next mail merges from the same spreadsheet.
Comments
4 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.
Hola!
Algunos de los envíos tienen como resultado "0". No entiendo a que se debe. Son cuentas de hotmail pero nunca me había psado.
Like Rob Redcay, I do not see either message:
I do have a valid merge status in a number of rows. Is this message just gone, but the functionality still works? I don't want to resend emails to people that have a valid merge status. How should I proceed?
Please sign in to leave a comment.