Goodwill Community Foundation creating
opportunities for a better life mail
merge is a great time-saver if you need
to create multiple documents that are
mostly the same but unique in some way
like name tags for an event or envelopes
printed with each person's name and
address the document I have here is a
letter offering customers a discount on
their next order
I want to personalize it by addressing
each copy of the letter to the customer
using some information I have stored in
a spreadsheet to begin go to the
mailings tab then start mail merge and
select step by step mail merge wizard
this will walk you through the process
one step at a time using this pain on
the right the type of document I'm
working with is a letter so I'm going to
go ahead and click Next
and I also plan to stick with my current
document instead of using something else
like a template
now I need an address list so we can
create a copy of each letter for each
customer to start from scratch you can
type a new list then click create to
enter your recipients individually
alternatively if you do have an exist
document with the information you need
like an Excel workbook in my case choose
use an existing list then browse to find
it
now click open and select the worksheet
that contains the list I know mine is in
sheet 1
in this example you can uncheck any
recipients that you don't want to
include I want to include everybody
though so I'm going to go ahead and
click OK
and now it shows that workbook as my
recipient list so now it's time to write
my letter you can add something unique
for each recipient including their
address a personal greeting and more I'd
like to add an address block first just
place your cursor where you want it to
go
then click the item
here's a preview of what it's going to
look like and a few alternative formats
to choose from for the recipients name
like okay
will appear in your document this is
where the address will go later on
like to add as a greeting
again you have a preview here and the
ability to change some of the formatting
if you'd like
let's move on to the next step
previewing the finished product
I just want to make sure the information
from my list appears the way it should
you can take a look at each recipients
copy by clicking the arrows here
everything looks great so let's complete
the merge
if you click the print command mail
merge will ask which pages you want to
print before sending you to the final
step I want to print every document in
my recipient list so I'm just going to
keep all
now all you have to do is adjust the
settings if you need to then click okay
knowing how to use male marriage is a
must for creating multiple letters
labels envelopes and more the
possibilities along with the time and
energy you'll save are practically
endless