Article ID: 286879 - View products that this article applies to.
This article was previously published under Q286879
When you attempt to change the filter in the Mail Merge Recipients dialog box in Word, the columns that you filtered previously do not appear to be filtered (for example, the arrow is black, not blue). When you attempt to remove the filter by clicking All in the filter list, the hidden records are not displayed.
When you click any column header to sort the records by that column, nothing happens.
This behavior can occur when the following conditions are true:
Note In some cases, Word is able to replace the spaces in field names with an underscore (for example: "Zip Code" should become "Zip_Code") to avoid this problem.
If the data source is a Contacts folderTo retrieve the filtered records, re-select the recipients from your data source. To re-select your data source, follow these steps: To retrieve the filtered records, re-select the recipients from your data source.
If the data source is an Access database or an Excel workbookModify the data source column header that contains spaces.
You may be able to resolve the issue by modifying the column header in your data source so that the column header does not contain spaces.
For example, if a column header is named Zip Code, you may be able to resolve the issue by naming the column header Zip_Code.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Contact us for more help
Connect with Answer Desk for expert help.