Turn Your Mailing List into Mailing Labels Online
Step 1: Start a New Project
Go to Avery Design & Print Online and enter the product number of your labels (such as “5160”) and press Enter
Step 2: Confirm the Product Template
Click the template that matches your product.
Step 3: Choose the Design Theme
Select from a variety of design themes from the column on the left, and view the design(s) from each theme on the right. Want to start from scratch? Choose the “Blank and Text Only” theme.
Step 4: Start the Mail Merge
Now it’s time to bring your mailing list (or other list) and combine it with your label design.
Click the text box where you would like the mailing address to appear on your label. Then, select “Import Data (Mail Merge)” from the column on the left, and click the “Start Mail Merge” button.
Step 5: Select a File
Click the green “Browse for File” button to locate the file from your computer that contains your mailing list. Once it’s located, you should be able to view your file content on the screen. The file name will appear above the view area. 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.
If you used the first row of your file for column headings and do not wish to print it out, just click to remove the check mark from “Print this row of data."
Click “Next” to continue.
Step 6: Arrange Fields
Now it’s time to set up the appearance of your information as it will look on the labels. To do this, just click the field name in the “Available fields” list on the left, hold the mouse button down, and drag the field over to the “Arrange fields” box on the right. You can insert commas, spaces, and other text, and these will remain where you insert them during the merge.
When you are satisfied with the appearance of your labels, click “Complete Merge.” You will see a sample of the first label with your information merged in with your design template. The Sheet Navigator on the right will also show you how the entire label sheet will appear.
Step 7: Preview & Print
Click “Preview & Print” to review your design. To make adjustments, just click the “Back” button in the upper-right-hand corner. When your design is ready to go, just click the green “Print” button.
TIP: Follow the directions from the insert in the package for basic printing tips.
Step 8: Save
To save your design, click the “Save” button. In the pop-up window, create a file name and save to either your “MyAvery Online Account” or your computer.