Create name tags using the Mail Merge feature in Microsoft Word

[@hulong0205]

10 years later in 2022. This is still the most helpful name tag making tutorial on KZbin.

[@chaplainkim86]

10 years later in 2023 and this helped me ENORMOUSLY. Bless you!

[@jillmiller7552]

This is seriously the most useful and efficient mail merge tutorial in history. Thank you.

[@redcapeco]

Jill Miller so glad you found it helpful! Thanks for taking the time to watch.

[@beth6342]

You are an angel. I was tearing my hair out trying to figure out how to do this and you explained it clearly. It worked perfectly!

[@juliemaresco821]

I struggled for hours trying to figure out how to do this and your video explained it in less than 10 minutes. So incredible thank you so much! You made my day at work so much better!

[@redcapeco]

Julie, so happy to hear you found this helpful! Thanks for the comment. - Vickie

[@ashleybrian2925]

What a HUGE help! I was overwhelmed before watching this video, but in a matter of minutes, my file was created! THANK YOU!

[@redcapeco]

+Ashley Brian I'm thrilled to hear that, Ashley. Well, not the part about being overwhelmed. That's my least favorite part. But I'm happy that you were able to get your project done. If you want more mail merge tips, we have a free webinar www.redcapeco.com/classes/5-mail-merge-secrets/ showcasing my top 5 timesaving secrets for mail merge. I hope you find it just as valuable. cheers! Vickie

[@jonvandeventer8279]

Very well done! Clearly explained at a pace that doesn't drag at all. I did pause and rewind as needed because I was taking notes to be shared with others, but I'd rather pause/rewind than fall asleep waiting for the next piece of information. Pausing also allowed me to work along with the video to ensure that there were no surprises when working with a slightly different version of MS. Thank you for taking the time to post this video!

[@janefink7509]

I needed a refresher on how to do name tags - great tutorial. I did not know about the update labels button - hugely helpful.

[@DionnesDiscography]

Very helpful, thank you! And not 30 minutes long! Informative, yet straight to the point!

[@jem02081]

Couldn't have been easier to follow & detailed enough to enable me to tweak the name tags to perfection ... Thanks

[@PG4H]

This tutorial is awesome!!! Thank you! It saved me from typing each on individually and we have 300 plus kids in the program. You are so clear and detailed in your explanation and presentation.

[@lisagaines2296]

Thank you Very much, I've been trying to make this work for 2 days now, just decided to come and watch a KZbin video to figure out what I was doing wrong. This wasn't even my first time but it had been over a year since the last time, thanks again. Success!

[@redgirl559]

Thank You! You I volunteered to do this task for the PTA, and was completely lost when they forwarded me the excel document...I've always been afraid of excel..But this was easier than I thought...Awesome instructor you are!!!

[@redcapeco]

+redgirl559 Thanks so much for your comment. I'm thrilled to hear that the video helped you overcome the fear of Excel! Hope the project went well. The PTA is lucky to have volunteers like you. ~ Vickie

[@tanyaraz4518]

Thank you...life saver! I don't do mail merge often enough to remember how to do it the next time, and than it's always a different version of Word I have to do it on. This is a nice, quick, and easy to understand way of getting going on badge printing.

[@ScratchByManal]

Thank you SO much, I honestly don't know how to best express my gratitude to you for this video. I was on inDesign for 6 hours straight trying to make about 800 name tags and it just would not listen. And then I come across your video, which is so straightforward and so helpful, and just really honestly thank you, and God bless you. So sleep deprived...

[@redcapeco]

Hi Manal, I'm so very grateful that this helped you! Thanks for letting me know. Please reach out if you need anything. Best, Vickie

[@sgvepinfo9897]

Great video. Solved MOST of my issues - but I'm here to say the list of names you used is classic.

[@robinsingletary8111]

Awesome! This really helped to get my "Update Labels" button working and being able to view all the labels at once. Thank you.

[@ShanePatrickConnolly]

Thank you! I always screw up the order of operations - this was a helpful and straightforward reminder!

[@nadinerichings4259]

Great instructive video! Thankyou, Vicky. It can replace my 4 pages of written notes that I used to hand out to members of the Local Organising Committee when they were organising a Meeting of our society.

[@samanthajohnson8284]

Thank you so much! The last computer in our office to have the Avery Wizard on it was recently updated so we lost the wizard. This just gave me back the ability to merge name badges!

[@trizza82]

THANK YOU. THE FIRST VIDEO THAT TRULY HELPED ME AFTER A WHILE. BESTs from AUSTRIA :)

[@katiebritton9272]

Clear...concise...immediately usable. Thank you!

[@benbalzer9716]

Thank you! Really helpful. One more suggestion: beware of paragraph breaks at the end of tables- these stopped my document filling fully, but once deleted it filled up perfectly. I was using a Fuji Xerox template from my local print shop, in Sydney Australia.

[@redcapeco]

