Document Editing Problems

How to Fix Word Mail Merge Skipping Records and Printing Zero Values

Huma Ashraf ChHuma Ashraf Ch Nov 2, 2026 869 views

Question details

The user is attempting to perform a label mail merge in Word using an Excel spreadsheet but encounters issues where the merge skips valid records, prints zero values for blank cells, or only produces a single page.

How to Fix Word Mail Merge Skipping Records and Printing Zero Values
Product
Microsoft Word and Excel
Device & OS
not provided
Scenario
Performing a label mail merge in Word using an Excel workbook that contains extra formula rows as the data source.
Observed behavior
The mail merge skips blank source records, prints '0' instead of leaving spaces blank, and sometimes only generates one page despite having more than ten valid rows.
Before you start

Before starting the mail merge process, ensure your Excel data source does not contain hidden rows or empty formula cells that might confuse the merge logic.

Solution 1Recommended

Clean Up the Excel Data Source

Ensure your Excel spreadsheet contains clearly defined ranges and remove or modify formulas that return zero or empty strings in unused rows.

Formulas like SEQUENCE or ISBLANK in Excel can create 'phantom' rows that Word misinterprets during a mail merge. Cleaning the data source ensures Word only pulls valid records.

1
Open the Excel data source

Launch Excel and open the spreadsheet you are using for the mail merge.

2
Remove unused formula rows

Highlight any rows below your actual data that contain background formulas (like ISBLANK or SEQUENCE) returning empty strings or zeros, right-click, and select 'Delete'.

3
Define a specific print range

Select only the cells containing your actual valid records, go to 'Formulas' > 'Define Name', and give the range a specific name to use as your merge target.

4
Save as a simplified workbook

Save this cleaned version of the workbook and use it as the new data source for your Word mail merge.

Clean Up the Excel Data Source
Tip: If you cannot delete formulas, wrap them in an IF statement so they return a truly empty value rather than a zero when the reference cell is blank.
Seamless Mail Merge

Perform Flawless Mail Merges with WPS Office

WPS Office offers a built-in, highly intuitive Mail Merge feature in WPS Writer that seamlessly integrates with WPS Spreadsheet. It automatically handles blank rows smartly, preventing the common formatting and skipping errors found in other software.

  1. 1. Open Mail Merge in WPS Writer: Launch WPS Writer, navigate to the 'References' tab, and click on 'Mail Merge' to begin the setup.
  2. 2. Link Data Source: Click 'Open Data Source' and select your WPS Spreadsheet or Excel file containing the mailing list.
  3. 3. Insert Merge Fields: Place your cursor in the document or label template and click 'Insert Merge Field' to add your specific data columns.
  4. 4. Generate the Document: Click 'Merge to New Document' to automatically generate all your labels or letters without skipping records.
Fully compatible with Microsoft Word and Excel formats (.docx, .xlsx)Intuitive Mail Merge wizard specifically optimized for labels and lettersSmarter handling of empty cells and formula outputs from spreadsheetsFree and lightweight alternative for your document productivity needs
microsoft office alternative - wps office

Frequently Asked Questions

Why does my mail merge show '0' instead of a blank space?

This happens when your Excel data source contains blank cells or formulas returning empty values, which Word interprets as a numeric zero during the merge. You can fix this by cleaning the Excel data, adding a numeric format switch in Word, or using the 'Skip Record If' rule.

Why is my label mail merge only printing the first page?

If a label mail merge only prints one page despite having a large data source, it usually means the '<<Next Record>>' rule is missing from your labels. Without this field, Word does not know it needs to advance to the next row in your spreadsheet for subsequent labels.

Can I filter out empty rows directly in Word without modifying Excel?

Yes. In Word, go to the 'Mailings' tab, click 'Edit Recipient List', and either manually uncheck the blank rows or use the 'Filter' option to exclude any records where a specific necessary field is empty.