Filter More Than Six Fields for a Word for Mac Mail Merge
Question details
Filter a Word for Mac mail merge data source using eight or more fields.

- Product
- Microsoft Word for Mac
- Device & OS
- macOS
- Scenario
- The user needs to select mail merge recipients using more filter fields than the Word query dialog offers.
- Observed behavior
- The Mail Merge Query Options window provides only six filter levels.
Locate the mail merge data source and identify the fields and conditions you need to apply. If the source is not already an Excel workbook, open or export the data in a format Excel can read.
Filter the recipient data in Excel before the Word mail merge
Use Excel to apply all required conditions, then connect Word to a workbook containing only the matching records.
Filters applied to different Excel columns normally work together as AND conditions. For more complex AND/OR logic across fields, create a helper column with a formula that returns TRUE for matching records, then filter that column for TRUE.
Open the recipient workbook in Excel and check that the first row contains the field names needed for the merge.
Select the data range, choose Data > Filter, and use the column filter arrows to apply your conditions to eight or more fields. If necessary, add a helper formula and filter its results for TRUE.
Select the filtered range, including its headers. Use Home > Find & Select > Go To Special > Visible cells only, then copy the selection and paste it into a new workbook. Check that the new workbook contains the headers and only the intended records.
Save the new workbook as an Excel file. In Word for Mac, open the merge document and choose Mailings > Select Recipients > Use an Existing List, then select the filtered workbook and its worksheet.
Use Mailings > Preview Results to check the recipients and fields, then choose Finish & Merge. After confirming the merge is complete, delete the temporary workbook if you no longer need it.

Prepare Mail Merge Data with WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with documents and spreadsheets. Open compatible Microsoft Office files and use WPS Spreadsheets to prepare recipient data; switching apps does not change Word's filter limit.

Frequently Asked Questions
Can I add more filter levels in Word for Mac's Mail Merge Query Options?
The dialog provides six filter levels. To use more conditions, filter the source data in Excel and connect Word to a workbook containing the matching records.
How do I prevent hidden Excel rows from being copied into the merge list?
Select the filtered range and use Home > Find & Select > Go To Special > Visible cells only before copying. Paste the selection into a new workbook and check the records.
How can I filter for an OR condition across different columns?
Add an Excel helper column with a formula that evaluates the conditions for each row, such as an OR formula. Apply Data > Filter to that column and select TRUE, then copy the matching rows.
How do I use the filtered workbook in Word?
In the Word merge document, choose Mailings > Select Recipients > Use an Existing List. Select the saved workbook and worksheet, then use Preview Results to verify the merge.




