Search:
 


You are here: Home > Projects & Ideas > Ideas for Home > Holidays > Step By Steps > Turn Your Mailing List into Mailing Labels Online

Turn Your Mailing List into Mailing Labels Online

Look at how far you’ve come already: You’ve got your stack of holiday greetings ready to go, and now all that you’ve got to do is address them and send them out. But if the thought of writing all those names and addresses on the envelopes is cramping your style (and hand), don’t worry—with an easy mail merge, you can convert that long list of mailing addresses into mailing labels in just minutes, and all online! Here’s how:

Jump to Step: 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8

Step 1: Start a New Project

Instructions: Go to Avery Design & Print Online and enter the product number of your labels (such as “5160”) and click “GO.”

If you don’t know the product number, start by selecting the product category (such as “Labels”).

Step 2: Confirm the Product Template

Instructions: Click the template that matches your product.

Step 3: Choose the Design Theme

Instructions: 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

Instructions: 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

Instructions: 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

Instructions: 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

Instructions: 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

Instructions: 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.

Get Free Templates, Software, Tips and More!


 
 
-->