Fix Mail Merge Labels Showing Only One Record in Word for Mac
Question details
The user is attempting to create mailing labels using an Excel address list but is only able to generate a single record on the first label instead of populating the entire sheet.

- Product
- Microsoft Word for Mac
- Device & OS
- macOS
- Scenario
- Performing a mail merge to generate a sheet of Avery mailing labels from an imported Excel data source.
- Observed behavior
- Word creates only one mailing label in the first slot and leaves the remaining labels on the sheet completely blank.
Ensure your Excel address list is fully updated, correctly formatted with column headers, and closed before you begin the mail merge process in Word.
Use the Update Labels Command
By expanding the Word window and using the 'Update Labels' command, you can automatically copy the merge fields from your first label to all other labels on the page.
When creating labels in a mail merge, Microsoft Word requires you to format only the first label. The remaining labels will stay blank until you explicitly tell Word to duplicate the fields across the entire sheet.
On Mac screens, the Word window is sometimes too narrow by default, causing the ribbon to collapse and hide the crucial 'Update Labels' button.
Click inside the first label on your document and use the 'Insert Merge Field' button on the Mailings tab to add elements like First Name, Last Name, and Address.
Click and drag the edge of your Word for Mac window to make it wider, or click the green maximize button. This ensures all tools on the Mailings ribbon are fully visible.
Locate and click the 'Update Labels' button on the Mailings tab. You will immediately see <<Next Record>> and your merge fields populate into all the remaining blank labels.
Click 'Preview Results' to verify that all your Excel contacts are correctly displayed, then click 'Finish & Merge' to print or save the final document.

Create Mailing Labels Easily with WPS Writer
WPS Office offers a clean, user-friendly interface that makes performing a mail merge and creating mailing labels incredibly simple. The ribbon is intelligently designed so you never have to hunt for hidden buttons to update your labels.
- 1. Open a Label Document: Launch WPS Writer, navigate to the Mailings tab, and select your preferred label layout.
- 2. Import Excel Contacts: Click 'Open Data Source' and browse your computer to attach your Excel address list.
- 3. Insert Fields and Update: Add your merge fields to the first label, then click 'Update Labels' to automatically fill the entire page.
- 4. Merge to Printer: Click 'Merge to Printer' or 'Merge to New Document' to generate your completed mailing labels.

Frequently Asked Questions
Why is the Update Labels button grayed out in Word for Mac?
The 'Update Labels' button remains grayed out until you have set your document type to 'Labels' and inserted at least one merge field into the very first label slot on the document.
Can I use an Apple Numbers spreadsheet for a Mac mail merge?
Word for Mac works natively with Excel (.xlsx) or CSV files. If your address list was created in Apple Numbers, you need to export it to an Excel or CSV format before using it as your data source.
How do I check my labels before printing them?
Click the 'Preview Results' button on the Mailings tab. This will replace the merge field placeholders with the actual data from your Excel list, allowing you to catch any formatting issues before you waste label paper.
What should I do if my Excel addresses don't align with the Avery labels?
First, ensure you have selected the exact Avery product number in the 'Label Options' dialog. If the text is still misaligned, check your document's paragraph settings to remove any unwanted 'space after paragraph' that might be pushing the text down.