Thanks, Nadine! So thrilled to hear that it helped you and your committee. We so need to spread the word about that magic button "Update Labels".

[@laur7311]

Thank you! The key is the Update Labels. That is what I was missing earlier. And yes certainly a time saver!

[@traceyfrugoli8973]

OMG, this is just what i needed when i needed it! You are a great instructor, thanks a million.

[@redcapeco]

Tracey Frugoli Oh great! So glad it helped you. I will be hosting a Mail Merge webinar Aug and Sep 2015. Hope you can join us! Visit our Classes page on redcapeco.com for registration details.

[@nadinenielsen6509]

Nice job explaining this!! I struggled for awhile also!! I couldn't figure out why Avery doesn't have a tutorial on their web page! Thank you!!

[@charitykunold5345]

This was such a big help! I have event for work tomorrow and this was a lifesaver! THANK YOU!!!!

[@redcapeco]

Charity Kunold That's awesome Charity! Glad to hear that it was timely and that it is what you needed. Good luck with tomorrow's event. Hope it's a HUGE success. ~ Vickie

[@gabriellarodriguez593]

Thank you, I revisit this page every December when I have to make hundreds of name tags!

[@redcapeco]

+Gabriella Rodriguez That's great to hear! We'll see you next year, then. :-) By the way, we have a free webinar on our classes page at www.redcapeco.com called "5 Timesaving secrets for mail merge" if you want to learn more tips.

[@ruthcolvin1564]

Thank you for this video. Helpful and straight to the point!

[@louispetrosino3793]

Just what I needed! Thanks for taking the time to create that video!!

[@mainechiropracticassociati9275]

Best explanation AND tutorial ever!

[@meli2180]

This was an amazing tutorial, I understood all the steps and succeeded on my first try! Thanks!!!

[@redcapeco]

Thanks, Katy! I'm glad you found it helpful and that you took the time to comment.

[@udaproductions2]

Awesome video! You are the best. i tried to figure this out a few years back and lost a whole day.

[@kurtbjohnsoninc]

Great instruction from start to finish. THANKS!

[@doriswhite6964]

Excellent video. Very easy to follow with perfect end result. Thanks.

[@willemsenmonique]

Great!! Thanks for you big help!! I have searched a long time how to do it. And it seems so easy. Thanks for your movie!!!

[@CH-hy8pi]

Amazing tutorial!!! Thank you for making this video.

[@RockPaperBeautiful]

This is fantastic. I knew how to do a mail merge to do nametags, but I could not figure out how to do it with a logo. I actually have to do a nametag in a month or so that has 2 logos and people's first and last name. Wish me luck!

[@anatakwala]

Thanks. It helped me for some work I needed to do as a first timer to this feature.

[@sueconstable]

Excellent presentation! First time I've been successful with labels :)

[@RidgeRunnerTech]

Great job! Saved me a lot of time. Thank you!!

[@redcapeco]

Great to hear! Thanks for taking the time to watch the video and post a comment. Hope your meeting went well!

[@ijhamel]

This was exactly what I needed!! Good job.

[@mattschyman]

This is a huge help....gonna save me a ton of time !

[@redcapeco]

+mattschyman Great to hear! Thanks for taking the time to comment. ~ Vickie

[@trinidadrodriguez3191]

Perfect Pace and CLEAR! Thanks!

[@jvt6]

Fantastic! I found all I needed in your video :)

[@harriethamilton7529]

Thank you so much, my colleague and I found this extremely helpful

[@redcapeco]

Oh great! Thanks for letting me know. So thrilled it helped you. :-) Cheers!

[@edieanddennylott8098]

Great video! Perfect instructions!

[@matttown9520]

Thank you so much! This video explained exactly what I needed to know.

[@redcapeco]

Thanks, Welbeck. Hope you have a great week. ~Vickie

[@katyodriscoll7823]

This was really helpful and super easy to follow and understand Thank you

[@reginachang3599]

So clear and helpful! Thank you!

[@redcapeco]

So thrilled this helped you! Thanks for letting me know. ~ Vickie

[@danaolson3352]

This was an AWESOME video, thank you so much!!!!

[@LowellVickers]

You're a lifesaver! Thanks for this!

[@job489]

Hey, this may be a stupid question, but with the latest version of Office, I've tried creating nametags. My only issue is that it only does one page with six name tags. I need over 300, but for some reason, when I have 50 blank pages, and I make labels, it only does one page and the 49 pages disappear. Am I missing something?

[@barbaranichols5167]

I used this last year - thanks. Do you know how to make it so that the back of the name tag has other information?

[@PattyLyonsKnitting]

Excellent tutorial

[@angelabrandenburger7247]

saved my life tonight! thanks!!

[@martyepperly5803]

This is great! My question pertains to adding names to my list after my original nametags have been created. For a club that I am creating nametags for, how do I add names down the road as our membership grows and I don't want to reprint all the nametags again?

