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: Mail Merge in Depth
Illustration by Neil Webb

Completing the merge


From:

Word 2007: Mail Merge in Depth

with Gini Courter

Video: Completing the merge

We have our primary merge letter open in front of us, we've done here error checking using the Preview Results tools, and now we're ready to finish our merge combining our letter with the records from the data source to create a series of personalized letters. There are two options for merging letters. You can either edit individual documents, or you can print the documents. You can think of these two choices that you find in the Finish & Merge group really as merge these to a file that I can look at then print, or merge these directly to the printer and don't stop even if I need you to.

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: Mail Merge in Depth
1h 37m Intermediate Sep 10, 2010

Viewers: in countries Watching now:

In Word 2007: Mail Merge in Depth, author Gini Courter demonstrates how to take advantage of Word's Mail Merge feature to save a tremendous amount of time creating customized documents. The course offers tutorials on creating letters, emails, envelopes, and labels. It also shows how to use Mail Merge with Outlook and Excel, creating data sources, inserting fields, using IF and other rules for customized merges, and troubleshooting Mail Merge issues. Exercise files are included with the course.

Topics include:
  • Choosing or creating a data source
  • Using Mail Merge with Outlook contacts
  • Merging data from an Excel spreadsheet
  • Inserting address blocks and greetings
  • Matching fields from a data source
  • Previewing merge results
  • Using rules for customized merges
Subject:
Business
Software:
Word
Author:
Gini Courter

Completing the merge

We have our primary merge letter open in front of us, we've done here error checking using the Preview Results tools, and now we're ready to finish our merge combining our letter with the records from the data source to create a series of personalized letters. There are two options for merging letters. You can either edit individual documents, or you can print the documents. You can think of these two choices that you find in the Finish & Merge group really as merge these to a file that I can look at then print, or merge these directly to the printer and don't stop even if I need you to.

If you need to keep a copy of the merged file, for example, to be able to provide proof that 80 individual letters were sent, then choose the first choice, Edit Individual Documents, because you will end up with one document that contains all of those letters. So, if we choose Edit Individual Documents, we can choose the number of documents. We could actually merge just one record if we wish to, or we could merge a range. We could say I'd like you to merge the first through the 10th records.

Notice that we're not filtering here. We are simply declaring a range of records that I would like to merge. So, let's go ahead and choose Edit Individual Records, merge them all, and say OK. Word will begin to create those individual letters one at a time that we can then print. If we wish, we can print them all at once or we can print just as you print any other print job in Word. We could choose to print pages 1-25, 26 and so on, if we needed to load stationary or other stock. How you print them is different then how you actually create them when you use Edit Individual Documents.

Our whole mail merge is done. We have a really long document, 206 pages long, that we can now print. We can also save it and print it again if we need exactly these same letters. But if I don't need to keep proof and I don't need to create these letters again there is really no reason for me to save this file. We can create it any time again using the primary letter in the data source. So, I am going to close this. My other choice is to print documents directly to a printer. So, if you're pleased with your mail merge and you don't need to keep a copy and you're ready to print documents, then choose Print Documents and you'll be asked again, what do you want to print? If you're going to print all of your records, you want to make sure that you have all the paper loaded that you need to have and that the print job won't be interrupted partway through.

So, this will be a good time before you say Merge to Printer to go down and if you need letterhead in the printer, make sure the letterhead is in there. Make sure somebody else in a workgroup setting hasn't swapped out the paper that you needed for some paper that they need for a current print job, because when this starts you are not going to be able to stop it from here in Microsoft Word. So, go ahead and choose the documents that you want to print. You'll note that there is nothing here at all for you to save. You click OK and head to the printer to pick up your records.

Your last choice here actually is Send Email Messages and we'll talk about that when we talk about how to create email messages in Microsoft Word, but it's not an option that you can use when you're printing documents. You know, the merge itself is really sort of anti-climactic. A couple of clicks and Word does the heavy lifting required either to generate the letters that you want into a separate file or to send them automatically to the printer. Either way, it's really easy to create these final merge letters and this final step is simply to choose Edit Individual Documents, Print Documents, and then to click OK.

There are currently no FAQs about Word 2007: Mail Merge in Depth.

 
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: Mail Merge in Depth.

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

Notes cannot be added for locked videos.

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.