Fix a Blank Address Label Mail Merge Preview in Word
Question details
The user needs to preview and print address labels using a Word mail merge and an Excel recipient list.

- 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.
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.
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.
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.
If the connection is missing, select Mailings > Select Recipients > Use an Existing List. Choose the Excel file and the worksheet containing the recipients.
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.
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.
In the merged document, select File > Print and test on plain paper before printing on label sheets.

Rebuild the label merge and check the label layout
Restart the merge if the Address Block remains blank or the existing label document does not populate correctly.
Print the completed labels from a PDF
Use a PDF as a printing workaround if the merged document looks correct but direct printing still causes problems.
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.

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.




