How to Mail Merge Address Labels - Office 365

Learn how to Mail Merge to create address labels using Microsoft Word and Excel. Quickly take a spreadsheet with contacts and create an address label sheet with ease. No need to paste individual names and addresses into an address label sheet.
Mail Merge allows you to send customized envelopes, letters, and emails. Mail Merge leverages Microsoft Word and Excel.
Don't have Microsoft Office? Mail Merge for free using WPS Office: • How to Mail Merge in W...
As full disclosure, I work at Microsoft.

[@tpmarkham]

Every Christmas I create labels for Christmas cards and every year I am on KZbin getting a refresher. Great simplistic presentation. Thank you.

[@ReubenLujan]

Great tutorial! Everything was explained perfectly and was easy to follow. I'm processing a 1,000 letter project today and am being sent the addresses in Excel. Thank you so much for taking the time to do this video!

[@benl8349]

Excellent presentation. Very clear, economical with words, straight to the point. One of the best tutorials I've seen. Thanks

[@edithgarza2581]

This was a great tutorial!!! Thank you for not over talking and being clear and efficient with your communication.

[@wdwbsu1]

I had not done a mail merge in years and could not remember how to do one. I found this video and I was able to follow along and get it done. Thank you for posting this. You made the whole process simple. I will be looking up your channel when I need more Office help.

[@agongos9]

THANK YOU!! I followed you step by step, and was finally able to print out my address labels. You were very clear in your instructions.

[@cindyhomans5419]

I was in a panic and your video was just what I needed. Very clear explanation and I was successful in creating labels for our organization. THANK YOU!

[@holtongr]

My wife was in a pinch with printing labels for Holiday cards and this video saved so much time for us. Thank you!

[@tonyanderson8662]

Thanks for the refresher, I haven't done this in thirteen years, I used to use mail merge daily.

[@jchris1451]

You just saved my non-profit group so much money as now I know how to mail merge for our mailings! TY!! Clear, concise, and helpful teaching and presentation.

[@brucehilger95]

Thank you. I tried mail merge four times, then followed your tutorial step by step and it worked the first time.

[@jackprice7828]

Kevin I know you made this video some time back, but it recently came in very handy for helping me create mail labels for a wedding and the invitations. I much prefer using Excel for creating data for obvious reasons and this worked great.

[@denisemmonaghan7280]

Great video and easy to follow. Created labels so much faster than I was doing by copy and pasting to label template. Thank you very much!

[@Burrito327]

This was so great. I needed to try to figure out exactly what you were talking about, and I've been researching for hours. So Simple and easy to follow you. Thank you so much.

[@johndeeley5734]

VERY WELL DONE!-I HAVE USED THIS VIDEO SEVERAL TIMES OVER THE PAST THREE YEARS TO DO LABELS. THANKS JOHN

[@kadeanaroland587]

Hi Kevin, This was way more helpful than the other 3 videos I watched. I used to used this years ago but you snooze you lose. I am always soooo grateful for your videos. The other day I was trying to learn about SEO and I was thinking "where the Heck is Kevin????" Anyway, you are awesome and helping this 50 year old stay in the game!

[@user-oy7tc8zp5w]

Thank you ever so much for the fully detailed procedure. I have worked all day trying to get the mailing labels to convert to labels. I was using the help from the software and there was just one step that it did not include. Now that I know the steps....mission accomplished.

[@danrusin4757]

Kevin, super tutorial! I used your teaching on this Sunday morning to make a mailing list for my scouting group. This is very helpful!

[@joycek3413]

Thank you so much. I used to do MM docs all the time, I couldn't figure out why I was getting just one label autofilled and not the others, thank you for pointing out that I needed to "update all labels". Thanks again.

[@hippocrates12]

For instructional videos you are definitely at the top of your profession. You have a KISS approach but with the sophistication to raise the bar when necessary. Your pacing is spot on. As a starting point for Windows related tasks, and many others, you should be the first stop..

[@PhilTParker]

