Hi, in this lesson I'm gonna introduce you to a Mail Merge.
Now, a Mail Merge simply means taking a list of names and addresses and
merging them onto maybe an envelope, maybe a document, maybe a list of labels.
But it means you have multiple names and
you don't wanna have to type each one individually.
That's where the Mail Merge comes in.
Merges a list into a document.
If you click the Start Mail Merge button, I'm on the Mailings ribbon,
Start Mail Merge, we have Letters, E-mails, Envelopes, Labels, Directory.
But honestly I would start right over here where it says Step by
Step Mail Merge Wizard.
Go ahead and click that button and up pops your friend the task pane.
Now, the task pane looks a little small here, so
what I'm gonna do is I'm gonna double-click my Mailings ribbon to
collapse that ribbon 'cause that will extend my task pane.
Because some of these commands down at the bottom will hide if it doesn't have enough
room, and I just wanna be able to see them during this.
All right, in this case I'm starting on step number one, and
wants me to pick my document I'm gonna choose labels.
And it talks to me about the labels, and now I'm gonna go to starting document.
Then just read through these, how do you want to set up your mailing labels?
By using the current document?
No, change document layout?
Start from existing document?
Actually, I want to change a document layout and I wanna go to label options.
So, when I click label options, it wants to know what label style I'm using.
In this case, I do have 5360s, so I just type that in,
it finds that label style for Avery, and I can confirm the size and width.
I'll go ahead and hit, OK.
Yes, go and hit OK, and, here we have it,
this is our template, for the labels that I'm going to be printing.
All right, now leading over here next is select recipients.
I'll go ahead and click this, by using an existing list that I've already
pre-typed, by selecting from Outlook contacts.
No, I'm gonna type a brand new list, and right here I'm gonna create this list, and
then after I create it course that will be existing.
I'll go ahead and hit Create, now, this is called a database form,
once we do absolutely enter all the names that are going to be on my list.
Now, this is going to be a little tedious.
So what I'm gonna do is pause the video and
when I come back you'll see my form already entered.
As you can see my data has been entered.
I'm gonna go ahead and click OK and it wants me to save it.
So I type a name, save it accordingly and there we have it.
My Mail Merge address list.
At this point I can uncheck ones I don't want to send it to.
I can sort, filter, remove duplicates, find a certain person.
Of course, I only have three on my screen so it's pretty self explanatory.
Sometimes you'll have hundreds here and you'll want to run through it.
Whatever is left with check marks is who you will be mail merging to.
Notice right down here says Mail Merge Address List.mdb,
that means mail merge database, okay?
Microsoft database, all right, hit OK on this, and
here is the template, the Microsoft labels template.
Notice it says next record with these little arrows off to the right and left,
those are called Chevrons, those are field codes.
If you should select any of those field codes and get rid of them,
you break the field and it will not send.
So you never,
never want to get rid of any of those chevrons at the end of that field, okay?
And you see just like that I just deleted one of my chevrons,
I've just broken my Mail Merge.
So I'll Ctrl+Z to put that back, just be very gentle when you're in this area.
So now I've switched over on the right hand side to use an existing list because
I just created one.
I'm not gonna select a different one, I'm not gonna edit it, I already looked at it.
I'm gonna go here to arrange my labels.
So as you can see, just follow the pattern, go to the next step.
Okay, at this point, do I wanna use an address block, a greeting line?
No, it's not a letter.
Electronic postage, no.
Any more items?
Absolutely, I'm gonna use the address blocks.
I'm gonna click into this first label field, hit Address Blocks.
This comes up and asks me how I want it all, Mr.
or Mrs., I don't want any of that.
Insert company name, yes.
So it's showing me an example right here of how it's going to look.
And that is fine, I'm going to hit OK.
And now notice I have AddressBlock, then Next Record, Next Record, Next Record.
Here is a very important part of this step.
Right down here, oops, I think it went too far.
All right, down here it says update all labels.
If you don't hit the update all labels,
you get one label on this entire sheet labels and that's it.
You must hit this the replicated labels, MUST HIT UPDATE LABELS, click.
Here we go, and now every label has next record, address block,
go to the next record, address block, this is great.
Now, I'm going to hit Next again and preview my labels.
Well, that looks fine to me.
I think that looks perfect.
I have the option, I can save this right now,
which I would do, or I can print this right now.
Next, it says, right at the bottom, complete the merge.
Click, and here we have print or edit individual.
I would never, send a sheet of labels to the printer without first previewing it,
too many things can go wrong.
So I absolutely hit edit individual labels, and
all of them and now I have my true document, okay?
The one up here, the previous one was my records,
just kinda the template but this is my brand new document.
Now, if I wanna adjust how those look cause they look terrible,
I'm gonna select all, with Ctrl+A, select all.
Go to my Home ribbon, fix my paragraph alignment by removing the space.
I can tell you it's too close to that margin.
So I'm gonna push this over about a quarter of an inch using that index
selector on my ruler and that look pretty good, I'm okay to hit Print.
This is quite a process, don't be afraid of it,
go through this video a couple of times.
This is such a valuable tool that it has been forgotten but I still use it all
the time, so I just want to tell you it's not as hard as it looks.
You just need practice at a few time, all right?
Thank you.