Start your free trial now, and begin learning software, business and creative skills—anytime, anywhere—with video instruction from recognized industry experts.

Start Your Free Trial Now

Creating and selecting recipient lists in Word

Creating and selecting recipient lists in Word provides you with in-depth training on Business. Taug… Show More

Word 2007: Creating Envelopes and Labels

with David Rivers

Video: Creating and selecting recipient lists in Word

Creating and selecting recipient lists in Word provides you with in-depth training on Business. Taught by David Rivers as part of the Word 2007: Creating Envelopes and Labels
Expand all | Collapse all
  1. 6m 57s
    1. Welcome
      1m 6s
    2. Prerequisites and requirements before you begin
      2m 57s
    3. Goals and expectations for this course
      1m 20s
    4. Using the exercise files
      1m 34s
  2. 21m 13s
    1. Setting up a return address
      3m 3s
    2. Printing a single envelope
      4m 18s
    3. Adding an envelope to your document
      2m 20s
    4. Create envelopes from a template
      2m 32s
    5. Printing a single label
      2m 40s
    6. Printing a sheet of the same label
      2m 22s
    7. Creating labels from a template
      3m 58s
  3. 19m 36s
    1. Creating and selecting recipient lists in Word
      8m 41s
    2. Using an Excel workbook as a recipient list
      3m 23s
    3. Editing a recipient list in Word
      5m 53s
    4. Using Outlook contacts as a recipient list
      1m 39s
  4. 35m 51s
    1. Envelopes and the Mail Merge wizard
      7m 12s
    2. Inserting merge fields
      4m 33s
    3. Setting merge rules
      5m 34s
    4. Matching fields
      5m 57s
    5. Formatting envelopes before merging
      4m 58s
    6. Adding graphics to envelopes
      2m 39s
    7. Saving and reusing envelope files
      1m 46s
    8. Using print options with merged envelopes
      3m 12s
  5. 30m 32s
    1. Labels and the Mail Merge wizard
      6m 19s
    2. Manually merging labels with recipients
      5m 57s
    3. Setting merge rules
      3m 11s
    4. Formatting labels before merging
      4m 18s
    5. Adding graphics to labels
      3m 28s
    6. Reusing existing label files
      2m 29s
    7. Printing merged labels
      4m 50s
  6. 16m 14s
    1. Signing up with an e-postage service
      3m 29s
    2. Printing postage on a single envelope
      4m 42s
    3. Printing postage in a mail merge
      2m 57s
    4. Printing postage with labels
      5m 6s
  7. 25m 57s
    1. Dealing with irregular envelopes
      3m 36s
    2. Dealing with irregular labels
      5m 38s
    3. Preventing text from printing too close to the edge of a label
      4m 42s
    4. Creating business cards
      5m 3s
    5. Creating postcards
      6m 58s
  8. 19s
    1. Goodbye

please wait ...
Creating and selecting recipient lists in Word
Video Duration: 8m 41s 2h 36m Intermediate


Creating and selecting recipient lists in Word provides you with in-depth training on Business. Taught by David Rivers as part of the Word 2007: Creating Envelopes and Labels

View Course Description

In Word 2007: Creating Envelopes and Labels, instructor David Rivers shows how to use Microsoft Word to address, format, and print envelopes and labels. Whether to a single recipient or multiple addresses, timesaving techniques are shown that result in crisp and elegant correspondence. This course covers how to create a recipient list within Word or retrieve an existing contact list from Outlook, and then use the list in Mail Merge to address labels or envelopes. Other topics include customizing labels with graphics, printing electronic postage, and dealing with common printing errors. Exercise files accompany the course.

Topics include:
  • Printing from a sheet of labels
  • Creating recipient lists
  • Using the Mail Merge wizard
  • Printing e-postage
  • Creating business cards

Creating and selecting recipient lists in Word

