How to Create Mailing Labels in Word From an Excel List

In this video, I show you how to create mailing labels in Word from an Excel list with the option to format parts of the address, such as making the name bold or a larger font. I've also detailed the steps below:
-Format your addresses in Excel including column headers at the top of each column of data (i.e. first name, last name, company, address, etc) and ensure zip codes are formatted correctly so if they start with a 0, the 0 is not dropped off
-Open a blank Word document
-Click on the Mailings tab - Start Mail Merge - Labels
-Select your label vendor (i.e. Avery US Letter) then product number (i.e. 5160 address labels)
-Click on OK. You should now see an empty table in your document.
-From the Mailings tab, click on Select Recipients and select "Use an existing list"
-Select your Excel file of addresses and click on OK. Your document should now be blank in the top left cell and display «Next Record» in the rest. Click in the top left of blank cell if your cursor isn't already there.
-From the Mailings tab, click on the arrow under Insert Merge Field and add contents exactly how you want it to appear on your labels, adding spaces between first and last name and carriage returns to align the address and any other information correctly - you can always update this if it doesn't display correctly on your first try
-You can now format the contents, such as making the customer or company name bold by highlighting those fields and formatting the text with the options on the Home tab.
-Once you've formatted the fields in the first cell, go back to the Mailings tab and click on Update Labels. The contents may look a little strange at first, but you can see how they will appear by clicking on preview results. Click on preview results again to go back into edit mode. If you need to make adjustments, make them on that first label again, then click on update labels again.
-When you've perfected your labels, I like to view them one more time, so I click on Finish & Merge - Edit Individual Documents, select all and click OK. This will open the finished labels in a new document, enabling me to view every label to ensure text isn't wrapping to the point where an address won't get printed correctly. If more edits need to be made, just go back to the original Word doc, make your updates and repeat.
-Once perfect, you can now print your labels!
Don't forget to subscribe to my channel for more tutorials!
Check out my website at simplesoftwaretutorials.com
Video recorded using Screencast-O-Matic (www.screencast-o-matic.com)
Thanks for tuning in!

[@starman70]

Wow! Fantastic tutorial. That's exactly what I needed, thank you.

[@not_kaija889]

This is the most helpful video I've ever watched. Thank you, I hate making labels and this took the frustration out of it! Love the step by step with visuals!

[@cedricholt9347]

A very well put together and straight forward illustration of making labels. Like many KZbin videos the delivery was a little too quick but at least we can always go back to repeat. An excellent and clear video.

[@martygrieve795]

Great video. I rarely do labels but this made it so easy to remember how best to do labels. You also showed a couple of new tricks I did not realize you could do. Great job.

[@freshbeatsocial3539]

This rocked! You explained it so well and all went smoothly despite my stress about this kind of stuff! Thank you!!!

[@jenniferbrunette4406]

I used to have to take a Xanax before doing my annual huge mail merge for work purposes, it was that stressful. Now I just go to this video, watch as a refresher, and get to it. THANK YOU.

[@susanmeek9712]

You saved Christmas! I used to have address labels 5+ years ago. My then-new computer used a different version of Excel, and I guess I was too lazy to figure it out. Deciding that this year I was going to change things (namely a very sore hand from hand-addressing those Christmas cards), I discovered your tutorial and it was perfect. Your voice is clear and your terminology is easy to follow. My cards may arrive late, but it's so much better than never arriving at all. Thank you!

[@mktbooks1082]

This video was absolutely excellent. Your teaching style is wonderful. I needed to update an old file of Christmas card labels and I found your KZbin just in time. I'm using a newer version of Word since the last time I created labels and there was no way I would have figured this out. I particularly liked your clear explanations, the many options you provided, and that you demonstrated how to go back and correct problems. Thank you, Thank you, Thank you! 👍👍👍👍👍

[@edwinpaz9880]

The best one I have found yet on this, short and accurate much appreciated.

[@dayanariano9562]

this video literally saved my life at work. not too long, very visual and just clear enough to make my job easier. save amounts of time. Thanks a lot

[@Bonnster51]

I spent (literally) hours yesterday trying to make labels from an excel file by following written instructions. I was so frustrated. You showed me exactly what to look for in each step. Wow! Thank you SO much.

[@SanAndCo]

Thank you so much for your calm voice and excellent teaching pace!

