Template Issues

Fix Mail Merge Labels Showing Only One Record in Word for Mac

Natalie TaylorNatalie Taylor Nov 2, 2026 871 views

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.

Fix Mail Merge Labels Showing Only One Record in Word for Mac
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.
Before you start

Ensure your Excel address list is fully updated, correctly formatted with column headers, and closed before you begin the mail merge process in Word.

Solution 1Recommended

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.

1
Insert Merge Fields

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.

2
Expand the Word Window

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.

3
Click Update Labels

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.

4
Preview and Finish

Click 'Preview Results' to verify that all your Excel contacts are correctly displayed, then click 'Finish & Merge' to print or save the final document.

Use the Update Labels Command
Hidden Ribbon Buttons: If you are following a tutorial that takes up half your screen, Word will compress its ribbon layout. Always maximize Word when doing a mail merge to easily find all necessary commands.
Seamless Mail Merge

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. 1. Open a Label Document: Launch WPS Writer, navigate to the Mailings tab, and select your preferred label layout.
  2. 2. Import Excel Contacts: Click 'Open Data Source' and browse your computer to attach your Excel address list.
  3. 3. Insert Fields and Update: Add your merge fields to the first label, then click 'Update Labels' to automatically fill the entire page.
  4. 4. Merge to Printer: Click 'Merge to Printer' or 'Merge to New Document' to generate your completed mailing labels.
Fully compatible with Microsoft Word (.docx) formats and Excel (.xlsx) address lists.Clean and intuitive Mailings ribbon that keeps critical buttons clearly visible.Completely free to download and use for all your essential document tasks.Lightweight architecture ensuring fast performance on all operating systems.
microsoft office alternative - wps office

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.