This article has been archived. It is offered "as is" and will no longer be updated.
When you try to filter a data source in a Microsoft Word mail merge, the filter may not show the correct number of records.
This problem may occur if you filter a data source by using multiple filters.
To work around this problem, use one of the following methods.
Method 1: Use the Advanced option
To use the Advanced option, follow these steps:
In the Mail Merge Recipients dialog box (if your data source is already attached to your mail merge main document, click Edit recipient list in Step 3 of 6 in the Mail Merge task pane), click a down-arrow next to one of the fields (column headings).
In the drop-down menu, click Advanced.
On the Filter Records tab, enter the criteria that you want to use to filter your mail merge.
Method 2: Enter a range filter last
If you use a range filter (such as FieldName is less than 10), enter the range field last after you enter all your other filter criteria.