Mail merge skills

How to Go From Mailing List to Address Labels

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.

Gå til trin: 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9

Trin 1: Get Free Download

Instruktioner: Download a free copy of Avery Wizard Software for Microsoft® Office.

Trin 2: Create a Spreadsheet

Instruktioner: 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.
create a spreadsheet

Trin 3: Select Names and Addresses

Instruktioner: Highlight the column names and the rows which contain all the names and addresses that you'll want to print onto the labels.
Select names and addresses

Trin 4: Start the Avery Wizard

Instruktioner: 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.
Start Avery Wizard

Trin 5: Enter Your Avery Product

Instruktioner: Enter the Avery product number or description, then click on the Search button. Choose the product from the list, then click Next.
Enter your Avery Product

Trin 6: Choose a Template to Customize

Instruktioner: 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.
Choose a template

Trin 7: Add Field Names

Instruktioner: Delete the placeholder text. Select the field names on the right and click Add Field to Layout.
Adding field names

Trin 8: Print Preview

Instruktioner: 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. 
print preview

Trin 9: Print

Instruktioner: Your mailing list is now formatted in an address label document that will open in Microsoft® Word for you to print.
Print

REVIEW SNAPSHOT®

by PowerReviews
AVERYHow to Go From Mailing List to Address Labels
 
5.0

(based on 2 reviews)

Ratings Distribution

  • 5 Stars

     

    (2)

  • 4 Stars

     

    (0)

  • 3 Stars

     

    (0)

  • 2 Stars

     

    (0)

  • 1 Stars

     

    (0)

Reviewed by 2 customers

Displaying reviews 1-2

Back to top

(1 of 2 customers found this review helpful)

 
5.0

Simple and Easy

By AccidentalPCGuy

from Undisclosed

This review is from AVERY How to Go From Mailing List to Address Labels:

Great for large mailings! Easy to follow step by step directions and the final product is professional. Now if only it would attach itself to the envelope . . .

(1 of 2 customers found this review helpful)

 
5.0

Amazing!!

By Chica2483

from Undisclosed

This review is from AVERY How to Go From Mailing List to Address Labels:

This is great!! The Avery Wizard combined with Microsoft Office makes everything so simple!! You don't have to worry about running multiple programs at the same time, and you can save everything that you do (some programs don't allow that)!!

Displaying reviews 1-2

Back to top