How to Fix Next Record Errors in Word Labels from Excel on Mac
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.

- 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.
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).
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.
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.
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.
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.
Once everything looks correct, click 'Finish & Merge' to either print your labels directly or export them to a new document for further editing.
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. Start Mail Merge: Open WPS Writer, navigate to the 'References' tab, and click on 'Mail Merge'.
- 2. Import Excel Data: Click 'Open Data Source' to browse and import your existing Excel (.xlsx) mailing list.
- 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. Merge to New Document: Use 'Merge to Different New Document' or 'View Merged Data' to effortlessly preview and print your populated labels.

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.




