Document Editing Problems

Fix Word Mail Merge Error When Excel Records Are Empty

Bushra Parveen Sep 27, 2026 868 views

Question details

Users encounter an error during a Word mail merge where the system reports that Excel records are empty or no records match the query, despite the data being visible in the preview.

How to Fix Word Mail Merge Error When Excel Records Are Empty

Product: Microsoft Word, Microsoft Excel
Device & OS: not provided
Scenario: Performing a mail merge in Word using an Excel spreadsheet as the data source to generate documents or labels.
Observed behavior: Word reports that the mail merge records are empty or no records match the query, preventing the final merged document from generating.

Before you start

Before proceeding, ensure your Excel workbook is fully saved and closed, as keeping the data source open in Excel can cause file-locking issues that prevent Word from reading the records properly.

Solution 1Recommended

Verify and Clean Excel Header Rows and Data Ranges

Invalid headers, blank rows, or improperly formatted data ranges in Excel are the most common causes of missing or empty records during a mail merge.

Microsoft Word requires a highly structured table to execute a mail merge successfully. Any breaks in the data or complex formatting can confuse the merge wizard.

Format the header row

Open your Excel data source and ensure the very first row contains clear, unique column headers with no blank cells or merged columns.

Remove empty rows and columns

Scroll through your dataset and delete any entirely blank rows or columns that sit within your active data range.

Clear hidden filters

Navigate to the 'Data' tab on the Excel ribbon and clear any active filters to ensure all records are fully visible before saving.

Verify and Clean Excel Header Rows and Data Ranges

Avoid complex formatting: Keep the Excel data sheet as simple as possible. Avoid using multi-line headers, sub-totals, or merged cells in the data source.

Solution 2

Clear or Update Mail Merge Query Rules in Word

If records show in the preview but the merge process reports them as empty, existing query rules or filters in Word might be actively excluding your data.

Solution 3

Test the Mail Merge with a New Excel File

Sometimes the original Excel file becomes corrupted or retains hidden background formatting that breaks the mail merge connection.

Efficient Mail Merge Alternative

Easily Perform Mail Merges with WPS Office

Avoid complex data-reading errors and empty records by using WPS Office. WPS Writer offers a highly intuitive Mail Merge wizard that integrates flawlessly with spreadsheet data, completely free of charge.

1. Open WPS Writer: Launch WPS Writer and open your main document or letter template.
2. Access the Mail Merge tool: Navigate to the 'References' tab (or 'Mailings' depending on your interface layout) and click on the 'Mail Merge' button.
3. Import Excel data: Click 'Open Data Source', browse your computer for your .xlsx file, and select the specific worksheet containing your recipient records.
4. Insert fields and merge: Use 'Insert Merge Field' to place your data variables into the text, then click 'Merge to New Document' to generate your final error-free files.

Flawlessly compatible with Microsoft Word (.docx) and Excel (.xlsx) file formats.Intuitive step-by-step Mail Merge wizard to prevent missing or skipped records.Lightweight application that smoothly handles large spreadsheet datasets.Free and user-friendly alternative to Microsoft Office for daily document tasks.

Frequently Asked Questions

Why are my Excel numbers showing up as zeroes or blanks in Word?

This often happens due to mixed data types within a single Excel column. Ensure the entire column is formatted uniformly (for example, as 'Text' or 'Number') before starting the mail merge.

Does the Excel file need to be closed during a Word mail merge?

Yes, it is highly recommended to save and close your Excel workbook before linking it to Word. Leaving it open can cause file-locking conflicts that prevent Word from reading the records.

How do I fix the 'No records match the query' error?

Open the 'Edit Recipient List' option under the Mailings tab in Word, click on the 'Filter' link, and clear all active filters or rules that may be hiding your data from the merge.

Can hidden columns in Excel cause mail merge issues?

Yes, hidden columns, filtered rows, or merged cells in your Excel data source can disrupt the data range Word attempts to read, which frequently results in missing fields or blank records.

Document & File Issues