Merge Specific Rows

How do I filter and track specific rows to mail merge?

From the Google Docs Add-on

Step 1

In Google Sheets, create a column in your sheet and name it whatever you want, e.g. Filter Rows to Merge.

Step 2

Type 'x' (or any other text ) in the rows you wish to exclude from merging.

Step 3

In Google Docs, open the Options window by clicking the button in the Mail Merge sidebar.

Step 4

Select the Filter Rows to Merge column for the Track Merged Rows and Merge Specific Rows fields.

Step 5

Click Save to apply changes.

NOTE: After a merge takes place, the empty values in the Filter Rows to Merge column are replaced by the date/time the merge took place. To merge these rows again, you need to clear/delete the date/time values.

From the Google Sheets Add-on

Step 1

In Google Sheets, when you start Mail Merge, a column called Filter Rows to Merge will be automatically created for the sheet you want to merge data from.

Step 2

Type 'x' (or any other text ) for the rows you wish to exclude from merging.

NOTE: After a merge takes place, the empty values in the Filter Rows to Merge column are replaced by the date/time the merge took place. To merge these rows again, you need to clear/delete the date/time values.

Advanced Feature: Formula to Exclude Rows from Mail Merge

As shown in the image below, instead of just typing 'x' to exclude rows, you can even create a formula in Google Sheets to determine which rows should be excluded. In this example, rows for employees whose gender is equal to "F" are excluded.