Take the Mystery Out of Mail Merge

mail merge

Whether your run your own business, you’re planning your wedding or another big event, or you’re sending out wedding invites, getting the address labels done can be a hassle. But we’re here to help. In just a few steps, we will help you take the mystery out of mail merge for fast, easy labels just the way you want them. It’s a time-saver you won’t want to miss.

1. Collect your names and addresses

If your address book consists of handwritten names and addresses, not to mention scribbled scraps of paper and torn off return address labels, then you’ve come to the right place. When you create your single, consolidated mailing list, that’s your key to saving time in the long run. Instead of hand addressing envelopes year after year, all you have to do is enter the names and addresses one time in your spreadsheet program.

2. Select a spreadsheet program

Whether you have different mailing lists in different programs, or you’re creating one for the first time, choose one database program you’ll want to use to enter your information. Microsoft® Excel® and Google Drive™ are two programs you might consider. Once you’ve entered your names and addresses to create your mailing list, updating your information is a snap. No more crossing out addresses in your address book every time someone moves and gets a new address. 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 programs.

3. Use Avery Design & Print Online

Avery Design & Print is available for free. Avery Design & Print will import the names that you just typed into Microsoft Excel or another spreadsheet program and get them ready to print.

4. Mail merge your information

Now you’re ready for the fun part. If you’re using Avery Design & Print Online, select a text box then click Start Mail Merge under the Import Data (Mail Merge) tools. The application will help you locate your file and upload the names, then format the labels the way you want and you’re done! Watch the demo to see it in action!

5. Peel and mail, and away they go

Now that you’ve conquered the task of creating a mailing list and the mail merge, here’s one more handy tip to complete your successful mailing. You can use Avery Easy Peel® White Labels on your envelopes. If you want professionally printed address labels, Avery WePrint is the way to go. Customize and order online with fast delivery.

Now that mail merge is no longer a mystery, try it out yourself! Get started with Avery Design & Print. Once you create your own mailing list and become a pro at mail merge, you can use these same steps for adding names to name badges, place cards and much more.   

Author: Melanie Neff

Melanie has an extensive writing background built on an impressive journalism foundation. As a journalist for USA Today and The Los Angeles Times for almost 20 years, she covered everything from the Los Angeles riots, fires and floods to LA Lakers and Clippers games and movie premieres. She followed her newspaper career with a long tenure covering commercial real estate financing and development. Melanie has currently been writing about small business marketing and labeling needs for the past 10 years. She thrives on reading, researching and expanding her knowledge of everything going on in today's business world and looks to provide the most valuable information she can to her readers.

4 thoughts on “Take the Mystery Out of Mail Merge”

  1. Once I watched the video on how to mail merge I was able to switch the data input. THe issue I had was I have a design that had different sized fonts for each line and saved it but when I opened the project it changed to all the same size. It would be great to be able to have each field (column) brought in to it’s own text box but that’s more what a real applications does not a web based application.
    I wish Avery still had a downloadable application for the Mac.

    1. Hi,
      In Design & Print Online you can merge each column into separate text boxes on a project. Check out this article on how to do it. Also, we are in the process of updating this video. The team said they will keep this in mind when they update it. I’ve passed your suggestion for a downloadable application for Mac onto our development team. Thank you for reading.

Leave a Reply

Your email address will not be published.

fifteen − 14 =