Target and segment your contact list with our three methods: With filters from Google Sheets, by hiding rows, and/or by adding a zero (0) under the 'Merge status' column from your spreadsheet.
Method 1: Send your email only to filtered rows
First, add filters in your spreadsheet. Click cell A1, then the 'Filter' button from your Google Sheets toolbar:
Once done, 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 filtering on 'Yes', YAMM will notify you and make sure that only the filtered rows will be processed:
When you go back to your spreadsheet and remove the filters, you will see the mention 'EMAIL_SENT' only on previously filtered rows (3, 5 & 6), 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' 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 picture above, an email will be sent to rows 2, 4 & 5 (where the cells are empty under 'Merge status'), but not to rows 3, 6 & 7. Also note that the rows with the tags 'EMAIL_SENT', 'EMAIL_OPENED', 'EMAIL_CLICKED' or 'UNSUBSCRIBED' already applied will be skipped as well. Learn more about this feature in this article.
Like for the Google Sheets filters, you'll see a notification if we find rows that should be skipped.
Comments
8 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
Please sign in to leave a comment.