How to Create LABELS in Microsoft Word Using Mail Merge | Use Data From Microsoft Excel

Whether you’re mailing holiday cards or sending invitations to a wedding, you need a way to easily create mailing labels. Microsoft Word makes this easy to do, using a mail merge that pulls address information from Microsoft Excel.

In a hands-on demo, I’ll show you how to:
00:00 – Video intro
00:12 – Set up address information in Microsoft Excel
00:49 – Find a mailing label (using Avery 5160 as an example)
01:13 – Create a new label template in Word
02:23 – Select recipient information, pointing to addresses in Excel
03:36 – Insert merge fields
05:10 – Complete the mail merge

[ChaseAHansen]

When inserting merge fields, you can fill in the first field, then click Update Labels, and it will populate all of the other cells so that you do not need to copy paste the rest.

[jessicamcclanahan]

Fantastic Job! You gave just enough information without it being convoluted. I was able to follow along and figure it out while using a different version of MW. Thank you!

[bugaboo]

By far the best instructional video to get me from an excel list to printed labels...and I didn't waste any sheets of labels!

[ggrossman]

Two years ago I asked how to associate my Word label file with my updated Excel data set and you provided wonderful instructions. They worked again this year!! THANK YOU

[zeda]

What an amazing video, Thank you Tiny :) I was struggling for the past week how to label mail merge! My only mistake was not choosing the right label vendor. Your video helped immensely. Thank you :)

[laurellynn]

I love your calm voice when teaching. I am about to do peel off type shipping labels by Avery an do team badges for kids day at my job and this is the best refresher…. Stay near as I may need you !!!! Thanks

[mbz]

Oh geez! Finally a straightforward, exact tutorial. Huge thanks!! Old dog learns new trick!!😁

[richardthomson]

This worked perfectly and your instructions were GREAT - Thank you!!

[dmancina]

Thank you. I watched two confusing videos on this topic and yours was clear, accurate, made sense, and worked. Thank you!

[yomar]

Thank you so much! This is the best tutorial. I finally did it with this video of yours after trying many times. I got stuck on the label type but after I saw this, finally did it!

[carlachirigos]

Thank you so much for this excellent tutorial. I would have never figured it out without your step-by-step instruction and demonstration. I do have a Mac and though I was apprehensive your instruction would work, it did! I downloaded the Microsoft template from Avery and opened it in Word and did the merge from my Excel file.

[chandracarrington]

Thank you so very much for making a very easy video to follow. I appreciate you so much!

[rockymajic]

I watched 2-3 videos before this one and could not get it to work. This video finally helped me get there. Thank you.

[adricontreras]

This has helped me so much. Thank you!!!!

[craigemilycurrier]

super quick and helpful, just what I neeed!

[lilitbabayan]

Thanks a lot!! Very detailed explanation.

[TinyTechnicalTutorials]

What other Word features do you want to learn about? Comment below!

[judyholmes]

Wonderful clarity of explanation and nicely paced. Thank you.

[MariaGarcia-eche]

Awesome! Thank you. I had to watch many tutorials before I got to yours. Yours is the only one that made sense! You just made my life a whole lot easier. :) Also, I like your voice, you sound like Jan Levinson from the office.

[TM-edhz]

one of the best online tutorials i've seen. very well done, clear and to the point. i am sending out a mailing for a regional disabled veterans group and our address has up to 5 lines. Would you please share what do I need to do in the setup to accommodate 5 lines with avery 5160 labels.