Printing Problems

Print an Excel Address List on Avery 5660 Labels

Nimra MalikNimra Malik Nov 14, 2026 868 views

Question details

Print addresses from an Excel list onto Avery 5660 mailing labels.

Print an Excel Address List on Avery 5660 Mailing Labels
Product
Microsoft Excel and Microsoft Word
Device & OS
not provided
Scenario
Use an Excel address list as the recipient source for a label mail merge.
Observed behavior
Each recipient's address should appear on a separate Avery 5660 label.
Before you start

Check that your Excel list has one header row and one recipient per row, with fields such as name, street, city, state, and ZIP code. Store ZIP codes as text so leading zeros are retained, then save and close the workbook.

Solution 1Recommended

Use Word mail merge to print Avery 5660 labels

Connect the Excel address list to a Word label document and print one label per recipient.

1
Choose the label template

Open a blank document in Word. Go to Mailings > Start Mail Merge > Labels, choose Avery US Letter as the label vendor, and select product number 5660.

2
Connect the Excel list

Select Mailings > Select Recipients > Use an Existing List. Open the saved Excel workbook and choose the worksheet containing your address list.

3
Add address fields

Click the first label and select Mailings > Address Block, or use Insert Merge Field to add individual fields. Use Match Fields if Word does not recognize a column.

4
Fill and preview the labels

Select Mailings > Update Labels to copy the layout to the remaining labels. Then choose Preview Results and use the navigation arrows to check recipient addresses.

5
Test and print

Choose Mailings > Finish & Merge > Print Documents. Print a test on plain paper at actual size, compare it with a label sheet, and then load the Avery 5660 sheets and print with the appropriate paper settings.

Use Word mail merge to print Avery 5660 labels
If 5660 is not listed: In Label Options, use New Label to enter the dimensions and spacing from the Avery package, or obtain a compatible template from Avery.
Create mailing labels with WPS Office

Merge an address list into mailing labels with WPS Office

Use WPS Spreadsheets to prepare the address list and WPS Writer to merge it into a matching label layout. Mail merge commands and label templates can vary by version.

  1. 1. Prepare the list: Open the address workbook in WPS Spreadsheets. Check the column headers and ZIP codes, then save the file.
  2. 2. Set up the label sheet: In WPS Writer, open a compatible Avery 5660 label template or create a table matching the dimensions and spacing on the label package.
  3. 3. Connect the data: Open the Mailings or Mail Merge commands in Writer and select the saved spreadsheet as the recipient data source.
  4. 4. Insert and preview addresses: Insert the name and address merge fields in the label layout. Use the label merge or next-record options available in your version so each label advances to a different recipient, then preview the results.
  5. 5. Print the labels: Use the mail merge print command or File > Print to print a plain-paper test at actual size, then print on the label sheets after checking alignment.
Prepare address columns and merge recipient details into labels.Open and edit Microsoft Excel XLSX and Word DOCX files.Use a familiar, easy-to-navigate office interface.Work with a free, lightweight office suite.
QA img-9

Frequently Asked Questions

Why does every label show the same address?

In Word, select Mailings > Update Labels after arranging the first label. This copies the layout and adds the Next Record rules needed to advance through the list.

How do I keep leading zeros in ZIP codes?

Store ZIP codes as text in the Excel source before connecting it to Word. If zeros have already been lost, restore them in a text column, save the workbook, and reconnect or refresh the recipient list.

What if Avery 5660 is not in Word's label list?

Go to Mailings > Start Mail Merge > Labels and check the Avery US Letter vendor. If 5660 is unavailable, choose New Label and enter the dimensions and spacing shown on the package, or use a compatible Avery template.

How can I check label alignment before using a label sheet?

Print a test on plain paper using actual size or 100% scaling. Hold it against an Avery 5660 sheet to check alignment before printing the final labels.