When you create an envelope or a label file in Word 2007, the purpose is usually for adding names and addresses to print them out and actually put them through the mail. If you want to add a number of names and addresses, creating multiple labels and envelopes, you'll likely want to create what's called a Recipient List, which is a list of your names and addresses kept separate from your label or envelope file so you can merge them later on. This way you can concentrate on the list itself, updating information when needed, and merge it with new envelope files, existing envelope files or label files at any time.

So, we're going to start by creating a brand new Recipient List, assuming you have no contacts. You don't have a list of names and addresses anywhere. You can create it right here in Microsoft Word. So we're going to work with this TTEnvelope file and we're going to go up to the Mailings tab and under Select Recipients, when you click that button, the first option is to actually type a new list. So, we'll do that, and you see the New Address List dialog box appear with a whole bunch of columns and a flashing cursor waiting for you to start typing information.

I'm just going to move this over to the left side and move my mouse pointer to the right border when I see the double arrow, click-and-drag that out. You can see there's quite a few columns of information that can be filled in. They don't all have to be filled in, just information you know you're going to need on an envelope or a label. So let's just type in our first actual name and address. You can type anything you like in here. I'm going to make one up. Use your Tab key to move from field to field. If there's no company name, just skip over it. If there is one, you can type it in and tab to the next column, which is our first address line, typically, the street address.

So, I'm going to type in a make- believe address here, 123 Main St. If there's a second line, you can add it, like a suite or a floor. If not, just tab past it and leave it blank. Word is very good at not creating blank lines where no information exists. I'm going to type in '1st Floor' here. City, again, tabbing across, filling that in. The Country or Region, if you're going to be mailing out to international customers, you may want to keep track of this information.

When you tab over to the next column, it becomes visible and we can scroll over there. There is a Home Phone number, Work Phone and Email Address column that can be filled in, but typically, that information doesn't really appear on a label or envelope. So, if you want to leave it blank, you can just continue tabbing across or click the New Entry button. Either way, you'll eventually create a brand new entry and you would continue now, typing in additional names and addresses. These are your recipients. Now, before we save this up, you'll notice, down below, you've also got a button for customizing those columns.

So if you don't like the way they're named, you don't like the order or maybe there's columns you don't need, and missing columns you do need, click the Customize Columns button where you'll see a list of your field names. Let's say we don't need our email address. We'll select it and over here on the right click Delete. We'll have to confirm that by clicking Yes, and it's gone. Let's do the same for our Work Phone as well as the Home Phone. So, with those gone, we just narrowed the list of fields. Let's rename one. Let's go to Address Line 1, and just to be clear, we'll click the Rename button and type right over what's there.

We'll type in Street Address and click OK. Down below, Address Line 2 is a little more self-explanatory. It's the second line after the Street Address. If you want to change the order, you can. For example, if you want First Name to come after Last Name, just use your Move Up and Move Down buttons. I'm going to leave them as is. The order that you fill in the information is all you're changing. You can place these fields anywhere you want on the label or envelope after the fact. So, we'll click OK.

That updates our columns. Now to update your actual recipient list and save it, click OK. And this opens up the Save Address List dialog box. You'll notice, by default, it's going to a folder called My Data Sources. That's what you're going to see at the top. It's under your Documents folder. This will make it easily accessible by other Office applications, and it's also the default location that you'll go to whenever you want to open up an existing list. So all we have to do is give it a name. In this case, let's type in something like 'BusinessContacts' and click Save.

When you do this, you've actually created the list and you've linked it to your existing document, so in this case, our Envelope file. You'll notice now the Edit Recipient List button is available to us. If we click this, you'll see that one recipient that's been added, the blank one that got started, and if you want to continue editing, you just select the data source and click the Edit button, and you're back into adding additional recipients or changing existing ones if you wanted to. Click OK, update by clicking Yes and then just click OK to close that up.

