Hidden Names Appear in Word Mail Merge

MORE INFORMATION

The _FilterDatabase name can be used to filter the Microsoft Excel version 5.0 list. Because the _FilterDatabase creates a list of data where the records that have been filtered out are blank, Microsoft Word version 6.0 must use only non-blank entries.

Using a Microsoft Excel Filter with a Word Mail Merge

To use the filtering capabilities in Microsoft Excel version 5.0 to perform a Mail Merge in Word, do the following:

1. Use the desired filter with the worksheet.
2. Save the worksheet.
3. In Microsoft Word version 6.0, choose Mail Merge from the Tools menu.
4. Create the main document.
5. From the Get Data list, choose Open Data Source.
6. Select the Excel Worksheet option, and choose OK.
7. Select the _FilterDatabase name, and choose OK.
8. Choose the Query Options button.
9. From the Field list, select any field that has data in every record.
10. From the Comparison list box, select the Is Not Blank criteria.
11. Choose OK.
12. Merge the data with the document.

CAUTION: This procedure may not be available in future versions of Microsoft Word. Manually changing or deleting reserved names in Microsoft Excel version 5.0 may cause unexpected behavior with the program.