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 Essential Training
Illustration by

Merging to create envelopes and labels


From:

Word 2007 Essential Training

with David Rivers

Video: Merging to create envelopes and labels

Once you have your letters written and merged with your recipient list, you'll probably want a say in those letters to the recipients. Now if you're going to mail them, they'll likely go into an envelope then you'll address those envelopes. And you could write down the name and address and of course your return address on each and every envelope by hand. Very time consuming. Or, using what you know about merging, you can merge your recipient list with an envelope or a label document and simply send them to your printer. It's all about saving time and energy.
Expand all | Collapse all
  1. 40s
    1. Welcome
      40s
  2. 28m 24s
    1. Getting started with Word
      1m 21s
    2. Understanding the interface
      9m 23s
    3. Navigating the interface
      11m 24s
    4. Navigating documents
      6m 16s
  3. 18m 39s
    1. Creating new documents
      5m 25s
    2. Importing documents
      4m 35s
    3. Saving documents
      5m 41s
    4. Sending documents
      2m 58s
  4. 12m 35s
    1. Using Print Preview
      2m 45s
    2. Using Quick Print
      2m 31s
    3. Setting print options and printing
      7m 19s
  5. 23m 29s
    1. Selecting text
      3m 45s
    2. Formatting text
      5m 2s
    3. Using Find and Replace
      3m 35s
    4. Undo, Redo, and Repeat
      3m 26s
    5. Copying, pasting, and moving text
      4m 37s
    6. Showing formatting
      3m 4s
  6. 20m 30s
    1. Using indents
      3m 52s
    2. Setting justification
      3m 19s
    3. Changing line spacing
      4m 11s
    4. Setting tabs
      6m 10s
    5. Using the Highlighter
      2m 58s
  7. 38m 26s
    1. Changing margins
      5m 54s
    2. Changing orientation
      2m 29s
    3. Page numbering
      5m 41s
    4. Choosing paper size and source
      3m 59s
    5. Headers and footers
      7m 23s
    6. Applying a Page Background
      7m 56s
    7. Using Watermarks
      5m 4s
  8. 20m 10s
    1. Checking spelling and grammar
      4m 54s
    2. Finding synonyms
      3m 37s
    3. Looking up words and translations
      4m 55s
    4. Setting document proofing options
      6m 44s
  9. 23m 19s
    1. Modifying Environment settings
      7m 46s
    2. Modifying Display and Document settings
      6m 47s
    3. Modifying toolbars and keyboards
      8m 46s
  10. 15m 7s
    1. Creating a bulleted list
      7m 27s
    2. Creating a numbered list
      3m 36s
    3. Editing a list
      4m 4s
  11. 55m 28s
    1. Creating tables from scratch
      5m 29s
    2. Creating tables from text
      3m 25s
    3. Inserting an Excel spreadsheet
      5m 3s
    4. Modifying tables
      7m 44s
    5. Formatting tables
      7m 32s
    6. Making calculations in a table
      4m 13s
    7. Creating charts
      5m 44s
    8. Modifying chart data
      2m 8s
    9. Modifying chart appearance
      12m 29s
    10. Creating text from a table
      1m 41s
  12. 10m 18s
    1. Using Styles
      3m 3s
    2. Creating Styles
      3m 38s
    3. Editing and deleting Styles
      3m 37s
  13. 9m 21s
    1. Creating and using Building Blocks
      4m 27s
    2. Editing and organizing Building Blocks
      4m 54s
  14. 26m 23s
    1. Creating a Mail Merge
      13m 27s
    2. Creating a Data Source
      5m 21s
    3. Merging to create envelopes and labels
      7m 35s
  15. 8m 58s
    1. Sorting text
      4m 15s
    2. Sorting numbers
      2m 11s
    3. Sorting in tables
      2m 32s
  16. 10m 36s
    1. Creating Macros
      5m 40s
    2. Playing a Macro
      1m 46s
    3. Editing a Macro
      3m 10s
  17. 10m 13s
    1. Working with Newspaper Columns
      5m 31s
    2. Working with Parallel Columns
      4m 42s
  18. 24m 13s
    1. Working with Pictures and Clip Art
      10m 23s
    2. Working with Shapes
      5m 10s
    3. Working with SmartArt
      8m 40s
  19. 40m 40s
    1. Tracking changes
      7m 40s
    2. Reviewing changes
      3m 42s
    3. Sending and faxing documents
      3m 39s
    4. Password-protecting documents
      3m 4s
    5. Linking and embedding
      10m 7s
    6. Inspecting a document
      2m 43s
    7. Encrypting a document
      2m 45s
    8. Adding a digital signature
      7m 0s
  20. 30m 12s
    1. Creating cross-references
      3m 41s
    2. Creating a table of contents
      4m 8s
    3. Creating an index
      4m 43s
    4. Creating footnotes and endnotes
      7m 17s
    5. Using hyperlinks
      4m 24s
    6. Using bookmarks
      3m 26s
    7. Using a document map or thumbnails
      2m 33s
  21. 29s
    1. Goodbye
      29s

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 Essential Training
7h 8m Beginner Jan 23, 2007

Viewers: in countries Watching now:

From a new interface to timesaving content galleries, the latest version of Word brings a lot to the table. Instructor David Rivers explains each of its new features and attributes, from understanding and navigating its new interface, to using new formatting controls and extensive page layout techniques. Whether new to Word or wanting to learn about the new version, Rivers gives insight for increased productivity and professional documents with Word 2007. Exercise files accompany the tutorials.

Subjects:
Business Word Processing Teacher Tools Education Student Tools
Software:
Word
Author:
David Rivers

Merging to create envelopes and labels