[@redcapeco]

Sure! Glad you found it helpful. Thanks for watching and commenting.

[@AnniePoppieSeed]

Great Video, thanks!

[@welbeckessinam2760]

Great. I love that. Enjoy your day Vicky

[@MateyKorkor]

Very useful, thank you

[@deem2]

Thank you very much. This video helped me a lot. It was easy once I knew how. LOL

[@ambertomsovic7376]

You are an angel!! Thank you for saving my butt!

[@nicoledey688]

Hi, I am making security badges and the template I have created is in a table for with columns and rows and border shading. Is it possible to do a mail merge this way or will I have to create the cells in each cell of the label template I chose? Or when I hit update will it recognize the columns and rows I have added?

[@Aliseeyah]

SUPER HELPFUL!

[@antonygilbert8710]

Thank you very much. It is really very useful to me.

[@redcapeco]

+ANTONY GILBERT So happy to hear that you found this video useful. Hope the project went well! ~Vickie

[@porshabettis130]

You are a HERO. The only thing is that I see most do it in Excel. I was wondering how can I do in word. (make a list of recipients)

[@redcapeco]

Porsha, is it a requirement that the list is in Word? If not, then I would copy the list from Word and store it in Excel. Excel is much easier to use when managing a list. However, if you have to use Word...you can create the list on the fly from within Word. When you select Select Recipients, choose Type a New List. Add people and then you'll be forced to save that list as an MDB "Microsoft Office Address List" file. Let me know if that helps! ~ Vickie

[@christinaward242]

Thank you. Very helpful!

[@cbruno1970]

Great video!! I am having problems with it duplicating each name on one entire page? What am I doing wrong?

[@alewan5307]

This is really helpful, THANK YOU! :)

[@redcapeco]

Good timing , indeed! Glad you found it helpful. Best of luck with your upcoming project. :-) ~ Vickie

[@silverside99]

Thanks for the video, fantastic.. I have a question.. i follow the instructions on the video but everytime I open the world doc (the layout that i chooses for the name tag) the curser appears in the middle of the box left aligned. and when i insert the picture, it places itself right there that cant move. Can you help me please??

[@Neo08CA]

Thank you very much for the the video! you have saved me a lot of time :)

[@stuartlambert5059]

Superb - thanks

[@EliLebowiczComedy]

If the image is a background instead of a logo, and I want to have the names over the background, do you know how to make sure the words are still visible even with the background?

[@Jennifer-tv8kn]

This was so helpful! But unfortunately, although the name merge works for me, the artwork I see on my screen doesn't print on the labels - only the names do. What could be wrong?

[@NAL203]

So helpful. Thank you!!!

[@twinkletoes6046]

thank you so much for the video. it really helps me a lot. God bless you. :)

[@kpcruz8264]

This is great except for one small detail. I rarely add a logo or titles, just names, so I want the contents of the cell centered. On a single cell I get the Table Tools tab and under layout options I can center that cell. When I update labels it does everything except the center alignment (horizontal is still centered, but vertically it's aligned to the top). I have to manually change each cell or add returns to the first until it looks correct. Why does that not update?

[@higherhope8796]

Do you have video showing how to print double sided name tags?

[@redcapeco]

Great! Glad you found it helpful. Thanks for letting me know.

[@bindupathak4405]

hi vikki in my computer doent highlights some options to put first name or last name ?

[@redcapeco]

Great to hear! Thanks for posting.

[@kjvbible1611]

Thank You, Gary

[@CAOFER]

Very helpfull.

[@maluisa09]

this was very helpful thank you

[@herbo45]

I input a list of names as she instructs. Then says "close out of that list" ... and ....???? Where does it go???

[@redcapeco]

Hi there. Which template were you looking for? Did you want the Excel file with the sample names in order to practice the mail merge?

[@catherinepang4204]

can you tell me how to create template for Q-Connect 54 x 90 mm Name Badge Inserts 10 Per Sheet KF02289 when the template is not available in MS options, unlike Avery label template is

[@xcastro1157]

THANK YOU!!!

[@asfoster4241]

Thanks this really helped me out alot =)

[@rodrigoandresbenvenuto271]

Thanks a lot, it was very helpful, I saved time and so money, thaaaanks!!. Cheers

[@redcapeco]

+Rodrigo Andres Benvenuto That's wonderful to hear. Good luck with your mail merge project. :-)

[@igorsk19]

Thank you!

[@utkuay]

Thanks for this information, allah razı olsun

[@mason_is_interesting3991]

Thanks

[@dianaxu5926]

Hi! Is there a way to have a customized backside (so making these tags double sided) using MailMerge?

[@driser281]

Make a separate mailmerge document and run your name tags or placecards through printer again to print the 2nd document on their backside. Play around with a test page to make certain you know how you need to feed the printed labels in the printer to do this successfully. I've done this before to make tent place cards so name appeared on both sides.