Document Editing Problems

Filter More Than Six Fields for a Word for Mac Mail Merge

Olivia MillerOlivia Miller Nov 20, 2026 868 views

Question details

Filter a Word for Mac mail merge data source using eight or more fields.

How to Filter More Than Six Fields for a Word for Mac Mail Merge
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the data source

Open the recipient workbook in Excel and check that the first row contains the field names needed for the merge.

2
Apply the filters

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.

3
Copy matching records

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.

4
Save and connect the workbook

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.

5
Preview and finish the merge

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.

Filter the recipient data in Excel before the Word mail merge
Check your field logic: If your conditions include OR across different fields, ordinary column filters alone may not produce the intended results. Use a helper formula and verify the copied recipient list before merging.
Free Microsoft Office alternative

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.

Filter spreadsheet records to prepare a focused recipient listWork with Microsoft Word and Excel formats, including DOCX and XLSXUse a familiar interface for an easier move from Microsoft OfficeAccess document and spreadsheet tools in one lightweight suite
microsoft office alternative - wps office

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.