How to Mail Merge using Avery Design & Print Online
How to Mail Merge using Avery Design & Print Online








After you select a template and a pre-design, the Customize screen appears. Select a text box then click Start Mail Merge under the Import Data (Mail Merge) tools.



Click the Browse for File button to select an address list or other data from Microsoft® Excel or another data program on your computer. Click Upload.

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.



After uploading the data, the address list will be displayed for your review. You can choose which rows of data in the list to use, whether to sort by column, or edit the data. Uncheck the Print this row of data box if you do not want to print the first row of your data. Click the Next button when you are finished reviewing the data.



Drag and drop the data from the Available fields area into the Arrange fields area. Click Complete Merge to continue.



Make any formatting changes if desired. Click Preview & Print to continue.



At any point, click the Help button in the program for more instructions.



REVIEW SNAPSHOT®

by PowerReviews
 
4.3

(based on 3 reviews)

Ratings Distribution

  • 5 Stars

     

    (2)

  • 4 Stars

     

    (0)

  • 3 Stars

     

    (1)

  • 2 Stars

     

    (0)

  • 1 Stars

     

    (0)

Reviewed by 3 customers

Sort by

Displaying reviews 1-3

Back to top

 
3.0

My address label with Chinese Characters cannot printed.

By Victor

from Austin, Texas

Pros

    Cons

    • Flimsy Construction

    Best Uses

      I try to use your product to create an address label which will include Chinese Characters due to its use for relatives and friends living i Taiwan. My Excel text is okay but was not be able to print on the Avery.

      (1 of 1 customers found this review helpful)

       
      5.0

      You took all the guesswork out! Thanks!

      By Mary

      from California

      Pros

      • Easy To Set Up
      • Easy to Use

      Cons

        Best Uses

        • Holiday

        Your template and instructions for mail merging my holiday card labels makes me want to jump in and get it done now - no more last minute mailings!

        (3 of 5 customers found this review helpful)

         
        5.0

        Labels

        By Mar1228

        from Undisclosed

        I like being able to mail merge letters and labels. This saves time and eliminates errors.

        Displaying reviews 1-3

        Back to top