How to Fix Word Mail Merge Skipping Records and Printing Zero Values
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.

- 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 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.
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.
Launch Excel and open the spreadsheet you are using for the mail merge.
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'.
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.
Save this cleaned version of the workbook and use it as the new data source for your Word mail merge.

Configure Mail Merge Rules in Word
Use the 'Skip Record If' and 'Next Record' rules in Word to explicitly handle blank or zero-value records for labels.
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. Open Mail Merge in WPS Writer: Launch WPS Writer, navigate to the 'References' tab, and click on 'Mail Merge' to begin the setup.
- 2. Link Data Source: Click 'Open Data Source' and select your WPS Spreadsheet or Excel file containing the mailing list.
- 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. Generate the Document: Click 'Merge to New Document' to automatically generate all your labels or letters without skipping records.

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.




