You can segment your list and send emails to specific recipients via 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
You can choose the recipients that will receive your email simply by filtering the rows from your spreadsheet.
First of all, you need to add filters in your spreadsheet. Click on cell A1, then click on the 'Filter' button from Google Sheets editor:
Once done, you should be able to see 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
This method is useful when you have a big spreadsheet with many recipients, and want to send only to a part of them without the need to filter on a specific criteria.
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 Sheets filters, you'll see a notification if we find rows that should be skipped.
Note: This method can also be used to send your campaign to the remaining recipients from your spreadsheet without sending duplicates to those who already received your email. In that case, simply delete the '0' under the 'Merge status' column, and start your mail merge as usual. But don't delete the other mentions (EMAIL_SENT, EMAIL_OPENED etc.)!