Terrific tutorial. I jumped right in, followed your steps and Voila! A perfect merge, ready for printing. Thank you!!!

[@mccyclist2351]

By far THE BEST VIDEO ever on mail merge. Thank you for the wonderful and easy to understand presentation!!!!!

[@sarafilley7697]

Excellent THANK YOU!! I followed you step by step, and was finally able to print out my address labels. You were very clear in your instructions.

[@edwardkosciuk4341]

Great video! I struggle printing Christmas card labels every year, and this makes it simple. Thank you!

[@kimbersev8327]

This is EXACTLY what I was looking for and with a clear and easy to understand explanation! Thank you!!

[@marylmiller2787]

I agree wholeheartedly!

[@janwestberg6667]

You were so helpful & thorough. Even though I had a different version of Word, I was still able to get it done!!! Thanks so much!

[@mariannegoldberg5432]

Thank you. I don't make labels often so every time is like a first time! This was clear and I followed you step by step, stopping the video and doing the same step in Word. I am looking forward to Windows 11 which should require less back and forth!

[@kimberlyd4971]

Thank you so much for this video. It's been years since I had to do a mail merge. LIFE SAVER!!!

[@homecats1]

Well done. Took all of the uncertainty out of making label mail merge.

[@PlatypusesEatPeople]

This is amazing. You saved me hours of copy-pasting labels

[@RandyBridgesRealtor]

Came back for more. This time I typed a step-by-step instruction from you video. I'm glad it was still up. Thanks again.

[@mercedescedeno2141]

Loved your clearness in explaining and I was truly satisfied.

[@andisavage5298]

Thank you! I was stuck on a step and couldn't figure out why my merge wasn't working. This helped a lot!

[@AJBernard]

Thank you for this!! I really appreciate it! Our church will be sending out its first Newsletter in over 2 years thanks to your help!

[@tilsonanth0ny]

Super helpful, helping someone at work make labels for holiday cards. Thank you

[@locs247]

You're a life saver and thank God MS doesn't change much over the years.

[@dawnseigel2636]

Great tutorial - very much appreciated! Mail merge has always been scary like a root canal but you made this extremely easy. Thank you!

[@justyna6134]

so helpful, I found the answer to my question in your tuto - how to print all in one go ;) merci Kev !

[@kagseniorrod7435]

Well done.....forwarded to a friend who was struggling with creating mailing labels.....THANKS

[@RandyD1972]

This is a good demonstration video. I haven't done a mail merge yet but hope to do so with the help of this video.

[@jaynejones3138]

Thank you for your clear and straight forward instructions.

[@Globemaster742]

Thank you for this lesson. Simple, clear and easy to follow for my project.

[@lolindamosley1920]

Thank you, it has been a while since I've done this.

[@genieinabottleofrum]

Thanks ,excellent tutorial for making personal mailings look professional.

[@carlyj392]

This was extremely helpful!!! Not overwhelming and quick to the point. Thank you so much for posting!!!

[@RandyBridgesRealtor]

Have you tried using these instructions for merging postcards? I cant seem to get mine to work.

[@kpdoyle4]

Thanks so much...very clearly explained and helpful!

[@charlesbryan3005]

Thanks very much for this tutorial. It really helped me with my Christmas card mailing labels.

[@LauraParvanian-np1dc]

Wow! So helpful! Your step by step saved me hours of trying to figure this out or retype into word. THANK YOU!

[@debrakoch320]

Wish I had your knowledge of computers, another helpful video, thanks 👍🏼

[@davidalanlunde]

Thanks. I use this for Christmas card labels once a year and never remember how I did it. Don't go away...ever.

[@marshascreativity4unailswr210]

Thank you so much. This looks so easy. I need to do this for wedding labels

[@randydaniel8494]

This enabled me to get my Christmas card list printed once again! Thank God for KZbin, and I mean that literally.

[@cp-cw6nw]

This was so helpful! Saved me a lot of work! Thank you

[@vanessavarnado7448]

Thank you, Your instructions were very clear.

