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

Start learning with our library of video tutorials taught by experts. Get started

Word 2007: Creating Envelopes and Labels
Illustration by Neil Webb

Matching fields


From:

Word 2007: Creating Envelopes and Labels

with David Rivers

Video: Matching fields

When performing a Mail Merge with a recipient list that was created in another application, say Microsoft Excel, for example, you might want to make sure that the column headings in the Excel file match up with the fields in your Word document, whether it be a form letter or an envelope or even both. That's what we're going to look at right now. We're going to connect this to a recipient list that was created in Microsoft Excel. So, we'll first go to the Mailings tab and click Select Recipients. We're going to Use an existing list, so we'll select that.
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

Watch this entire course now—plus get access to every course in the library. Each course includes high-quality videos taught by expert instructors.

Become a member
please wait ...
Word 2007: Creating Envelopes and Labels
2h 36m Intermediate Feb 10, 2010

Viewers: in countries Watching now:

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
Subject:
Business
Software:
Word
Author:
David Rivers

Matching fields

When performing a Mail Merge with a recipient list that was created in another application, say Microsoft Excel, for example, you might want to make sure that the column headings in the Excel file match up with the fields in your Word document, whether it be a form letter or an envelope or even both. That's what we're going to look at right now. We're going to connect this to a recipient list that was created in Microsoft Excel. So, we'll first go to the Mailings tab and click Select Recipients. We're going to Use an existing list, so we'll select that.

If you've got the Exercise Files, navigate to the Exercise Files folder and open up the Chapter 3 folder and double- click the 03_04 subfolder where you'll find that workbook created in Microsoft Excel. It's called Addresses. With it selected, we click Open. There's only one table to connect to. It's called AddressList. It's already highlighted, so click OK and now we've got our recipient list. The other thing we're going to do is merge with a list of names and addresses to create this form letter, but we also want the envelope.

So, we'll add the envelope by clicking the Envelopes button in the Create group. You can include the return address. You should see your own default return address there, and click the Add to Document button. This adds the envelope to the very top. So, now we're going to zoom out. You can use the Zoom slider until you can see the entire envelope, and down below, we've got space here with the salutation as well as space for the address block. So, we can add it to either place. I'm going to add it just above the salutation here by inserting the fields and then we'll copy them to the envelope.

So, let's go up to the Write & Insert Fields group to Insert Merge Fields. Before we do that, like I said, we want to make sure that they're matched up with the column headings in our Excel file. So, we'll click the Match Fields button and typically, Word does a good job of matching up column headings with the usual fields that would be used in a Mail Merge, which we see on the left-hand side here. So, for example, Courtesy Title was automatically matched to the Title column in our Excel file. First Name is spelled identically to the file column heading in our Excel file.

So, it's matched up. But you'll see some of them aren't, like Suffix, for example. We'll click the dropdown here and there is a field or a column heading. It's the short form of suffix and we'll have to match this one up by selecting it, one that we had to do manually. Now I know for the fact, there's no Nickname or Job Title column in our Excel file. Company Name is matched up with company in the address lines. As we scroll a little further down, you'll notice that after City, State, we've got Postal Code on the left and it's not matched. We need that on the envelope, so we'll click the dropdown and sure enough, there is a field titled Code right here.

So, that's the column heading in the Excel sheet and we're going to match it up ourselves. Country or Region got matched up with Region and I think that's everything. Notice there's a checkbox down here as well to remember this matching for this set of data sources on this computer. So, automatically those matches will occur if we select this checkbox next time. So, we'll click OK and now we've got our fields matched up. We just need to insert them. So, let's insert a merge field by clicking the Insert Merge Field dropdown. We'll add the Title, leave a space, insert the First_Name, leave a space, insert the Last_Name, again, leave a space and we're going to insert the Suffix.

If there's no suffix, nothing will appear there. So, that's the entire first line. We press Return, or Enter, on the keyboard to move down to the next line and we'll continue with the Company_Name. Press Return, or Enter, on the keyboard and we'll continue adding the address now. So, Address_Line_1, press Return. If there's a second line address, such as a suite, we'll need the Address_Line_2, press Return again, or Enter, and City, put in a comma and space.

Insert the next field, which is State. Leave a space. Insert the next one, which is Code and we'll press Return. For our international customers, it will be important that the country or region appear. Now one more that needs to be added, we'll click right after the salutation here for Dear. It might be an extra space there you can take out. We're going to insert the First Name. Now you could do a Title and Last Name if you wanted to, but, to make it less formal, we'll just use the First Name.

So, now we've got everything we need on the form letter, but we need this all to appear as well in the envelope. So the nice thing is we can just click -and-drag across each of those lines. Ctrl+C is the keyboard shortcut for copy. Once you've done that, move up to the envelope, just click in the lower half around the center and you'll see there's an area reserved here for the address block where you can do Ctrl+V now, the shortcut for pasting. Notice that the alignment is in there as well. So, if you needed to adjust that, you could. Just select it all again, and if you want, you can just simply use the Ruler at the top, change the margin if you like, slide it over.

See how everything moves over? And all we need to do now is take a look to see if this is going to print out right by clicking the Preview Results button. So, there is the first example you can see using the Suffix and the Title. Now as we scroll down to the form letter, it appears there as well. We can move to the next record to see what it looks like. There's the envelope and continue and when you've finished previewing your results, just click the Preview Results button again. This is the end result that you'll want to save, so you want to save up your document.

It'll be saved with the envelope and all the codes. Thanks to matching fields, we're able to make use of all of the fields available to us from our Excel spreadsheet.

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

 
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.
Upgrade now


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 Upgrade now

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

Congratulations

You have completed Word 2007: Creating Envelopes and Labels.

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


OK
Become a member to add this course to a playlist

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

Get started

Already a member?

Become a member to like this course.

Join today and get unlimited access to the entire library of video courses.

Get started

Already a member?

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:

The classic layout automatically defaults to the latest Flash Player.

To choose a different player, hold the cursor over your name at the top right of any lynda.com page and choose Site preferencesfrom the dropdown menu.

Continue to classic layout Stay on new layout
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.

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.