How to Mail Merge in Word, Excel & Outlook
How to Mail Merge in Word, Excel & Outlook
Learn how to Mail Merge with Microsoft 365, Office 2021, Office 2019, Office 2016, Office 2013, or Office 2010. Mail Merge allows you to send customized envelopes, letters, and emails. Mail Merge leverages Microsoft Word, Excel, and Outlook.
📚 RESOURCES
- Mail Merge with Attachments, Custom Subjects, CC / BCC others, or set the default email address: • How to Mail Merge with Attachments, C…
- Mail Merge for free using WPS Office: • How to Mail Merge in WPS Office
- Get Microsoft 365: https://bit.ly/3CUmtZw
📺 RELATED VIDEOS
- Videos on Microsoft Outlook: • 📨 How to use Outlook
📩 NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: https://kevinstratvert.com/newsletter/
🔽 CONNECT WITH ME
- Official web site: http://www.kevinstratvert.com
- LinkedIn: https://www.linkedin.com/in/kevinstra…
- Discord: https://discord.gg/kHuujY2pZf
- Twitter: https://twitter.com/kevstrat
- Facebook: https://www.facebook.com/Kevin-Stratv…
- TikTok: https://www.tiktok.com/@kevinstratvert
- Instagram: https://www.instagram.com/kevinstratv…
🎒 MY COURSES
- Excel for Beginners in under 2 hours: https://kevinstratvert.thinkific.com/
🙏 REQUEST VIDEOS
https://forms.gle/BDrTNUoxheEoMLGt5
🔔 SUBSCRIBE ON YOUTUBE
https://www.youtube.com/user/kevlers?…
🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: https://amzn.to/3kCP2yz
⚖ DISCLOSURE
Some links are affiliate links. Purchasing through these links gives me a small commission to support videos on this channel. The price to you is the same.
#stratvert
Content
0.32 -> Hi everyone, my name is Kevin,
1.68 -> and today I'm going to show you how to do
mail merge using Word, Excel, and Outlook.
7.68 -> So, first off, what is mail merge?
9.28 -> Well, think of it as when the electric
company sends you a bill every month.
12.4 -> They customize your bill with your
name, your address information.
16.08 -> I'm going to show you how to
do something similar to that.
18.72 -> Let's say you want to send out envelopes.
20.32 -> Let's say you want to send out a letter or
maybe you want to send out an e-mail and each
24.16 -> individual one has custom information
that you want to include on there.
27.84 -> That's what we can do with mail
merge, so let's jump right on into.
31.92 -> And as we're getting started here, just
as full disclosure, I work at Microsoft.
35.6 -> OK, so what I'm going to do first is
I'm going to open up Microsoft Word.
40 -> So, we're going to pop up Word here, and then
I'm going to open up a new blank document.
44.08 -> So here I am in my new blank document,
46.48 -> and what we're going to do is
we're going to click on mailings.
49.52 -> Now one thing to say is this. What I'm
using right now this is Office 365.
54.56 -> Chances are it'll also work
on 2019, 2016, 2013, 2010.
59.36 -> I don't think mail merge functionality has
changed that much, but just as a caveat,
62.96 -> this is using the latest version
of Office. This is Office 365.
66.96 -> So, I'm going to click on mailings and the first
68.48 -> thing I'm going to do is there's a little
button there that says start mail merge.
72.32 -> I'm going to go ahead and click on that and today
what we're going to do is we're going to create an
75.68 -> e-mail message that I'm going to use to
customize the user information in there.
80.08 -> You could also create things
like letters, envelopes, labels,
83.2 -> directory information, but we're going to do
an e-mail today. The process that you follow,
87.44 -> and all these other ones is very
similar to doing an e-mail message.
90.32 -> So, I'm going to click on that and like I
said before, I'm going to be sending out
94.08 -> a billing notification, so I get
to collect money from people, so
97.92 -> we're going to say hello and I want to
customize this. So what I want to do is
102.48 -> I need to select information. Now let me
pull my Word document over and here on
106.8 -> my desktop I have a sheet called customer
information, so I'm going to pull that up.
111.44 -> This is a spreadsheet that I created ahead of
time, and it has four different columns. It has
116.48 -> the first name of people, it also
has the plan name that someone is on,
120.48 -> it has the due date for the bill,
and it also has the e-mail address.
124.32 -> I just use the same e-mail address
on each one and so I want to use
127.68 -> this information from this list
in the mail merge that I'm doing.
131.44 -> So, we're going to start out here by saying hello
and what I'm going to do now is I want to connect
136 -> this spreadsheet to this Word document, so
I'm going to click on select recipients.
140.64 -> I could create a new list, I can
choose from Outlook contacts,
143.12 -> but I have this spreadsheet, so I'm
going to click on use an existing list.
147.68 -> And now what I can do is it opens up the file
picker and I'm going to click on my desktop
152.4 -> because that's where I have this file stored
titled Customer information. I'm going to click
156.16 -> on that and now what it's asking me to do is it
wants me to select a table, and so you'll see
160.88 -> in my Excel sheet I have a table, or
a sheet called customer information.
165.04 -> So, I'm going to go with that,
166.16 -> and then you see this checkbox that says the
first row of data contains column headers.
171.04 -> At the very top of my sheet, you'll see that
I have my column header here with first name,
175.28 -> plan due date, so I'm going to leave that
checked, and we're going to click on OK.
178.72 -> And so now what it's done is
it's connected this spreadsheet
181.68 -> with this Word document that I'm creating.
184.24 -> So here I'm going to say hello and now what
I could do is there's another option here
189.84 -> that says insert merge field.
192.4 -> I'm going to click on that and when I click on
the drop down, you'll notice that I have these
196.32 -> different columns, and these columns
line up with the Excel spreadsheet.
199.76 -> So, I have first name which lines up with
first name, plan, due date, and e-mail.
204 -> So, I'll say hello and I want
to say hello to the first name.
206.4 -> So, I'll click on first name and then
you'll see this little you'll see
210 -> the text there that's the first thing,
and that's a placeholder for the name,
213.44 -> so I'm going to put in a comma and
I'm going to say your, let's say your,
219.76 -> and I'm going to put the plan name in, so we’ll
say your so it'll say starter or platinum.
224.08 -> Your starter package is due on, and
then we want to insert the due date.
228.88 -> So, I'm going to insert another field
and I'm going to insert due date,
231.6 -> and so you notice it puts another placeholder
in, it says your let's say starter package is
236 -> due on such and such a date, and then
I'll say, please submit your payments
243.36 -> to 123 Main St. and we're going to say this is
in Seattle, WA and I'll put down the ZIP code.
250.8 -> Thank you.
251.6 -> Let's say thank you and then we're
going to call this the billing company.
257.52 -> OK, so what I've done now is let's
test this out and see how this works.
262.4 -> So, they have this option here
that says preview results.
264.96 -> So, I'm going to click on that,
266.16 -> and so now you'll see it's inserted
the first row from my spreadsheet.
269.44 -> So, I have this, John. He's on the starter plan
and it's due on 3/15. So here it says hello John,
274.16 -> your starter package is due on 3/15/2019.
277.2 -> Please submit your payment to this
address. Thank you, the billing company.
280.8 -> Now what I can do is I can click through this
little arrow and that goes to the next record.
284.4 -> So here it'll jump to Kerry
and then it jumps to Kevin.
287.28 -> That's me, so I'm charging myself, and
here you'll see that the package changes,
292.64 -> the date modifies, so here, Kevin, that
lines up with this row here. So, Kevin,
296.56 -> on the starter package, here you see starter,
and that's due on 3/18, and you see 3/18.
301.52 -> OK, so now I've set it up so
that the message is customized.
304.56 -> It's using information from my list in the sheet.
307.84 -> Now that we've done that, now I want
to go ahead and send an e-mail out.
310.72 -> So how do we do that?
311.68 -> Well, I'm going to get rid of the preview
here, so it goes back to the template
315.28 -> and then there's a button
that says finish and merge.
318.4 -> What I'm going to click on here is you could
print documents or I can send e-mail messages.
322.88 -> Today I want to send an e-mail, so I'm
going to click on send e-mail messages,
326.48 -> so it says to e-mail, and so what this
is doing is it's using the column e-mail.
331.36 -> You can choose any one of the columns,
332.64 -> but it automatically detected that this is
an e-mail address, so it chooses that column,
336.8 -> and I'm going to say for this subject, I'll
say your bill is due, and then what you could
342.32 -> do is it says send to all records, current
record, or I could set specific rows that I
347.12 -> want to send it to. So, let's say that I only
want to send bills, say, a month in advance.
350.96 -> I could choose, hey, I just want to do, you know,
352.96 -> let's say row five and six, and
I just wanted to send it to them.
355.84 -> But in this case, I'll send it to, I'll
send it to everyone and then I click OK.
362.32 -> So now what's happening is it's going
ahead and it's generating emails.
366.24 -> So now what I'm going to do is
I'm going to open up Outlook.
369.92 -> So, I'm in Outlook here and you'll see
372.96 -> I have my outbox and it says your bill is due,
your bill is due, and each one is customized
377.6 -> to the person that I had in the list, and
then what I could do is I'm just going to
381.76 -> make sure I click on send and receive, and now
it's going to send each one of those emails.
386.16 -> So, there you have it.
386.96 -> It's sent out a bill to
these five different people,
389.92 -> and hopefully they submit their payment on time,
but that's really that's as easy as mail merge is.
395.92 -> You can take a list, you have a Word document,
you could insert information from that list.
401.04 -> You could define who you want to send it out to,
403.76 -> and then you could send out a bulk number
of whether it's emails or whether it's,
407.68 -> let's say a letter and envelopes, and
customize the information on there.
412.32 -> So hopefully this information was helpful.
414.16 -> Hopefully you found this
tutorial, tutorial valuable,
417.92 -> and hopefully that'll take
care of your mail merge needs.
420.96 -> If you enjoyed this video, please subscribe.
422.88 -> That way you'll see future videos like this, and
if you enjoyed it, please give it a thumbs up.
427.12 -> That way it helps boost my confidence
that people are taking these videos and
432.48 -> using them for something good. OK. Well,
thanks a lot everyone. See you next time.
Source: https://www.youtube.com/watch?v=_Efb_oMgxEs