Document Editing Problems

Fix a Blank Address Label Mail Merge Preview in Word

Anum MushtaqAnum Mushtaq Nov 20, 2026 869 views

Question details

The user needs to preview and print address labels using a Word mail merge and an Excel recipient list.

Fix a Blank Address Label Mail Merge Preview in Word
Product
Microsoft Word mail merge with Microsoft Excel
Device & OS
not provided
Scenario
The user is creating address labels from an Excel data source in Word.
Observed behavior
The Address Block preview is blank, or merge field placeholders such as «Name» appear in the printed output. Sometimes only the first line prints.
Before you start

Locate the Word mail merge document and its Excel recipient list. Open the Excel file and check that the first row contains column headers and that recipient rows contain the address information you need.

Solution 1Recommended

Reconnect the Excel list and finish the label merge

Use this method when the saved Word document may have lost its connection to the recipient list or is showing unmerged fields.

1
Reopen the merge document

Open the label document in Word. If Word asks whether to keep the connection to the data source, confirm it rather than disconnecting the list.

2
Reconnect the recipient list

If the connection is missing, select Mailings > Select Recipients > Use an Existing List. Choose the Excel file and the worksheet containing the recipients.

3
Check recipients and fields

Select Mailings > Edit Recipient List to verify that recipients are included. Select Mailings > Match Fields and match the address fields to the appropriate Excel column headers.

4
Preview and complete the merge

Select Mailings > Preview Results and use the recipient arrows to check several records. Then select Mailings > Finish & Merge > Edit Individual Documents to generate the completed labels.

5
Print a test page

In the merged document, select File > Print and test on plain paper before printing on label sheets.

Reconnect the Excel list and finish the label merge
Merge fields versus results: Placeholders such as «Name» can appear in the main document when Preview Results is off. Use Finish & Merge to create or print the populated labels.
Free Microsoft Office alternative

Work with label documents and recipient lists in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for working with documents and spreadsheets. Its Microsoft Office format compatibility makes it easier to move existing files into WPS, although it does not repair Word's mail merge connection.

Open and edit Word documents, including label layoutsWork with Excel-compatible recipient spreadsheetsSupports Microsoft Word DOCX and Excel XLSX formatsFamiliar editing tools make the transition easier
microsoft office alternative - wps office

Frequently Asked Questions

Why is the Address Block preview blank?

Word may not be connected to the Excel list, or the address fields may not match the spreadsheet headers. Check Mailings > Select Recipients, then use Mailings > Match Fields to map the columns.

Why do I see «Name» instead of a recipient's name?

The placeholder is a merge field in the main document. Select Mailings > Preview Results to view data, or use Mailings > Finish & Merge to create the completed labels.

How do I make the address block appear on every label?

Add the address block to the first label, then select Mailings > Update Labels. Use Preview Results to check that the labels display recipient data.

Can I print the labels from a PDF?

Yes. First use Mailings > Finish & Merge > Edit Individual Documents and verify that the addresses appear. Save or export that completed document as a PDF, then print a test page.