Printing Problems

How to Print All Excel Address Labels Using Word Mail Merge

Partner Editor Oct 9, 2026 869 views

Question details

The user needs to print a complete set of address labels from an Excel list using Word's mail merge, but is experiencing issues where only a partial list or blank labels are printing.

How to Print All Excel Address Labels in Word Mail Merge

Product: Microsoft Word / Excel
Device & OS: not provided
Scenario: Creating and printing address labels by merging an Excel recipient list into a Microsoft Word document.
Observed behavior: Word prints only some labels (e.g., just 7 records), leaves subsequent previews blank, or fails to pull records beyond the first worksheet.

Before you start

Ensure your Excel spreadsheet has clearly labeled column headers (like Name, Address, City) in the very first row and contains no empty rows within the data set.

Solution 1Recommended

Update Labels and Verify the Recipient List

Fix missing records by properly pushing the label layout to all cells and verifying the data source is fully selected.

A common reason for partial label printing is forgetting to update the labels after setting up the first one. This step is mandatory because it inserts the 'Next Record' rule that tells the word processor to move to the next person on your Excel list.

Select the correct recipient list

Go to the Mailings tab, click 'Select Recipients', choose 'Use an Existing List', and open your Excel file.

Verify recipient selection

Click 'Edit Recipient List' in the Mailings tab to ensure all intended records are visible and have a checkmark next to them.

Insert merge fields

Click inside the very first label on your document and use 'Insert Merge Field' to add your address blocks (e.g., First Name, Last Name, Address).

Update all labels

Click the 'Update Labels' button on the Mailings tab. This copies your layout and the crucial 'Next Record' command to every other label on the sheet.

Finish and merge

Instead of printing the preview, click 'Finish & Merge' and select 'Edit Individual Documents' to generate a new document containing all labels. Verify the output, then print this new document.

Update Labels and Verify the Recipient List

Check the First Worksheet: Mail merge typically pulls data from the first active worksheet. Move your complete mailing list to 'Sheet 1' in Excel to avoid selection issues.

Solution 2

Check for Missing 'Next Record' Fields

If only the first label repeats or only a few labels print, verify that the 'Next Record' field code is present.

Efficient Mail Merge with WPS Office

Create and Print Address Labels Seamlessly in WPS Writer

Use WPS Writer's intuitive Mail Merge tools to connect your spreadsheets and generate perfectly formatted address labels in seconds, avoiding the hassle of missing records or complex field codes.

1. Open WPS Writer: Launch WPS Writer, navigate to the 'Mailings' tab, and click 'Mail Merge' to activate the toolset.
2. Connect Data Source: Click 'Open Data Source' and select your Excel spreadsheet containing the mailing list.
3. Insert Fields: Place your cursor in the first label cell and click 'Insert Merge Field' to add names and addresses.
4. Merge to Printer: Click 'Merge to Printer' or 'Merge to New Document' to successfully output and print all your address labels.

100% compatible with Microsoft Word and Excel formats (.docx, .xlsx).User-friendly interface for setting up mail merges quickly and accurately.Easily manage and select data sources with clear visual previews.Lightweight, free alternative to Microsoft Office for your daily tasks.

microsoft office alternative - wps office

Frequently Asked Questions

Why is my mail merge only printing the first page of labels?

This usually happens if you try to print directly from the 'Preview Results' view instead of completing the merge. You must use the 'Finish & Merge' button and select 'Print Documents' to send all records to the printer.

What should I do if my mail merge preview shows blank labels?

Blank labels can occur if there are empty rows in your Excel data source or if the 'Next Record' field was not copied to all cells. Clean your Excel list to remove blank rows, save it, and ensure you click 'Update Labels' in your document before merging.

Does Word mail merge work with multiple Excel worksheets at once?

No, a mail merge connects to one worksheet at a time. If your data is spread across multiple sheets, you must consolidate them into a single worksheet or perform separate mail merges for each individual sheet.

Document & File Issues