How to Go From Mailing List to Address Labels
Avery Wizard Software is no longer supported. To learn how to go from mailing list to address labels, click here to go to the updated article.
Never done a mail merge before? Today's your lucky day. We'll show you how to go from mailing list to address labels in just minutes with these simple step-by-step instructions.
- Avery Wizard System Requirements:
- Microsoft® Windows® 8, 7, Vista® or XP
- Microsoft® Office 2013, 2010, 2007, 2003 or XP (not compatible with Microsoft® Office Starter 2010)
- Internet Explorer® 6.0 or later
- 165MB available disk space
- If your system doesn't meet the requirements above, you can also find templates in Avery Design & Print Online.
Step 1: Get Free Download
Download a free copy of Avery Wizard Software for Microsoft® Office.
Step 2: Create a Spreadsheet
You may have mailing lists in different programs or in an old address book. In any case, you’ll want to gather and enter all those contacts into a single database or spreadsheet program, such as Microsoft® Excel. It’s a one-time effort that will help you in the long run. If you don't have a spreadsheet with all of your names and addresses, you can start with our pre-formatted files for Microsoft® Excel or other database programs.
Step 3: Select Names and Addresses
Highlight the column names and the rows which contain all the names and addresses that you'll want to print onto the labels.
Step 4: Start the Avery Wizard
Click on the Avery icon button on your toolbar to start the Avery Wizard software while still working within your Microsoft® Office program. Click Next to start a new project.
Step 5: Enter Your Avery Product
Enter the Avery product number or description, then click on the Search button. Choose the product from the list, then click Next.
Step 6: Choose a Template to Customize
You'll find a variety of options to choose from, from blank templates to predesigned templates. Click on the template you want to use, then click Next.
Step 7: Add Field Names
Delete the placeholder text. Select the field names on the right and click Add Field to Layout.
Step 8: Print Preview
Choose whether you want your addresses to fill the label sheet down the column or to fill across the row. You can click on Print Preview to see how your project will print.
Step 9: Print
Your mailing list is now formatted in an address label document that will open in Microsoft® Word for you to print.