When you run a mail merge in Word, you often need to send documents to only a subset of your data source — for example, customers in a specific city or invoices over a certain amount. Manually deleting rows from your Excel or Access file is risky because it alters your original data. Word provides built-in filtering tools inside the Mail Merge Recipients dialog that let you include or exclude records without changing your source file. This article explains how to apply filters by field values, use comparison operators, and combine multiple conditions so you send the right document to the right people every time.
Key Takeaways: Filtering Mail Merge Recipients in Word
- Mailings > Select Recipients > Edit Recipient List > Filter link: Opens the Filter and Sort dialog where you set field-based conditions.
- Field, Comparison, Compare To columns: Define which data field to test, which operator to use (Equal to, Greater than, etc.), and the value to match.
- And / Or logic between rows: Combine multiple filter conditions to narrow recipients by more than one criterion.
How Mail Merge Filtering Works in Word
Mail merge filtering does not delete or modify your original data source. Word reads the source file each time you merge, and the filter acts as a set of rules that tells Word which records to include. You apply the filter inside the Mail Merge Recipients dialog, which is available after you connect to a data source such as an Excel worksheet, Outlook contacts, or an Access database.
The filter uses a simple grid with three columns: Field, Comparison, and Compare To. The Field column lists the column headers from your data source. The Comparison column contains operators such as Equal to, Not equal to, Less than, Greater than, and Between. The Compare To column holds the value you want to match. You can add multiple rows and connect them with And or Or logic. And means both conditions must be true for a record to be included. Or means at least one condition must be true.
A common prerequisite is that your data source must have column headers in the first row. If your Excel table has no header row or uses merged cells, Word may not recognize the field names, and the filter options will appear blank or show generic names like F1, F2. Ensure your data is in a flat table format with unique column names.
Steps to Filter Recipients in a Word Mail Merge
- Open the Mail Merge Recipients dialog
On the Mailings tab, click Select Recipients and choose your data source (Use an Existing List, Select from Outlook Contacts, or Type a New List). After you select the file, click Edit Recipient List in the Start Mail Merge group. - Click the Filter link
In the Mail Merge Recipients dialog, click the Filter link at the top right. This opens the Filter and Sort dialog with the Filter Records tab selected. - Set the first filter condition
In the Field column, choose the data field you want to filter by — for example, City or Total Amount. In the Comparison column, select an operator such as Equal to or Greater than. In the Compare To column, type the value you want to match — for example, Chicago or 500. - Add additional filter conditions
To filter by more than one field, click the next row in the Field column. Choose And if the record must meet all conditions, or Or if it can meet any condition. Then set the second field, comparison, and value. - Apply the filter and verify the results
Click OK to close the Filter and Sort dialog. The Mail Merge Recipients dialog now shows only the records that match your filter. Check the count at the bottom of the dialog to confirm the correct number of recipients.
If the Filtered List Does Not Show Expected Records
“The Filter Dialog Shows No Field Names”
If the Field column is empty or shows F1, F2, your data source does not have column headers in the first row. Open your Excel file and ensure the first row contains unique field names. Remove any blank rows or merged cells above the header row. After saving the file, reconnect to it in Word by clicking Select Recipients and choosing your file again.
“The Filter Removes Records I Want to Keep”
Check the logic between filter rows. If you used And when you needed Or, records that match only one condition will be excluded. For example, filtering City Equal to Chicago And State Equal to IL will exclude any record where the city is Chicago but the state is blank or different. Change And to Or if you want records that match either condition.
“The Compare To Value Must Be Exact”
Word filters are case-insensitive but require an exact match for text values unless you use the Contains or Does not contain operators. If you type Chicago but the data has Chicago with a trailing space, the record will not appear. Use the Contains operator to match partial text, or clean your data source before merging.
Word Mail Merge Filtering: Methods Compared
| Item | Filter via Edit Recipient List | Filter via Query Options |
|---|---|---|
| Access path | Mailings > Edit Recipient List > Filter | Mailings > Edit Recipient List > Filter and Sort > Filter Records |
| Number of conditions | Up to 6 rows with And/Or logic | Same dialog — identical limit |
| Data source modification | None — original file unchanged | None — original file unchanged |
| Supports wildcards | No — use Contains operator instead | No — use Contains operator instead |
| Best use case | Single or two-field filters | Same — no difference in capability |
You can now filter recipients in a Word mail merge using the built-in Filter and Sort dialog. To test your filter before printing, click Preview Results on the Mailings tab and step through the records. For advanced filtering across multiple data sources, consider sorting your data in Excel first with a helper column, then merging only the visible rows. This approach gives you more control over complex logic that Word’s six-row limit cannot handle.