Document Editing Problems

How to Fix Missing Spouse Names in Word Mail Merge Labels

Maira Mehtab Sep 22, 2026 870 views

Question details

A user is experiencing an issue where a specific record in a Word mail merge omits the spouse's name on a mailing label, despite the source XLSB data being correct.

Product: Microsoft Word
Device & OS: not provided
Scenario: Generating mailing labels using a mail merge connected to an Excel spreadsheet data source.
Observed behavior: One or more labels skip fields or omit the spouse's name unexpectedly, often occurring near the final records of the merge data.

Before you start

Before troubleshooting your labels, press Alt+F9 on your keyboard to reveal all hidden merge field codes, which makes identifying unexpected commands much easier.

Solution 1Recommended

Inspect and Adjust the NEXT Record Field

Removing or repositioning the NEXT field can prevent the word processor from skipping data or advancing records prematurely.

When creating multiple labels on a single page, the system uses a NEXT rule to move to the following contact. If placed incorrectly or duplicated near an ADDRESSBLOCK, it might skip names or advance past the final record unexpectedly.

Reveal field codes

Press Alt+F9 (or Fn+Alt+F9 on some laptops) to toggle field codes and reveal the hidden merge fields on your document.

Locate the NEXT command

Look for the { NEXT } or <<Next Record>> tags within the affected label block.

Test without NEXT

Temporarily delete the NEXT field on the problematic label to test if the spouse's name successfully appears.

Update labels

Click 'Update Labels' in the Mailings ribbon and preview the results to ensure the data maps correctly without skipping.

Data Privacy Tip: If you need to share your document on forums for external support, always replace real names and addresses with dummy data or use a sanitized sample to protect confidential information.

Solution 2

Verify Address Block Field Mapping

Ensure the Address Block is properly matching the spouse name fields from your Excel spreadsheet.

Efficient Document Creation

Create Accurate Mail Merge Labels with WPS Writer

WPS Writer provides an intuitive and highly compatible Mail Merge feature, making it simple to link spreadsheets and design labels without dealing with complex field codes skipping your data.

1. Launch Mail Merge: Open WPS Writer, navigate to the 'References' tab, and click on 'Mail Merge'.
2. Import data source: Click 'Open Data Source' and select your spreadsheet containing the names and addresses.
3. Insert precise fields: Use 'Insert Merge Field' to place names exactly where you want them, avoiding the unpredictability of bulk Address Blocks.
4. Merge and print: Click 'Merge to New Document' to preview your completed labels perfectly before printing.

Visual Mail Merge wizard for easy and accurate label creationSeamless compatibility with Microsoft Word documents and Excel (.xlsb, .xlsx) filesClear field mapping to avoid missing names or skipped recordsFree and lightweight alternative for daily office tasks

microsoft office alternative - wps office

Frequently Asked Questions

Why does Alt+F9 not reveal my merge fields?

If Alt+F9 doesn't work, your keyboard might require pressing the 'Fn' key simultaneously (Fn+Alt+F9). Alternatively, you can right-click the specific merge field and select 'Toggle Field Codes'.

What is the exact purpose of the NEXT field in mail merge labels?

The NEXT field instructs the word processor to pull the next row of data from your spreadsheet for the subsequent label on the same page. Without it, the exact same address would print on every label on that page.

Can I use an XLSB file as a data source for mail merge?

Yes, standard word processors including Word and WPS Writer fully support binary Excel workbooks (.xlsb) as a valid and efficient data source for mail merge operations.

Document & File Issues