Once you have your letters written and merged with your recipient list, you'll probably want a say in those letters to the recipients. Now if you're going to mail them, they'll likely go into an envelope then you'll address those envelopes. And you could write down the name and address and of course your return address on each and every envelope by hand. Very time consuming. Or, using what you know about merging, you can merge your recipient list with an envelope or a label document and simply send them to your printer. It's all about saving time and energy.

So let's start with envelopes and then we'll try with labels. The first thing you need to do is make sure you close any documents you have open from the previous lessons because we're in the middle of a couple merges there. So you want your screen to look like mine. Before you go up to the Office button, and click New, and make sure New Blank Document is selected before you click Create. Now this is not our envelope by any means, but that will happen. We need to start with this new blank document though to get it going. Now we can go up to the Mailings tab here and start a mail merge this time, though from the drop-down list, we're going to select Envelopes.

And as soon as we do that, the Envelope Options appear and you see the Envelope Options tab is selected, and there's our default envelope, a size 10 envelope, which is a 4.5 x 9.5 inch. And below we can play around with the fonts for the delivery address and the return address if we wanted to, and we can adjust where they're located on the envelope, how far down from the top and how far over from the left for both that addresses. You can see Auto is selected, giving us this preview down below. Personally, that's exactly the way I want it, so I'm going to click OK.

Right away, we got our envelope created now, with our cursor flashing in the top left corner, and it's time to put in some information on this envelope. Now our return address is not going to change so we can just simply type that in. I'm going type in my last name only and hit Enter and type in an address, how about 12 Spruce Street? And make that in Ojai, California, and I'll makeup a zip code here.

OK, so there's our return address. Now it's time for the delivery address and because we've set this up using our Start Mail Merge button, we can come down here into the envelope and just click and you'll see that there is a block here for that particular address. And you can see that the cursor's flashing here and in towards the middle of the envelope. It's all set up for us so we don't have to do it. All we need to do now is select our recipients. So if I go up to Select Recipients up here, I can type a new list like we did in the first lesson in this chapter.

I could use my Outlook contacts or use an existing list that's already been created for me and that's what we're going to select here: Use existing list. Next we'll need to navigate to the lesson 13 folder of your exercise files. So mine are in my documents, there's my lesson 13 folder. Double-clicking opens them up and look at that. We do have a Microsoft Access database called envelope label list. We'll click that and then Open. All that happens now is we've got a number of other buttons that become active because we selected our recipients.

And I love this new feature here called the Address Block. In the old days we would have to select the first name field, the last name field, the address, the city, the state, the zip, etc. and put them in the right spots on your envelope one by one. Now we've got this entire Address Block button, so give it a click. You can see, we just simply turn on or off of some of the options, we saw this in previous lessons. We don't have a company name, this is the name format that I'm going be use, the postal address is going to go in with this option, if it's not the US, that might change up the format, but here's a preview of what that's going to look like.

Not in this location, but in this format. And if everything looks good, I simply click OK. You can see the address block is inserted and it's ready for me to start merging. So as soon as we put that in, the Preview Results button up here under the Preview Results group becomes available. And if we give it a click, we see a preview for some actual data in this spot on our envelope. Excellent. We can also move from recipient to recipient using these navigation buttons. There's our second one and everything looks good and fits perfectly.

All that's left to do now is to finish the merge at this point and for us, that would mean inserting a stack of envelopes in your printer and then hitting the Print button. So we'll go up to finish and merge right here. And if we wanted to, we would print our documents. If we needed to, we could edit the individual documents, but really it's just an envelope with an address on it. We could even send e-mail messages. So if we selected print documents, like I said we'd fill are a printer or manual feed on our printer with envelopes, unless you got an envelope feeder and off it goes.

OK. I'm just going to click outside here of my address block in my envelope to see the finished result. So once the printer sends out all of the printed envelopes, you're ready start licking some stamps and send them off. Now the other option is to actually use labels instead of printing right on the envelope. When you put a sheet labels through your printer, you're going to peel off the labels and stick them on a blank envelope. So let's see what that's like. We'll go up to Start Mail Merge. But this time we'll select Labels.

So, just like when we did envelopes, we've got some options and you can see if we had labels that went through a continuous feed printer, like the old dot matrix where you have a tractor feed, that would be great, but page printers is usually what people are using these days, and you can see its to come from my default tray. Perfect. Then I would come down and choose the actual label then I'm using. So you can see we have some vendors here like Microsoft. I'm going to go down to Avery, down here, US letter and then I find my actual model number for my labels here and it's really just a matter of looking at your box of labels and finding the number and matching it up here.

And once you've got your label options set up, you click OK. All right. In order to apply the selected label options, Word must delete the current contents of this document we're looking at. Remember this is a merge result right, so we don't need to save that. We click OK. Right, so here's our label, and we would simply start entering data at this point, everything else so we did for putting in our address block, everything we did for creating her and envelopes a moment ago, applies here to our labels as well. Alright, so keep in mind that when we add an address block that what we're looking at is a preview.

Clicking Preview Results allows us to see the actual results. So again, we would finish the merge. We would print the documents, you put your label sheet into your printer and off it goes to the print and all you do is peel off those labels like I said and stick them on the envelopes. So now you're set. Just a hint though. You probably want to print out an equal amount or more of your return address labels to stick on to those envelopes too. And your choices would be to create a recipient list of 30 copies of your own name and address or whatever number matches your label sheet.

Or you could copy and paste your own name and address on a blank sheet of labels. Either way, you'll be saving yourself a ton a time thanks to the merge feature in Word.

There are currently no FAQs about Word 2007 Essential Training.

 
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 Essential Training.

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.