[@josephineochoa4722]

This is the best tutorial! Saved me hours at my job !!

[@RandyBridgesRealtor]

Outstanding! I've been working on this for several days on my own reading Word. Thank you for putting this video together!!😀😀.

[@unclebillcarter240]

I forgot how to do it and this video made it so simple. Thanks

[@_em_1]

This was great! Easy to follow along. Thanks!

[@pabloarmandoramirez8911]

Thank you very much for sharing your skills, Kevin! God bless you!

[@bargeld09]

Thank you. That was easy way better than trying to copy and paste all those addresses.

[@user-kn8td1wh8c]

Thanks again, I would have spent all day trying to figure this out.

[@callmeab917]

Amazing! couldn't be clearer! Thank you!

[@samanthalawton542]

Thank you! This is exactly what I was looking for.

[@lemonademagnum2134]

You just helped me in my assignment, thank you very much! This video helped me a lot.

[@1krista1969]

This was a big help! Thank you, Kevin!!!

[@letmebeyourmirrorglam]

Thank you so much I was at work trying to figure this out for an hour 🤦🏻‍♀️

[@mukundsetlur3141]

You made it so easy for us, thank you veery much!

[@colonelmann]

I was frustrated until I found this video,Thank You!

[@Robert5005g]

Great tutorial, easy to hear and understand.

[@alisad.811]

Thank you for saving my job! I might be able to slide through for a few more weeks. LOL

[@jjoli07]

had to do this for my computer science class great vid thx!!!

[@antoinetterembert9327]

Excellent I was able to make my labels with ease with Kevin’s step by step. Thanks.

[@KevinStratvert]

Glad it helped!

[@normaolivier6407]

Hi Kevin, your video was very helpful. I would like to see an excel video on how to calculate using the function keys.

[@kerrahaynes6830]

Awesome...I've been pulling my hair out trying to figure this out! Thank you

[@cherylveale7421]

Thank so much for this tutorial. It was very helpful.

[@shanntelmillett8309]

This was so helpful, it saved me so much time!! THANK YOU!!

[@lesleychamberlain3508]

So pleased I found this. Thanks from the UK

[@angelinekoh2076]

Thank you so much very clear video. I'm going to try now.

[@LAUREL5784]

Very helpful Kevin! Thank you so much!

[@jeanneleon9227]

Thank you!!! You made it so easy.

[@tdogmom6128]

Wow so far the best one I can understand. Thank you

[@kevinplayspiano]

Thank you for being awesome enough to post this. So helpful!

[@t1watt]

Thanks brother! You really saved me ALOT of time and frustration!

[@tnlimo1265]

Thank you very much!!! It was so helpful for me.

[@Timalay]

Years ago in my old job, I had to put around 150 address onto labels from an excel spreadsheet. First time I did it I hadn't put next address, so I had 150 labels all with the same address on them.

[@GraceMcKillip]

Thank you so much for this! Super helpful.

[@1stclassfireworks354]

Good tutorial brief and to the point. thanks for the refresher.

[@tracyfields1597]

I learn so much from you. Thank you so much!

[@rachaellloyd5678]

🎶THANK YOU🎶 you made it so easy.

[@realtor_nancycelis]

Thank you! Perfect presentation.

[@chrismantione]

thanks for the precise instructions.

[@jeffspersonal5998]

You didn't say what you did at Microsoft, LOL. Great video. Clear and concise information. The length was great. Thank you.

[@rhysbain1613]

Thanks for the great tutorial man!

[@shull488]

Thank you for your videos. Very informative and your speaking skills are excellent.

[@rshukla]

Thank you! Thank you! Thank you! This was insanely helpful, more than you can know.

[@shirleywiltshire8434]

Saved the day. Thanks easy to follow.

[@exvcator]

Very clear video, thank you.

[@ritaklimek8771]

Great tutorial. Easy to follow.

[@danaeking743]

Out here doing the lords work - thank you!

[@teewolfe9884]

Thank you so much!!!!! Exactly what I needed.