Document Editing Problems

Fix Word Mail Merge Skipping Records After Filtering Excel Data

Rana Garcia Oct 10, 2026 870 views

Question details

The user is experiencing a data synchronization issue where Microsoft Word's mail merge function omits specific records after filters are applied to the linked Excel spreadsheet.

How to Fix Word Mail Merge Skipping Records After Filtering Excel Data

Product: Microsoft Word and Excel
Device & OS: not provided
Scenario: Running a mail merge in Word using an Excel workbook as the data source, where specific data filters have been applied to customize the recipient list.
Observed behavior: Word skips certain records during the merge process, and applied filters in the Excel data source fail to clear or update properly, resulting in an incomplete output.

Before you start

Ensure that your Excel workbook is completely saved and closed before initiating the mail merge in Word, as having the data source open can prevent the latest filter changes from synchronizing properly.

Solution 1Recommended

Clear Excel Filters and Reconnect the Data Source

Resetting the connection between Word and Excel often resolves lingering cache issues that cause records to be skipped.

Microsoft Word sometimes holds onto an older cached version of your Excel data. By completely clearing the filters in Excel and forcing Word to reconnect, you can ensure the correct records are read during the merge.

Clear Filters in Excel

Open your Excel data source. Go to the 'Data' tab on the ribbon and click 'Clear' in the Sort & Filter group to remove any hidden filters. Save and close the Excel file.

Remove the Data Source in Word

Open your Word mail merge document. Go to the 'Mailings' tab, click 'Select Recipients', and choose 'Type a New List' temporarily to break the existing connection.

Reconnect to the Excel File

Click 'Select Recipients' again, choose 'Use an Existing List', and navigate to your saved Excel file to re-establish a fresh connection.

Clear Excel Filters and Reconnect the Data Source

Pro Tip: If the issue temporarily resolves itself but returns later, consider creating a completely new Excel file by copying your data, as the original file may contain corrupted formatting.

Solution 2

Filter the Recipient List Directly in Word

Avoid Excel filtering glitches by leaving the Excel data raw and managing your recipient list filters directly within Microsoft Word.

Solution 3

Copy Filtered Data to a New Spreadsheet

A foolproof workaround that isolates only the records you want to merge by pasting them into a fresh, uncorrupted Excel file.

Use WPS Office for Flawless Mail Merges

If Microsoft Word continues to skip records due to synchronization bugs, you can easily complete your mail merge using WPS Office. WPS Writer features a highly stable Mail Merge tool that seamlessly imports, filters, and processes your spreadsheet data without omitting records.

1. Open Your Document in WPS Writer: Launch WPS Office, open your main document, and navigate to the 'References' tab on the top ribbon.
2. Start the Mail Merge: Click on 'Mail Merge' to activate the tools, then click 'Open Data Source' to browse and select your Excel spreadsheet.
3. Verify and Filter Recipients: Click 'Mail Merge Recipients' to view your data list. You can safely check, uncheck, or filter records directly in this window.
4. Execute the Merge: Ensure your Merge Fields are placed correctly, then click 'Merge to New Document' to generate your final output flawlessly.

100% format compatibility with Microsoft Word (.docx) and Excel (.xlsx) filesStable Mail Merge engine that accurately reads filtered data without skipping rowsFree, lightweight, and fast alternative to heavy office suitesIntuitive, familiar interface so you can pick up exactly where you left off

microsoft office alternative - wps office

Frequently Asked Questions

Why does Word mail merge keep skipping the first record of my Excel list?

This commonly happens if Word mistakenly reads the first row of your data as column headers. When connecting your data source, ensure the 'First row of data contains column headers' checkbox is properly checked or unchecked depending on how your Excel sheet is formatted.

How do I completely remove a stuck filter in Excel before merging?

Open your Excel data source, go to the 'Data' tab, and click the 'Clear' button located in the Sort & Filter group. This forces Excel to display all hidden rows. Be sure to save and fully close the workbook before attempting the merge in Word again.

Can I filter my mail merge recipients without altering the original Excel file?

Yes. Instead of filtering the data in Excel, you can connect the full list to Word. Then, under the 'Mailings' tab, click 'Edit Recipient List'. Here, you can uncheck specific rows or use the drop-down arrows on the column headers to filter records directly within Word.

Document & File Issues