So, you'll always have access to that recipient list, whether it's this existing file or another file, like a sheet of labels, for example. And you can always update that recipient list either from within Word, using the Edit Recipient List button, which you may have noticed too. It was saved as a Microsoft database. So, you use Access if wanted to go in there and update the list as well. So, that's this document. You can also access a Word table. I don't highly recommend creating your recipient list in a Word table, but if you've already got your list of contacts in a Word table, you might want to use it as your recipient list.

Let's check it out. We'll click the Office button and open. In the Exercise Files, you'll find the Addresses document. When you click Open, it's all just a list of names and addresses in a table. You can see the very first row is actually our column headings, sometimes known as the header row. With the Table tools> Design tab selected, you want to ensure your cursor is anywhere in the top row and select header row, so that these will be used as column headings and not actually merged onto a label or an envelope.

So, these are your Table tools. Let's go back to our Office button and let's start a new blank document. Before we even create labels or envelopes, we want to hook into that recipient list. Well, if we try to, while it's open, let's see what happens. Click Mailings, Select Recipients, this time Use Existing List, and we're going to go to our table. So we're going to go back to our Exercise Files and in the Chap02 folder, we'll find our Addresses. Click Open.

It's now connected, so if we go to Edit Recipient List, you're going to see that whole list of names and addresses we just saw in the table itself in that Word document. So, we're using it now as our recipient list. If we wanted to, we could click Data Source, click Edit to edit the contents of that table right from here within our document in Word that we are connected to. This time, it looks a little bit different though. It is a data form. So, we can use our Navigation buttons to move across through the various names and addresses.

Go right to the last one. If it's blank like this, you might want to delete it, so you can click the Delete button. You can add new right from here, and when you're done, click the Close button and you're back to your Mail Merge Recipients. Click OK and you're back to your document. So you're connected to a recipient list, which is simply a Word table, a document containing a table, and you could continue now at this point creating your envelope or label file knowing that you're connected to a Word document, which has a table full of names and addresses.

So, if you're going to be creating a brand-new recipient list, I highly recommend using it right here from the Select Recipients button on the Ribbon. Type new list. If you've already got your list of names and addresses in a Word table, use the Use Existing List. You'll always have access to it from any envelope or label file you create, and by keeping the recipient list separate from the document, you can update either separately and use that recipient list with multiple label files and multiple envelope files.

There are currently no FAQs about Word 2007: Creating Envelopes and Labels.






Don't show this message again
Share a link to this course

What are exercise files?

Exercise files are the same files the author uses in the course. Save time by downloading the author's files instead of setting up your own files, and learn by following along with the instructor.

Can I take this course without the exercise files?

Yes! If you decide you would like the exercise files later, you can upgrade to a premium account any time.

Become a member Download sample files See plans and pricing

Please wait... please wait ...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.

Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ .

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

Join now Already a member? Log in

* Estimated file size

Are you sure you want to mark all the videos in this course as unwatched?

This will not affect your course history, your reports, or your certificates of completion for this course.

Mark all as unwatched Cancel


You have completed Word 2007: Creating Envelopes and Labels.

Return to your organization's learning portal to continue training, or close this page.


Upgrade to View Courses Offline


With our new Desktop App, Annual Premium Members can download courses for Internet-free viewing.

Upgrade Now

After upgrading, download Desktop App Here.

Become a Member and Create Custom Playlists

Join today and get unlimited access to the entire library of online learning video courses—and create as many playlists as you like.

Get started

Already a member?

Log in

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.

You started this assessment previously and didn’t complete it.

You can pick up where you left off, or start over.

Resume Start over

Learn more, save more. Upgrade today!

Get our Annual Premium Membership at our best savings yet.

Upgrade to our Annual Premium Membership today and get even more value from your subscription:

“In a way, I feel like you are rooting for me. Like you are really invested in my experience, and want me to get as much out of these courses as possible this is the best place to start on your journey to learning new material.”— Nadine H.

Thanks for signing up.

We’ll send you a confirmation email shortly.

Sign up and receive emails about and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from

Sign up and receive emails about and our online training library:

Here’s our privacy policy with more details about how we handle your information.

submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.