Document Editing Problems

How to Fix Next Record Errors in Word Labels from Excel on Mac

Maira MehtabMaira Mehtab Nov 4, 2026 868 views

Question details

The user is experiencing an issue where mailing labels display 'Next Record' instead of the actual data from an attached Excel list during a mail merge.

How to Fix Next Record Errors When Inserting an Excel List into Word Labels on Mac
Product
Microsoft Word
Device & OS
Mac
Scenario
Creating a sheet of mailing labels using the Mail Merge feature with an Excel spreadsheet as the data source.
Observed behavior
Word displays the <<Next Record>> tag instead of pulling and displaying the actual contact information from the Excel list.
Before you start

Ensure your Excel data source is closed before you begin the mail merge in Word, and verify that the first row contains clear column headers (e.g., Name, Address, City).

Solution 1Recommended

Use the 'Update Labels' Feature in Mailings

The most common reason for this error is forgetting to propagate the merge fields from the first label to the rest of the sheet. Using the Update Labels button resolves this.

When setting up a label mail merge, Microsoft Word requires you to format only the first label on the sheet. If you do not explicitly tell Word to copy that layout to the rest of the page, the subsequent labels will only display the hidden 'Next Record' command without the actual data fields.

1
Populate the First Label

Open your Word document, go to the 'Mailings' tab, choose your Excel list via 'Select Recipients', and insert your desired merge fields (like First Name, Last Name, Address) into the very first label on the page.

2
Update the Remaining Labels

Click the 'Update Labels' button located in the 'Mailings' tab ribbon. This action automatically copies your inserted merge fields and pairs them correctly with the 'Next Record' rule across all other labels on the sheet.

3
Preview Results

Click 'Preview Results' in the Mailings tab to verify that the labels are now accurately populated with the actual names and addresses from your Excel list.

4
Complete the Merge

Once everything looks correct, click 'Finish & Merge' to either print your labels directly or export them to a new document for further editing.

Mail Merge Tip: Always use 'Preview Results' before printing. This saves paper and ensures that longer names and addresses fit perfectly within your chosen label boundaries.
Create Labels Seamlessly

Create Mailing Labels from Excel Easily with WPS Office

Avoid confusing merge errors by using WPS Writer to create and print your mailing labels. WPS Office provides an intuitive Mail Merge wizard that integrates flawlessly with spreadsheet data, making bulk mailings a breeze.

  1. 1. Start Mail Merge: Open WPS Writer, navigate to the 'References' tab, and click on 'Mail Merge'.
  2. 2. Import Excel Data: Click 'Open Data Source' to browse and import your existing Excel (.xlsx) mailing list.
  3. 3. Insert Merge Fields: Place your cursor in the first label and use 'Insert Merge Field' to add your required data columns (e.g., Name, Address).
  4. 4. Merge to New Document: Use 'Merge to Different New Document' or 'View Merged Data' to effortlessly preview and print your populated labels.
Fully compatible with Microsoft Word (.docx) and Excel (.xlsx) formats.Intuitive Mail Merge wizard with simple, straightforward field mapping.Seamless data integration between WPS Writer and WPS Spreadsheet.Free, lightweight, and user-friendly interface for macOS and Windows.
microsoft office alternative - wps office

Frequently Asked Questions

Why does Word only show 'Next Record' and not the person's name?

The 'Next Record' rule tells Word to move to the next row in your Excel list, but it does not display data by itself. It must be combined with actual merge fields (like <<First Name>>). Ensure you have inserted your data fields alongside the Next Record tag.

Why is the 'Update Labels' button grayed out on Mac?

The 'Update Labels' button only becomes active when your document type is explicitly set to 'Labels'. Go to Mailings > Start Mail Merge and ensure 'Labels' is selected, then choose your label vendor and product number.

Can I edit individual labels after completing the merge?

Yes. Instead of sending the merge directly to the printer, click 'Finish & Merge' and select 'Edit Individual Documents'. This generates a new, standalone Word document where you can manually adjust the text on specific labels.

Does my Excel file need to be formatted in a specific way for mail merge?

Yes. Your Excel list should have a single row of clear column headers at the very top (e.g., Name, Street, Zip Code). Make sure there are no blank rows or merged cells above your data, as this confuses Word's field mapping.