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.

[@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

[@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!

[@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!

[@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

[@janefink7509]

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

[@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.

[@DionnesDiscography]

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

[@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

[@jem02081]

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

[@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

[@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!

[@sgvepinfo9897]

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

[@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.

[@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?

[@ShanePatrickConnolly]

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

[@robinsingletary8111]

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

[@redcapeco]

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

[@trizza82]

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

[@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!

[@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.

[@katiebritton9272]

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

[@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".

[@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.

[@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.

[@herbo45]

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

[@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

[@ruthcolvin1564]

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

[@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?

[@redcapeco]

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

[@CH-hy8pi]

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

[@louispetrosino3793]

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

[@mainechiropracticassociati9275]

Best explanation AND tutorial ever!

[@RidgeRunnerTech]

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

[@laur7311]

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

[@kurtbjohnsoninc]

Great instruction from start to finish. THANKS!

[@udaproductions2]

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

[@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!!!

[@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

[@meli2180]

This was an amazing tutorial, I understood all the steps and succeeded on my first try! 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?

[@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!

[@trinidadrodriguez3191]

Perfect Pace and CLEAR! Thanks!

[@sueconstable]

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

[@reginachang3599]

So clear and helpful! Thank you!

[@redcapeco]

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

[@doriswhite6964]

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

[@bindupathak4405]

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

[@edieanddennylott8098]

Great video! Perfect instructions!

[@cbruno1970]

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

[@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?

[@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

[@ijhamel]

This was exactly what I needed!! Good job.

[@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?

[@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??

[@jvt6]

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

[@redcapeco]

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

[@anatakwala]

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

[@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?

[@matttown9520]

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

[@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?

[@deem2]

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

[@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!

[@higherhope8796]

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

[@danaolson3352]

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

[@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

[@redcapeco]

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

[@PattyLyonsKnitting]

Excellent tutorial

[@LowellVickers]

You're a lifesaver! Thanks for this!

[@rickyfarrer]

hi vicki. thank you for the tutorial! what software did you use to do your screen capture video? regards ricky

[@HempstoneOtieno2]

Camtasia

[@redcapeco]

Hempstone Otieno Thanks for replying, Hempstone! Yes. I used Camtasia.

[@katyodriscoll7823]

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

[@angelabrandenburger7247]

saved my life tonight! 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.

[@caroljantunen9745]

I am doing name tags for a class reunion. I want to add the picture of the person whose name tag I am making. Can I merge pictures and text?

[@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?

[@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

[@alewan5307]

This is really helpful, THANK YOU! :)

[@ambertomsovic7376]

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

[@AnniePoppieSeed]

Great Video, thanks!

[@redcapeco]

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

[@Neo08CA]

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

[@welbeckessinam2760]

Great. I love that. Enjoy your day Vicky

[@Alia-yb6sy]

Why mine come out the same people on the same paper ?

[@xzxz7654321]

I can't seem to recieve the excel template

[@twinkletoes6046]

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

[@christinaward242]

Thank you. Very helpful!

[@MateyKorkor]

Very useful, thank you

[@redcapeco]

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

[@Aliseeyah]

SUPER HELPFUL!

[@tanyaschramm1193]

When I did this, each new page started from the second entry of the previous page - so I had hundreds of double ups. it didn't go to next record

[@NAL203]

So helpful. 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. :-)

[@stuartlambert5059]

Superb - thanks

[@maluisa09]

this was very helpful thank you

[@redcapeco]

Great to hear! Thanks for posting.

[@Australiannamebadge]

While Microsoft Word can be used for making name badges, the ones created through it don't even come close to those created by a professional name badge maker. Since name badges symbolize the brand and are instrumental in giving it the much-needed visibility, it's only given that it is designed and made by a professional badge maker.