[@bgiammona]

Hurray! Well done. I do this every year and have always looked at the Microsoft instructions. I would never get it right! This was SOOOO much better. Thank you!

[@denisestump7163]

Thank you for such an easy and thorough explanation. If only every video would be this easy to follow. Thank you!

[@joannsilvia9712]

Great Instructions! Thanks for an easy to follow tutorial. Edwin Paz is correct. This is the best I've found also.

[@sfdvr2]

Could not have done it without You.... So grateful.

[@consciouspuppets-puppetthe4315]

you are the only one so far that said to "update labels" which was the key important piece for me, thank you!!!

[@marlenedevlin6329]

Excellent job!! So helpful and easy to follow! Thank you...I've been looking for you for a very long time!! MS needs to include your tutorials in their "help" catalog!

[@suealexander8247]

Thanks for explaining it in such detail. I’ve been retired for 10 years and we forget how to use these features on our computer. LOL Thanks again!

[@stopdrinkingleftskoolaid6510]

I was looking for a video to simplify this procedure and I cannot believe how simple you made it. I liked and subscribed to your channel based on the simplicity of your teaching demeanor . Well done!

[@mariannependleton61]

What an amazing tutorial! Beautifully done!

[@anntozier7614]

FANTASTIC video!!! I have "winged it" for years and struggled to smoothly create my labels. Your video showed me the error of my ways. Thank you so much!

[@chriswhalen8684]

Excellent!!! I have been trying figure out how to print labels from excel to WORD for a time sensitive mailing. THANK YOU for a clear, accurate video.

[@junemariebrandt1825]

Thank you. I have struggled with this for a month! So much easier than written instructions.

[@debrameeks8243]

Thanks so very much, I am treasurer for our HOA, so I only need this once a year for billing invoice labels. Perfect, visual and just great!

[@aucarter]

Thank you for these instructions!

[@natalieortiz3483]

thank you so much! very easy to follow, I will be saving this for the future!!

[@moidelcastillo3313]

Thank you so much for helping me, I was doing everything fine Except the Preview. Thank you a lot Teacher. New follower.

[@normamaynard78]

Thank you so much for this concise video - you have saved my life at work and I've even shared with other Admin colleagues! Truly appreciate it!

[@dianeborries1261]

Thank you for the brief but comprehensive step-by-step!

[@sunyatasunyata3137]

A brilliant video and so helpful. Saved my life.

[@DePersuader]

Perfect video, I had to watch about 5 videos before I came across yours. by far the best I could find thank you

[@debragallaway6982]

Wonderful! Thank you SO much! I had no idea how to do this and would have spent hours trying to figure it out from Word!

[@ronaldcoia6064]

This is excellent work. Clear and specific on each step.

[@beverlylitfield1142]

Great instructions! Very easy to follow. Thanks so much! I completed my task early.

[@daniellejbowen]

Great step by step directions! Thank you!

[@janbooth9813]

This was fantastic! I have tried before without success, but you walked me through it! Thank you!!!

[@lycolovelies]

Thank you so VERY much for these very helpful and clear instructions! You're the best!

[@user-dz9rt4cs6d]

This was so easy to follow. Thank you so much

[@lauraescalante7450]

So easy to follow, and thanks for the tips on getting excel document ready for merging. The only issue i had was my top label on each page cutoff the company name, I have the correct label selected, so not sure what happened. Thanks again!

[@mindiegoodrich4963]

SUPER easy to follow tutorial! Thank you!!!

[@lindajordan5481]

THANK you so much! Great step by step, saved me today!

[@ruthgoodman5507]

Super helpful and easy to understand. And it's brief!!!

[@jackvoigt6052]

Straight and to the point. Thanks.

[@terrealford7868]

Best video for learning a new excel skill I have seen. She was thorough and easy to follow.

[@mveteclemence1080]

Great video. Very concise and easy to follow! Thank you again.

[@andrijas72]

Very good tutorial, precise and concise at the same time.

[@kristymiceli5692]

Thank you! This is the best video I've found and I finally was able to create labels.

[@johnwilloughby6328]

Excellent tutorial - thanks!

[@corkyking0301]

You made me look like a genius! Easy and very professional. THANK YOU!

[@shaunslaughter2646]

This was perfect and made making my labels easy and repeatable. Thanks for the video.

[@homegoalswithjanice]

