Yamm has three methods to target and segment your contact list: with filters from Google Sheets; by hiding rows; and by adding 0 (zero) in the Merge status column of your spreadsheet.
Method 1: Send your email only to filtered rows
Add filters in your spreadsheet: click in cell A1, then select the Filter button from your Google Sheets toolbar.
You should see the filters (little arrows) on your headers.
The following example shows that we want to send an email only to people who have replied in the past.
After applying the filter, YAMM notifies you that Only the filtered rows will be processed.
When you go back to your spreadsheet and remove the filters, you will see the tag EMAIL_SENT only on previously filtered rows (2 and 4 in our example), which indicates that YAMM has correctly skipped the other recipients.
Method 2: Hide some rows to skip these recipients
If you want to send your emails to specific rows, you can hide some rows from your spreadsheet, and YAMM will automatically skip them and will send your campaign only to visible rows.
Method 3: Add 0 (zero) to skip the rows and send your email to the other recipients
If it doesn’t exist yet, add a column named Merge status in your sheet and add a 0 (zero) for all the rows that should be skipped. This option is useful if you don't want to send your mail merge to your whole mailing list.
In the image above, an email will be sent to rows 2 and 4 (where the cells are empty under Merge status), but not to rows 3 and 5. Any rows with the tags EMAIL_SENT, EMAIL_OPENED, EMAIL_CLICKED or UNSUBSCRIBED already applied will also be skipped. Learn more: Resend your mail merge to the rest of your list on the same sheet.
As with the Google Sheets filters, you'll see a notification if we find rows that should be skipped.
Comments
10 comments
Thank-you!
i would like to know that may i able to use unsubscribe link option? with free version?
@shayek ahmed fahim
You can use our unsubscribe feature with YAMM free.
If you have more questions or require assistance, please contact us at support@yet-another-mail-merge.com
Thank you.
Enjoying your software, thanks, until now. :)
When I start a mail merge on an already active 1300 row sheet why does YAMM put '0' in the bottom c.300 blank cells in my 'MERGE STATUS' column, after I remove them, so that no rows will be mailed?
fyi: Most rows in my sheet have YAMM tags from previous merges.
I didn't 'schedule' a follow up mail merge - I wanted to start it manually
thanks!
Dear Sir/Madam,
I want to create Multiple Drafts with same details with some variable items. please help me.
My filter keeps getting kicked out every time I am about to start with the mail merge. Why is that?
nice service, i've looking for. do you have like an purchase order mail merger ?
hay alguna manera de dejar una celda fija como por ejemplo una fecha <<fecha>>? ya que no se repite en todos los campos
Hello.
I have 1 tab open with status, opened, clicked and Email Sent.
Can I use the same tab, to do followups to specific groups and it still track in the same tab?
Hi,
In this scenario, Yes, YAMM will create a new "Merge Status" column and the old one will be labeled to something like "Previous Merge - <date of merge>". We recommend you do a test email campaign and then perform a test follow-up email to see it in action.
Many Thanks!
Jhong
YAMM Support Team
Please sign in to leave a comment.