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
 
3.0

(based on 5 reviews)

Ratings Distribution

  • 5 Stars

     

    (2)

  • 4 Stars

     

    (0)

  • 3 Stars

     

    (1)

  • 2 Stars

     

    (0)

  • 1 Stars

     

    (2)

50%

of respondents would recommend this to a friend.

Reviewed by 5 customers

Displaying reviews 1-5

Back to top

(2 of 2 customers found this review helpful)

 
1.0

Terrible product

By Grace

from Hollywoood FL

See all my reviews

Pros

  • None

Cons

  • Flimsy Construction
  • Inefficient

Best Uses

  • Everyday Use

This product is so limited compared to
Design Pro...fonts are awful, no way to create my own database individually, without using Excel. Program is slow, and I don't want to create anything online. I only print locally. PDF creation is impossible and never matches the design I've done... fonts and images don't reporduce. I hate this program.

(1 of 1 customers found this review helpful)

 
1.0

Limit of 300K files????????

By Maggie

from Kempton, Pa

When I tried to load an xlsx with 67 rows and 6 columns of address data (not really very much), it told me the file had to be 300K or less.

The file was originally created in Numbers on a Mac and then exported to an Excel format. When I cut the number of rows in half and resaved instead of 496K the new file was 494K..

Unless I'm doing something wrong, I can't imagine why such a limit exists. It certainly prevents me from using it

(4 of 5 customers found this review helpful)

 
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 7 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-5

        Back to top