How to mail merge mailing labels

Question

How to mail merge mailing labels

John Purcell 20

How to use the wizard for creating a list of labels from a table of addresses using Avery 5260 labels.

The instructions found online from Microsoft do not let you select Avery labels, nor allow you to select a table that was previously created of complete addresses.

Moved from: Microsoft 365 and Office | To Do | For home

0 comments

Answer accepted by question author

1 additional answer

Your answer

Answer 1

Hello John Purcell, thanks for posting this in our community.

If your addresses are in Word, make sure they are in a proper table format with columns for Name, Address, City, State, and ZIP. If they are in Excel, ensure the first row contains column headers such as First Name, Last Name, Address, City, State, and ZIP, then save the file.

To start the mail merge in Word, open Microsoft Word and go to the Mailings tab. Choose Start Mail Merge and select Labels. In the Label Options dialog, set Label vendors to Avery US Letter and choose product number 5260 Address Labels, then click OK.

Next, connect to your address list by selecting Recipients and choosing Use an Existing List. Browse and select your Excel file or Word table. If using Excel, pick the correct sheet and confirm that “First row of data contains column headers” is checked. If using a Word table, select the document and then the table.

Insert merge fields by clicking Insert Merge Field and adding fields like:

«First_Name» «Last_Name»

«Address»

«City», «State» «ZIP»

Arrange them in the first label cell. After that, click Update Labels to copy the layout to all labels.

Hope this works on your device.

Kind regards,

John Oli

Answer 2

To mail merge mailing labels using Avery 5260 labels from a table of addresses, you can follow these general steps:

Prepare Your Address List: Ensure your addresses are organized in a table format, ideally in an Excel spreadsheet. Each address should have its own row, with separate columns for the name, address line 1, address line 2, city, state, and postal code.
Open Microsoft Word: Start a new document.
Start the Mail Merge: Go to the Mailings tab and select Start Mail Merge. Choose Labels from the dropdown menu.
Select Label Options: In the Label Options dialog box, select the appropriate label brand (Avery) and product number (5260). This will set the document to the correct dimensions for the labels.
Select Recipients: Click on Select Recipients and choose Use an Existing List. Navigate to your Excel file containing the addresses and select it.
Insert Merge Fields: Click on Insert Merge Field to add the fields from your Excel table into the label template. Arrange them as needed to fit the label format.
Preview Your Labels: Click on Preview Results to see how your labels will look with the actual data.
Complete the Merge: Once satisfied with the preview, click on Finish & Merge to print the labels or edit individual labels if necessary.

If you encounter issues with selecting Avery labels or your address table, ensure that your Excel file is properly formatted and that you are using the latest version of Microsoft Word. If problems persist, consider checking Microsoft's support documentation for troubleshooting tips.

References:

Create Address Labels from a Spreadsheet

Share via

How to mail merge mailing labels

1 additional answer

Your answer