WEBVTT
Kind: captions
Language: en

00:00:11.570 --> 00:00:16.010
Mail Merge is a great time-saver if you need
to create multiple documents that are the

00:00:16.010 --> 00:00:20.640
same, but unique in some way - like name tags
for an event, or envelopes printed with each

00:00:20.640 --> 00:00:23.020
person's name and address.

00:00:23.020 --> 00:00:28.280
The document I have here is a letter offering
customers a discount on their next order.

00:00:28.280 --> 00:00:33.190
I want to personalize it by addressing each
copy of the letter to the customer, using

00:00:33.190 --> 00:00:36.370
information I have stored in a spreadsheet.

00:00:36.370 --> 00:00:41.300
To begin, go to Mailings, then Start Mail
Merge.

00:00:41.300 --> 00:00:45.820
The Step by Step Mail Merge Wizard will walk
you through the process one step at a time,

00:00:45.820 --> 00:00:48.610
using this window on the right.

00:00:48.610 --> 00:00:53.850
The type of document I'm working on is indeed
a letter, so I'm going to click Next.

00:00:53.850 --> 00:00:59.649
I also plan to stick with my current document
instead of using something else, like a template.

00:00:59.649 --> 00:01:05.250
Now I need an address list, so Word can create
a copy of the letter for each customer.

00:01:05.250 --> 00:01:10.430
To start from scratch, you can "Type a new
list," then click Create to enter your recipients

00:01:10.430 --> 00:01:14.390
individually.

00:01:14.390 --> 00:01:23.040
Alternatively, if you do have a list (like
an Excel workbook in my case), choose "Use

00:01:23.040 --> 00:01:29.630
an existing list," then Browse to find it.

00:01:29.630 --> 00:01:35.119
Now click Open and select the worksheet that
contains the list - I know mine is in Sheet

00:01:35.119 --> 00:01:37.659
1.

00:01:37.659 --> 00:01:44.140
In this window, you can check or uncheck all
or individual recipients to decide who's included

00:01:44.140 --> 00:01:45.360
in the mailing.

00:01:45.360 --> 00:01:50.640
I would like to include everybody, so I'm
going to go ahead and click OK, and now it

00:01:50.640 --> 00:01:55.159
shows that workbook as my recipient list.

00:01:55.159 --> 00:01:57.399
Now it's time to write my letter.

00:01:57.399 --> 00:02:03.009
You can add something unique for each recipient,
including their address, a personal greeting,

00:02:03.009 --> 00:02:06.990
custom postage (which requires special software),
and more.

00:02:06.990 --> 00:02:09.780
I'd like to add an address block first.

00:02:09.780 --> 00:02:15.239
Just place your cursor where you want it to
go, then click the item.

00:02:15.239 --> 00:02:19.470
Here's a preview of what it's going to look
like, and a couple different formats to choose

00:02:19.470 --> 00:02:23.019
from for the recipient's name.

00:02:23.019 --> 00:02:28.290
Click OK, and a placeholder will appear in
your document, where the address will go later.

00:02:28.290 --> 00:02:31.790
The other thing I'd like to add is a greeting.

00:02:31.790 --> 00:02:42.010
Again, you have a preview here, and the ability
to change some of the formatting.

00:02:42.010 --> 00:02:45.239
Let's move onto the next step: previewing
the finished product.

00:02:45.239 --> 00:02:49.940
I just want to make sure the information from
my list appears the way it should.

00:02:49.940 --> 00:02:56.730
You can take a look at each recipient's copy
by clicking the arrows here.

00:02:56.730 --> 00:03:01.420
Everything looks great, so let's complete
the merge.

00:03:01.420 --> 00:03:05.540
If you click the Print command, Mail Merge
will ask which pages you want to print before

00:03:05.540 --> 00:03:07.700
sending you to the final step.

00:03:07.700 --> 00:03:13.810
I want to print every document in my recipient
list, so I'm going to keep All.

00:03:13.810 --> 00:03:20.000
Now all you have to is adjust the settings
if you need to, then click OK.

00:03:20.000 --> 00:03:24.780
Knowing how to use Mail Merge is a must for
creating multiple letters, labels, envelopes,

00:03:24.780 --> 00:03:25.820
and more.

00:03:25.820 --> 00:03:51.670
The possibilities - and the time and energy
you'll save - are almost limitless.