New Feature: Playlist Center! Pick a topic and let our playlists guide the way.

Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member

Creating and selecting recipient lists in Word

From: Word 2007: Creating Envelopes and Labels

Video: 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.

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.

Show transcript

This video is part of

Image for Word 2007: Creating Envelopes and Labels
Word 2007: Creating Envelopes and Labels

40 video lessons · 5620 viewers

David Rivers
Author

 
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. 36m 6s
    1. Envelopes and the Mail Merge wizard
      7m 12s
    2. Inserting merge fields
      4m 33s
    3. Setting merge rules
      5m 49s
    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
      19s

Start learning today

Get unlimited access to all courses for just $25/month.

Become a member
Sometimes @lynda teaches me how to use a program and sometimes Lynda.com changes my life forever. @JosefShutter
@lynda lynda.com is an absolute life saver when it comes to learning todays software. Definitely recommend it! #higherlearning @Michael_Caraway
@lynda The best thing online! Your database of courses is great! To the mark and very helpful. Thanks! @ru22more
Got to create something yesterday I never thought I could do. #thanks @lynda @Ngventurella
I really do love @lynda as a learning platform. Never stop learning and developing, it’s probably our greatest gift as a species! @soundslikedavid
@lynda just subscribed to lynda.com all I can say its brilliant join now trust me @ButchSamurai
@lynda is an awesome resource. The membership is priceless if you take advantage of it. @diabetic_techie
One of the best decision I made this year. Buy a 1yr subscription to @lynda @cybercaptive
guys lynda.com (@lynda) is the best. So far I’ve learned Java, principles of OO programming, and now learning about MS project @lucasmitchell
Signed back up to @lynda dot com. I’ve missed it!! Proper geeking out right now! #timetolearn #geek @JayGodbold

Are you sure you want to delete this note?

No

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com 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 lynda.com.

Sign up and receive emails about lynda.com 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.