How to Create LETTERS in Microsoft Word Using Mail Merge | Use List From Microsoft Excel

Although a lot of writing is done over email these days, it’s still common to need to write old-fashioned letters in bulk. Microsoft Word makes this easy to do, using a mail merge that pulls address information from Microsoft Excel.

In a hands-on tutorial, I’ll show you how to set up a mail merge template in Microsoft Word, set up address information in Excel, and then how to merge them together into a new document.

00:00 – Overviewing the letter and Excel workbook
00:42 – Starting the mail merge and selecting recipient list from Excel
02:06 – Inserting mail merge fields
02:56 – Previewing mail merge data
03:48 – Finishing the mail merge to a new document

[TinyTechnicalTutorials]

What else do you want to learn about Word and/or Excel? Let me know below in the comments!

[mfj]

For myself studying, this was INCREDIBLY helpful and amazingly timed. You got straight to the point and saved me HOURS of learning. Thank you so much!!

[oikwuie]

Thanks for your simple, straightforward explanations. I struggled with trying to plow through Microsoft's support pages and never got to the end result. You explained some of the hidden/implicit assumptions that they did not even mention . And that made all the difference for me, thanks again!!

[HARAMAINTRAVELTOURS]

thankkk youuu so muchh
you saved my times

[WeirdInOmaha]

You have saved my life twice now! I really like your short and easy tutorials!

[ditihalommusi]

This saved me hours of Letter writing, Thank you soo much for sharing

[alexekato]

Excellent, simple and understandable! Thank you!

[utaathleticssaac]

Thank you!!! You made it easy to follow and you save me a lot of time!!!!

[Pradeepnalluri]

to the point... no bla bla. Nice presentation

[SwimFanMadison]

This is fantastic!

Curious is there a way to get the mail merge to iterate one page of the doc and merge them all into one new document?

For example, if I was creating a catalog and had a cover page, then the second page would be a page with my mail merge fields that I want to change with each row of excel data.
So when I do the mail merge the new document is NOT in the form of:
(cover page, mail merge content page, cover page, mail merge content page, cover page, mail merge content page)
but rather
(cover page, mail merge content page, mail merge content page, mail merge content page)?

[SalmanTariq-pdow]

Thanks you so much to explain in very easy way

[sadeqadnan]

Many thanks
Really appreciate you for this valuable information

[stevenstevens]

Simple and clear, I really love your content

[everyoneyou]

Hello, is it possible to use two listes, one from Excel and the other from Word ? thank you.

[lauracannioto]

After completing the merge, I need to save the main doc. for future use. How would I do that?

[jurgens]

That was very informative, Thanks a lot! 😊

[endex]

It works Thank you!! 97 letters in one format

[gabbyr]

Is there away to do the mail merge but save each letter individually instead of as one giant document?

[diannariley]

Do you have a video on how to do a Mail merge with labels using the excel spreadsheet? If so, can you link it?

[rolandabanimunason]

Many thanks for your training. However, how do I include messages on the body of the mail, also in a PDF

It will be funny to send an official letter with just an attachment without messages on body of the mail.

Please how I can use mail merge to solve this problem.

A video would be appreciated. Many thanks