Create Labels from a List in Excel | Mail Merge Labels from Excel to Word | Print Avery Labels

Поделиться
HTML-код
  • Опубликовано: 18 дек 2024

Комментарии • 155

  • @andreawymer2625
    @andreawymer2625 Год назад +19

    Best tutorial I've seen!! Every year I go to print Christmas labels and I search for the instructional video or instructions to do it and every year I struggle. Not this year!! I have saved this video and will refer to it time and time again! Also loved the little tidbits nobody else has ever passed along like changing the cell margins and spacing between lines. Bravo!

    • @michaelcronin3224
      @michaelcronin3224 9 дней назад

      Agree this is a fab video. Microsoft annually changes their software about creating and printing labels, so I need new guidance every year. The Microsoft documentation is inferior.

  • @gracedavis1347
    @gracedavis1347 9 месяцев назад +9

    You just saved me blood, sweat, and oh, so many tears. Bless you.❤

  • @richardtanner7156
    @richardtanner7156 2 дня назад

    When you know what you are doing, isn't it simple. Thanks Mr. Tugwell.

  • @naomifitzwater494
    @naomifitzwater494 6 дней назад

    I am from the USA. I looked and listened to many videos on how to mail merge address labels. I finally found you. Your voice is clear, soft and slow speaking so I can understand what you are saying. I want to thank you for helping me. I will be looking and learning from all your videos.
    Naomi Fitzwater 😊

  • @BaysideHousing
    @BaysideHousing Год назад +6

    This was one of the most thorough and helpful tutorial's I've seen in a long time! Thank you!

  • @JudieBerro
    @JudieBerro 2 дня назад

    thank you! This is the best tutorial for making address labels. Very easy and simple to follow.

  • @jaquelynashbery8557
    @jaquelynashbery8557 2 дня назад

    Thank you for a straightforward, clear tutorial.

  • @dianagolden1733
    @dianagolden1733 11 дней назад

    Thank you so much for your video….just the steps…. concise, easy to follow, and most importantly IT WORKED! Not a single paper was wasted. Very much appreciated

  • @donnalandry4743
    @donnalandry4743 Год назад +2

    That was EXCELLENT! I spent 2 hours trying to print labels and just watched this great video and it got the job done!

  • @jennieanderson5291
    @jennieanderson5291 16 дней назад

    After scouring the web for articles on how to do this, I screamed in frustration and went to RUclips, and promptly found this video. It was the perfect explanation of how to do this thing that I KNEW WAS POSSIBLE but could not figure out. THANK YOU.

  • @aadmin100
    @aadmin100 2 дня назад

    Chris... Excellent ... Much appreciated... Perfect Explanation

  • @BarbaraRinaldi-o2w
    @BarbaraRinaldi-o2w 9 дней назад

    Your step by step instructions are so clear and helpful. Thank you for making my Christmas card tasks a breeze!

  • @MagdalenaOMags
    @MagdalenaOMags 2 дня назад

    This tutorial ROCKED IT!!! Thank you!

  • @karendavenport2721
    @karendavenport2721 Год назад +2

    You by far explained the merge/label process the best!!

  • @ingonessel4625
    @ingonessel4625 21 день назад

    Thank you Thank you Thank you! After three failed attempts from other videos, yours worked the first time!

  • @tmriley04
    @tmriley04 8 месяцев назад +2

    Direct and straight to the point. Thank you for the Tutorial.

  • @kae146
    @kae146 Год назад +7

    Super easy tutorial and exactly what I was looking for! Thank you so much!

  • @sarahschuster6480
    @sarahschuster6480 7 дней назад

    I literally love you. Should have searched for some help yesterday. Would have saved me over 2 hours.

  • @BienGuapo
    @BienGuapo Месяц назад

    Thank you again, revisited this one video and it saved me massively on labels for prices at my grocery store, I APPRECIATE YOU.

  • @laurihauser6703
    @laurihauser6703 4 дня назад

    Thank you! This worked great. :) Loved the pace, and extra explanations.

  • @robertlaveyra9940
    @robertlaveyra9940 8 дней назад

    I have to do this every year and your video is the best. Thank you, good presentation.

  • @stephenberkeley1653
    @stephenberkeley1653 Месяц назад

    Thank you. So easy to follow and you have an easy listening voice. Had my labels set up in the time it took to listen.

  • @TheMrWills
    @TheMrWills 2 месяца назад

    As others have said, you just saved me about 154 years of my life lol. Thank you!

  • @KristinaPruett
    @KristinaPruett 3 месяца назад

    Step by step directions. Easy to follow and understand.

  • @michaelmatthews2818
    @michaelmatthews2818 7 месяцев назад +1

    This is exactly what I needed. When I last searched for this information, the demonstration used the wizard and that did not work for me. I needed the full process. Thanks again!

  • @Ukborn70
    @Ukborn70 Месяц назад

    Thank you! You explained it so clearly and simply that I actually created labels!

  • @holycrapdude900
    @holycrapdude900 27 дней назад +1

    THANK YOU!! Just saved me a ton of time, thumbs up!!

  • @nickt2159
    @nickt2159 3 месяца назад

    Yours is one of the better vids on how to use mailmerge features.

  • @Homesbyhelenkburke
    @Homesbyhelenkburke 8 месяцев назад

    FANTASTIC VIDEO!!!! Precise and to the point, very helpful!

  • @wesleym162
    @wesleym162 7 дней назад

    Extremely easy and well explained. Thank you.

  • @CherylSchuldt
    @CherylSchuldt Месяц назад

    Thank you! Best label tutorial. That cell margin hint has saved me tremendous angst

  • @DanelleBrown-t2w
    @DanelleBrown-t2w Год назад +1

    This was the best how-to video. It literally covered every issue I was having. Thank you!!

  • @jeffroberts4691
    @jeffroberts4691 12 дней назад

    I only do this annually, so this is sooooo helpful!

  • @justinrenaissance4562
    @justinrenaissance4562 15 дней назад

    This was the ONLY video or information I found that helped me. Thank you!!

  • @FrancesS-y8d
    @FrancesS-y8d Год назад +1

    Easily showed me how to do it! Simple and quick. Thank you!

  • @vanessastafford5749
    @vanessastafford5749 Год назад +2

    This was very concise and extremely helpful. Just what I needed! Thank you!!!

  • @marianajames1395
    @marianajames1395 26 дней назад +1

    BEST video ever! thank you SO much! :D

  • @tinplategeektoo
    @tinplategeektoo Год назад +2

    Could done with this a month ago. I was going round in circles then. Thanks for the clear explanation.

  • @DavidJones-zv4uu
    @DavidJones-zv4uu 3 месяца назад

    Great video on how to convert an excel into MS Word for an Avery Label sheet.

  • @frediaallure2528
    @frediaallure2528 2 месяца назад

    At work and the shipping person doesnt know how to do her job, so i needed a refresher course to do it for her 😊 this was perfect!

  • @subharmonicj8811
    @subharmonicj8811 6 месяцев назад

    Thanks for taking the time to do this. Great little tutorial to get off the ground.

  • @marissabakaysa7640
    @marissabakaysa7640 13 дней назад

    Thank you for the quick and helpful video!

  • @janicestevenson5662
    @janicestevenson5662 14 дней назад

    HI, Your video was exactly what I needed to get my Christmas Card Labels printed. I followed it word for word. Thank you so much. Perhaps you could add a small one to help Epson printer people who get messages that it defaulted to cd printing or words to that effect. That added far too much time trying to get that sorted out. Season's greeting to you

  • @CarolynnSantos
    @CarolynnSantos Год назад +1

    Excellent - Clear, precise, easy, fast - THANK YOU!

  • @lupitacardenas8717
    @lupitacardenas8717 Год назад +2

    Thank You!
    You explain very well. Easy to understand.

  • @randyvfromtheperch
    @randyvfromtheperch Месяц назад

    Easy instructions - well done sir, thanks!
    .

  • @skearabflintz1482
    @skearabflintz1482 7 дней назад

    Awesome video! Great explanation here.

  • @beatricerodriguez6645
    @beatricerodriguez6645 Год назад +1

    You are an amazing instructor. Thank you so much !

  • @edwardsavela
    @edwardsavela 3 дня назад

    Thanks. Easy to follow.

  • @alisastandley9237
    @alisastandley9237 Год назад +3

    Great tutorial! Exactly what I needed. Thank you for being so thorough.

  • @tonymanfredi7869
    @tonymanfredi7869 Год назад

    Great tutorial... Success after many tries.. Chester is awesome!!

  • @sheilalussier6788
    @sheilalussier6788 Год назад +2

    Thank you - thank you - thank you! Very clear instructions! Was going around in circles - again thank you!

  • @reneelynhansen
    @reneelynhansen Год назад

    EXCELLENT tutorial! Very easy to follow. Thank you!!!

  • @janicesharpe7159
    @janicesharpe7159 11 месяцев назад

    Can this method of creating labels be used with different size labels, such as with Avery label 5366 or 5262? Your video was very clear and easy to follow. Thank you

  • @richardtillis3528
    @richardtillis3528 4 месяца назад

    Very Best - you have saved me hours of frustration

  • @veronicaflamenco
    @veronicaflamenco Месяц назад

    AMAZING tutorial. Thank you!

  • @andyaustin7942
    @andyaustin7942 Месяц назад

    Thank you! You saved me so much time!

  • @bexboster2174
    @bexboster2174 Год назад +4

    Perfect. Fast, easy, exactly what I needed.

  • @StephK-j4l
    @StephK-j4l 3 часа назад

    Thank you for this!!

  • @melwitting
    @melwitting 4 месяца назад

    Thank you so much!! Super helpful. Works perfect!!

  • @micheledennis2302
    @micheledennis2302 7 дней назад

    Hi Chester, Thank you for a brilliant video. The first tiome I went through this I was able to include all 110 of my records, but now for some reason when I use Preview, only the first 30 records are included. Any ideas?

  • @MarianNorris-t6w
    @MarianNorris-t6w Год назад

    thank you, one step and I just couldn't have done it without you!

  • @christophertrojanovich3448
    @christophertrojanovich3448 9 дней назад

    Excellent!!

  • @straxun
    @straxun Год назад

    Awesome video, used this to do some direct mail marketing for my business.
    Thank you very much.

  • @laurieshanderson
    @laurieshanderson 6 месяцев назад

    Thank you for the help! You made it very easy!

  • @amartinez1513
    @amartinez1513 8 месяцев назад

    Best ever! Thank you so much for doing this! It helped me so much!

  • @AntonioHernandez-xc4nb
    @AntonioHernandez-xc4nb 4 месяца назад

    First thanks for information, very helpful. My question to you, is there a way to insert from excel by just highlighting the People that i want to include in the labels ? I have quite of few people i don't want to include in this print. Thanks

  • @Anthony-js2cv
    @Anthony-js2cv Год назад

    Thanks! I'm just working out how to set up some formatting and once that's done it looks like 1-2 days worth of data entry saved. Thanks!

  • @jjsq22
    @jjsq22 2 месяца назад

    1 word.. Perfect!

  • @yomi001
    @yomi001 4 месяца назад

    Very well explained!

  • @ProfessorBones2012
    @ProfessorBones2012 Год назад

    Best tutorial on this topic. Thank you.

  • @EkaterinaHagen
    @EkaterinaHagen Год назад +1

    Such a great explanation! I was stressing out adding one by one!! ❤

  • @parrisgjerde9212
    @parrisgjerde9212 8 месяцев назад

    Thank you very much. Worked like a charm!

  • @budman697
    @budman697 9 дней назад

    Chester, thanks for this amazing video. Do you know why after I select the template for label it appears with two sheets, only one sheet is grid lined and I cannot delete the other?

  • @Salvatore218
    @Salvatore218 Год назад

    Very helpful and clear. It was just I needed. Thank you

  • @AnnLippert1
    @AnnLippert1 7 дней назад

    very helpful video!

  • @jimbriggs9591
    @jimbriggs9591 Месяц назад

    You are my hero. Thank you!

  • @cristinawheeler5417
    @cristinawheeler5417 Год назад

    Hi Chester, awesome tutorial! When I printed most pages were full but some came out half printed or with just a few addresses on, why did this happen?

  • @Jan-oi3du
    @Jan-oi3du Год назад

    Thank you soooo much for the detailed step by step. Well articulated!

  • @christinem.8680
    @christinem.8680 3 месяца назад

    Fantastic Help, Thank You!

  • @michelecormier8160
    @michelecormier8160 Год назад

    Great job - clear and concise

  • @JohnWolffPortraits
    @JohnWolffPortraits 3 месяца назад

    I have continue to use your Mail Merge tutorial to produce my labels….always works….except the one time I used italics in one of the Excel fields. Although all the text in each cell was in italics, when merged with the Word Mail Merge program, the italics were not recognized and the font was the normal Arial type…just as you see in this note. If there is fix or work-around for this issue, could you make a video about it? All RUclips searches just deal with number formats or converting numbers to text….Thank you very much…

  • @penzeyh1
    @penzeyh1 3 месяца назад

    Thank you! This was great.

  • @alishanagle6538
    @alishanagle6538 8 месяцев назад

    Do you have a video on what to do before the step of word. Do you just save the excel file and then do the mail merge or are there steps to do before.

  • @ntxsubie4282
    @ntxsubie4282 8 месяцев назад

    Great tutorial

  • @cochusacongress6354
    @cochusacongress6354 Месяц назад

    THE BEST. Thank you!!

  • @PatriciaDavis-bd3td
    @PatriciaDavis-bd3td Месяц назад

    Oh my goodness!!! Thank you!!!!!!!!!

  • @skydivesmitty
    @skydivesmitty Год назад

    wow, that was easy. What else can you teach us? Great job!!

  • @TEM14411
    @TEM14411 Год назад

    THANK YOU! This was the video I needed!!

  • @stephaniewhite6692
    @stephaniewhite6692 9 месяцев назад

    Best tutorial! Thank you so much for your help!

  • @AlexRamirez-vq4gc
    @AlexRamirez-vq4gc Месяц назад

    Thank you, thank you.

  • @vimalraju5467
    @vimalraju5467 4 месяца назад

    Thank you sir.....helped me lot....

  • @CharlieBuchanan-f5r
    @CharlieBuchanan-f5r 4 месяца назад

    Awesome. Thank you!

  • @MrDhunpagla
    @MrDhunpagla Год назад +1

    Awesome Mr T 👍👏👏

  • @connyarias1
    @connyarias1 Год назад

    Gracias! saludos desde Ciudad de México.

  • @PaulGodfrey
    @PaulGodfrey Год назад +2

    Excellent. Thanks

  • @cecilparker2866
    @cecilparker2866 Год назад

    very good, just what I was looking for

  • @renatosanchez5968
    @renatosanchez5968 Год назад

    Excellent tutorial

  • @mar4elo999
    @mar4elo999 13 дней назад

    AMAZINGGG!

  • @jwothedj
    @jwothedj Год назад

    If one adds a column for print qty, is it possible to map the functionality to print more then one label per row of data based on the cell value in that colum for that row? 🤞