Turn Your Address List into Labels
A quick and easy way to create personalized address labels is with Avery Design & Print Online. Here’s how to use the mail merge feature to turn your spreadsheet of names and addresses into custom labels in minutes. It’s a must-have for mass mailings you’re sending to multiple recipients! If you don't have a spreadsheet of your contact names and addresses yet, you can get started with our pre-formatted files for Microsoft Excel or other database programs.
Step 1: Go to Avery Design & Print Online
Open the free Avery Design & Print Online software at avery.com/print. To start a new project, enter your Avery product number and click GO.
Step 2: Choose your design
Use the menu on the left to view design categories. When you find a design you’d like to use, click Select this Design.
Step 3: Select text box and import data
First, highlight the text box. You can also change the text font and size here if you wish. Next, select Import Data from the menu on the left.
Step 4: Locate your spreadsheet
Browse to find your spreadsheet file on your computer.
Step 5: Choose fields
Check the boxes for fields you want to include in your mail merge.
Step 6: Arrange fields
Select from the available fields on the left and place them as you’d like them to appear in the area on the right. If you accidentally drop a field in the wrong place, simply delete then drag and drop again.
Step 7: Start the mail merge
Review the instructions for making changes to the format of your content. Then click Finish.
Step 8: Make final formatting touches
Review your project. Make additional changes if necessary, then click Preview & Print.
Step 9: Choose your print option
Select Print It Yourself to print using your own printer. Choose Let Us Print for You to have Avery WePrint, our professional printing service, print your project for you and deliver it to your door in about three business days.
After selecting your print option, you will be able to save your design.