Back to top

Mail Merges with Microsoft Excel and Word: Part 2

Published on Fri, 10/04/2019 - 08:48am
mailbox

In Part 1, we learned how to create an address list in Microsoft Excelâ. While you can create a data source using Microsoft Word’s mail merge ribbon tab, you’ll find that the initial setup of the list and then its data entry is much easier to perform in Excel.

There are two main ways that you may decide to perform a mail merge and use Excel as the data source. We’ll look at using several ribbon buttons in Part 2 and then discuss using the mail merge wizard in Part 3. While you can personalize letters or address envelopes, we’ll learn how to use mail merge by creating mailing labels.

  1. Open a blank document in Word.
  2. Click the Mailings tab. 
1_2.jpg
  1. Click the Start Mail Merge dropdown arrow and then select Labels.
2.JPG
  1. From the Label Options window, select the type of paper (Page printers), Label vendor (Avery US letter is a common brand), Product number (5160 is an Avery standard mailing label).

3_4.jpg
  1. Click OK.
  2. An insertion point appears, showing where the text for the first label will be located. The Select Recipients button is now active as well.
4.JPG
  1. When you click on the Select Recipients dropdown arrow to select Use an Existing List, you are taken to File Explorer where you can navigate to the Excel mailing list you created in Part 1.
  2. Select the Excel spreadsheet and then click Open.
5.JPG
  1. The Select Table dialog box opens. Select the Excel worksheet that contains the address information, making sure to check “First row of data contains column headers” if that’s correct. Click OK.
6.JPG
  1. Your document is now ready for you to insert merge fields and has placeholders for the beginning of each label.

 

7.JPG

  1. The Insert Merge Field button has become active. Click its dropdown arrow to see a list of all fields in the data source.
8.JPG
  1. For the first line of the address, select First Name from the dropdown list, press the space bar, and then select Last Name from the dropdown list. Press Enter.
9.JPG
  1. Still using the Insert Merge Field button dropdown, select the Street field for the second line of the address. Press Enter.
10.JPG
  1. Using the Insert Merge Field button dropdown, select City and then add a comma and a blank space. Add State, a black space, and Zip.
11.JPG
  1. Click the Update Labels button to copy the fields to each label. 
12.JPG
  1. Click the Preview Results button to see how the data is arranged on the page.
13.JPG
  1. Click the Finish & Merge button dropdown to print the labels without saving the file. You can also select Edit Individual Documents to edit and/or save the label file. With the label file saved, you can print and reprint labels as needed.
14.JPG

Be sure to watch for Part 3 of this series, coming in January 2020. In the meantime, register for a Word or Excel program at the Library to learn more. You can find other online technology resources throughout our website.

Terri M.
Consumer Technology Specialist

 

Comments

Add new comment

Plain text

  • No HTML tags allowed.
  • Lines and paragraphs break automatically.
  • Web page addresses and email addresses turn into links automatically.

Resources You May Also Like

Events You May Also Like

Cloud Storage

Thu, Nov 21 2019
7:00pm - 8:00pm
Registration Required
Cloud storage allows you to save your files online, so you can access them from anywhere at any time. Learn how to store your documents, music, and photos on a cloud storage system.

Blogs You May Also Like

old cell phones

What to Do with that Old Cell Phone

There is nothing more exciting than receiving the gift of a new phone—the shiny, unscratched scree
Read More
online shopping

Oldies but Goodies: Part 1

Recently, I spent some time writing explanations for a few of the buttons on the Microsoft Excel®
Read More
pull the plug

Unplug to Power Up

As a Consumer Technology Specialist for the Library, it’s my job to get people excited about learning te
Read More
mail letter

Mailing It In

It seems like every day, everywhere we look, there are new ways to communicate: email, texting, Facebook Messenger, Instag
Read More

Was this page helpful? Yes No