Document Editing Problems

How to Fix Missing Names on Word Labels from Excel Data

Maira Mehtab Sep 28, 2026 870 views

Question details

The user needs to resolve an issue where first and last names are excluded from mailing labels generated via a mail merge.

Word mail merge labels with Excel fields and Update Labels

Product: Microsoft Word
Device & OS: not provided
Scenario: Creating mailing labels by merging an Excel data source into a Word label template.
Observed behavior: The generated labels display the city, state, and ZIP code, but the first and last name fields are entirely missing.

Before you start

Ensure that your Excel workbook is closed before initiating the mail merge in Word, and verify that the column headers for first and last names are clearly defined in the first row of your spreadsheet.

Solution 1Recommended

Reconfigure Mail Merge Fields and Update Labels

This solution ensures the name fields are correctly inserted into the master label and populated across all labels on the page.

In a Word label merge, the first label on the page acts as the master template. If a field is omitted from this first label, or if the layout is not synchronized to the others, those fields will be missing in the final merged document.

Start the Label Merge Process

Open Word, navigate to the Mailings tab, click Start Mail Merge, and select Labels. Choose your correct label vendor and product number, then click OK.

Connect the Excel Data Source

Click Select Recipients on the Mailings ribbon, choose Use an Existing List, and browse to open your Excel workbook containing the address data.

Insert the Missing Name Fields

Place your cursor in the very first label on the document. Click Insert Merge Field, and add the First Name and Last Name fields above your existing address fields.

Propagate the Layout to All Labels

Crucially, click the Update Labels button in the Mailings ribbon. This copies your corrected layout (including the newly added name fields) to every other label on the sheet.

Preview and Complete the Merge

Click Preview Results to verify that the names and addresses now appear correctly. Finally, click Finish & Merge to print or generate your final label document.

Verify Your Excel Sheet Structure: Make sure your mailing list data is located on the very first worksheet of your Excel file, as Word defaults to reading the first sheet during a mail merge.

Seamless Mail Merge

Create Mailing Labels Seamlessly with WPS Writer

WPS Writer offers a powerful, highly intuitive Mail Merge wizard that easily connects to spreadsheet data, allowing you to generate perfectly formatted mailing labels without missing fields.

1. Open Mail Merge: Launch WPS Writer, navigate to the References or Mailings tab, and click Mail Merge to activate the feature.
2. Import Data Source: Click Open Data Source and select your spreadsheet containing the recipient names and addresses.
3. Insert Required Fields: Use the Insert Merge Field button to place the First Name, Last Name, and address data exactly where you want them in your label template.
4. Finish the Merge: Click Merge to New Document or Merge to Printer to instantly generate your complete set of mailing labels.

Fully compatible with Microsoft Word (.docx) and Excel (.xlsx) file formats.Step-by-step Mail Merge wizard to prevent missing data fields.Free, lightweight, and fast alternative to heavy office suites.Cross-platform support for Windows, Mac, and Linux environments.

microsoft office alternative - wps office

Frequently Asked Questions

Why is my Mail Merge skipping the first and last name fields?

This typically occurs if the name fields were not inserted into the first (master) label on the page, or if the column headers in the connected Excel file contain unexpected characters or formatting.

What does the Update Labels button do in Word?

The Update Labels button copies the layout, spacing, and inserted merge fields from the top-left master label to all other labels on the current document page.

How do I ensure my Excel file is properly formatted for Mail Merge?

Ensure your data starts in cell A1, use clear column headers (such as First Name, Last Name, Address), remove any blank rows or columns, and keep all relevant data on the first sheet of the workbook.

Can I fix missing fields without restarting the entire merge?

Yes. You can simply turn off Preview Results, click Insert Merge Field in the first label to add the missing name fields, and then click Update Labels to refresh the layout across the entire page.

Document & File Issues