Holy cow, this is the 5TH video I've watched on this and I FINALLY got it. THANK YOU! You did an excellent job of explaining this. I never leave comments on videos but here I am! Thanks again and happy holidays!

[@cathleenrenner9878]

Very easy to follow. Really appreciate this. Thank you!

[@rosalierollins1975]

Thank you. Thank you And Thank you. I was going crazy trying to deal with this issue. I watched some guy try to do it.I read how to do it. I just tried to use the program. You were awesome.

[@maliksikander4760]

Very helpful and clear. Thank you!

[@anniemurray5174]

Thank you so much! Very helpful! I knew there was a way to do this. WAY back when before they changed everything like late 90's early 00' I had this down...now I swear I have to look it up every time.

[@debigoulding9089]

Excellent video! its been years ok a decade or 2 since I have done a mail merge. this was simple and very effective! Well done!

[@georgesitts1557]

Thank you a second time.... I used your tutorial last year, forgot how, so found you again!

[@tjbranbran]

Thank you so Much! This was Perfect and Easy to follow!

[@user-dw5so5ls1x]

I watched 3 other videos before finding this one. It's exactly what I needed! Thank you!

[@yuki8607]

Thank you! It is really helpful.

[@kittytuberty271]

This was very helpful!!! Thank you so much!!!

[@markmercnut]

Phenomenal video, clear and concise, thank you

[@kev64037]

I knew there was a way… and your video cleared it up for me. Thanks for your clear and easy explanation!

[@janegilbert1409]

Awesome. Worked perfectly. Thanks!!

[@averyshrider3091]

So easy to follow. Great job and thank you so much!

[@rosshart9035]

You ROCK! Thank you for this wonderful tutorial.

[@georgiagiannini3530]

Super helpful and quick! Love it

[@user-uw6qy8ii8x]

Thanks for the video instructions!

[@cristidasilva9471]

You are amazing! This was so helpful, I am hugging my screen! You are easy to follow and you have "great voice". I am your devoted student!

[@allisonronis9364]

saved my life here thank you

[@heatherwitt9595]

Really great tutorial! Thank you so much!

[@robertkeeler5736]

Thanks. Very helpful and easy to follow.

[@user-fy4yd9tz4w]

Your video was spot on. I had done this before and I needed a refresher. As soon as I heard your voice and teaching style, I knew your channel was for me. I am going to subscribe and I look forward to viewing more videos. Many thanks.

[@ChrisLaVictoireMahai]

So so very helpful. Thank you so much!

[@Ben-sp5it]

Super helpful! Thank you!

[@michaelold7357]

Well done! Very clear explanation and process!

[@MelaniKodikian]

This was extremely helpful and very easy to follow. Thank you!!!

[@mgninfo8416]

Very clear and helpful

[@annettebromley9190]

Great job explaining!

[@alexandria_g]

Thank you so much! Very helpful video

[@shirleybradley8423]

This was so helpful, Thank you so much!

[@goodfoodfastwithstephanie]

This was super helpful! Thank you so much!

[@coreypospisil616]

This was spot on to what I needed, thank you.

[@homesfund9319]

Awesome tutorial....exactly what I needed!!

[@Sarah-pc5wj]

This was so helpful!! I am at a very nerdy level of excitement. Thank you!

[@emilysmith9238]

Very helpful! Thank you!

[@wempy1452]

excellent tutorials... thank you so much....

[@dhapumdhap]

Love it! Awesome tutorial. Thank you so, so much.

[@MichelleCasey-vn3mb]

So very helpful!!!!! Thank you!

[@cathygaertner9582]

Thank you I was having a christmas card label melt down.. you saved Christmas !! Thank you Thank you

[@lisawilliamsen2888]

Excellent tutorial!

[@danagrace1091]

Great Video, Very Helpful, Thank You!

[@markbreaux4564]

Great job! Thank you!

[@brendalott5445]

I love this! I use this every year because I never remember how to to this.

[@debrawallace970]

EXCELLENT! Thank you so much! This is exactly what I needed.

[@bryanapper6687]

Very helpful! Thanks!!

[@margiestinson3638]

soooo helpful! Thanks so much!

[@TheKarntner]

Well done - Thank you!!

[@evekimball6301]

Thank you - wish I had found you two hours and 4 other instructions ago!!!! Eve