How to Create Mailing Labels in Word From an Excel List

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

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

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

    After watching too many other videos, I found this one! And now, after many failed tries down through the years, I had success! Thanks very much for such a helpful tutorial. I now have a polished set of mailing labels for my holiday cards.

  • @consciouspuppets-puppetthe4315
    @consciouspuppets-puppetthe4315 2 года назад

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

  • @Bonnster51
    @Bonnster51 2 года назад +1

    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.

  • @suealexander8247
    @suealexander8247 2 года назад

    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!

  • @bgiammona
    @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!

  • @KrisSimonson
    @KrisSimonson 27 дней назад

    Wow, great video. Most video tutorials go so fast that I can't understand what they are doing. Yours covered each step clearly and didn't assume I had any previous knowledge (which I didn't). It worked exactly as you showed except my label outlines weren't visible (but I figured out it didn't matter).

  • @jenniferbrunette4406
    @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.

  • @DePersuader
    @DePersuader 2 года назад

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

  • @homegoalswithjanice
    @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!

  • @anntozier7614
    @anntozier7614 3 года назад

    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!

  • @terrealford7868
    @terrealford7868 2 года назад

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

  • @dayanariano9562
    @dayanariano9562 2 года назад +1

    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

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

    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.

  • @cristidasilva9471
    @cristidasilva9471 2 года назад

    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!

  • @georgesitts1557
    @georgesitts1557 3 года назад

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

  • @kev64037
    @kev64037 2 года назад

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

  • @cathygaertner9582
    @cathygaertner9582 3 года назад

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

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

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

  • @chriswhalen8684
    @chriswhalen8684 2 года назад

    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.

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

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

  • @dianeborries1261
    @dianeborries1261 2 года назад

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

  • @corkyking0301
    @corkyking0301 2 года назад

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

  • @debrameeks8243
    @debrameeks8243 2 года назад

    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!

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

    Thanks for making this so easy - I have done it before, but with the time lapse between when I have to conduct a mail merge, I always forget the steps!

  • @anniemurray5174
    @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.

  • @susanmeek9712
    @susanmeek9712 3 года назад +1

    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
    @mktbooks1082 2 года назад +3

    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 RUclips 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! 👍👍👍👍👍

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

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

  • @pureromancebytyler
    @pureromancebytyler 2 года назад

    Thank you so much for this! You're awesome! How do you get the label lines to show on the screen?

  • @stopdrinkingleftskoolaid6510
    @stopdrinkingleftskoolaid6510 2 года назад

    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!

  • @freshbeatsocial3539
    @freshbeatsocial3539 3 года назад +5

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

  • @Sarah-pc5wj
    @Sarah-pc5wj 2 года назад

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

  • @cedricholt9347
    @cedricholt9347 2 года назад +2

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

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

    A brilliant video and so helpful. Saved my life.

  • @SanAndCo
    @SanAndCo 3 года назад +1

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

  • @denisestump7163
    @denisestump7163 3 года назад

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

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

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

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

    Thanks so much for posting. I forget how to do this every Holiday (and then the software changes anyway). This was easy and fast. Thank you! (And happy holidays!)

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

    SUPER easy to follow tutorial! Thank you!!!

  • @beverlylitfield1142
    @beverlylitfield1142 2 года назад +1

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

  • @edwinpaz9880
    @edwinpaz9880 3 года назад +4

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

  • @junemariebrandt1825
    @junemariebrandt1825 3 года назад

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

  • @normamaynard78
    @normamaynard78 3 года назад

    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!

  • @rosalierollins1975
    @rosalierollins1975 2 года назад

    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.

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

    Super helpful & easy to follow. Thank you!

  • @joannsilvia9712
    @joannsilvia9712 2 года назад

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

  • @marlenedevlin6329
    @marlenedevlin6329 3 года назад +2

    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!

  • @not_kaija889
    @not_kaija889 2 года назад +2

    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!

  • @brendalott5445
    @brendalott5445 2 года назад

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

  • @aucarter
    @aucarter 2 года назад +1

    Thank you for these instructions!

  • @moidelcastillo3313
    @moidelcastillo3313 2 года назад

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

  • @annmariezlomkechan1608
    @annmariezlomkechan1608 2 года назад

    Thank you so much for your helpful tutorial. It saved me a lot of frustration trying to figure it out on my own. whoo hoo!

  • @cathleenrenner9878
    @cathleenrenner9878 2 года назад

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

  • @DDPizazz
    @DDPizazz 3 года назад +3

    Excellent and to-the-point video! My word document would not show the label outlines unitl I set the cell outlines to show up (under the home tab) Then my word document only filled in one page of labels instead of all of the addresses in my spreadsheet. I think this was due to one of the street column cells in my reference spreadsheet being temporarily blank (waiting to find out that data).
    Otherwise your instructions worked perfectly! I have office 365, so my menu looked a little bit different, but not so much different that I could not figure it out.
    Again, well done, and thank you for putting this out for us!

  • @MelaniKodikian
    @MelaniKodikian 2 года назад

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

  • @martygrieve795
    @martygrieve795 2 года назад +2

    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.

  • @DonnaMoore-w6l
    @DonnaMoore-w6l Год назад

    Great video.. I always center my labels and sometimes need to move label up or down a little to fit in the label. How do I do that? Thanks

  • @debragallaway6982
    @debragallaway6982 3 года назад

    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!

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

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

  • @j.baldwinwasagenius...7575
    @j.baldwinwasagenius...7575 2 года назад

    Very helpful. Unfortunately "next record" did not populate on all the labels when I did this so I had to do it manually. Not sure why this happened. Great video!

  • @daniellejbowen
    @daniellejbowen 3 года назад

    Great step by step directions! Thank you!

  • @kristymiceli5692
    @kristymiceli5692 3 года назад

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

  • @debigoulding9089
    @debigoulding9089 2 года назад

    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!

  • @lauraescalante7450
    @lauraescalante7450 3 года назад +1

    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!

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

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

  • @lindajordan5481
    @lindajordan5481 2 года назад

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

  • @tattedfemale
    @tattedfemale 3 года назад

    This was so helpful! I look like a rockstar with my boss! Thank you.

  • @tjbranbran
    @tjbranbran 2 года назад

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

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

    This was the best tutorial and helped me immediately!!thank you

  • @debrawallace970
    @debrawallace970 2 года назад

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

  • @michaelold7357
    @michaelold7357 2 года назад

    Well done! Very clear explanation and process!

  • @richardhill7388
    @richardhill7388 3 года назад

    Wonderful even if it Americanised! Us Brits are resourceful! Thanks

  • @andrijas72
    @andrijas72 2 года назад

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

  • @joancuadra1
    @joancuadra1 20 часов назад

    very very easy to understand .... thank you.

  • @chriswerter801
    @chriswerter801 3 года назад

    Thanks very much! Very well done tutorial. I have one question -- what happens if you have one field that is present in some addresses but not others, such as country.. will that change anything?

  • @rosshart9035
    @rosshart9035 2 года назад

    You ROCK! Thank you for this wonderful tutorial.

  • @heatherwitt9595
    @heatherwitt9595 2 года назад

    Really great tutorial! Thank you so much!

  • @lycolovelies
    @lycolovelies 3 года назад

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

  • @ruthgoodman5507
    @ruthgoodman5507 4 года назад +1

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

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

    This was so easy to follow. Thank you so much

  • @CamilleSharpler
    @CamilleSharpler 2 года назад

    Thank you so much!!!! This video was a life saver!

  • @dhapumdhap
    @dhapumdhap 2 года назад

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

  • @janegilbert1409
    @janegilbert1409 2 года назад

    Awesome. Worked perfectly. Thanks!!

  • @homesfund9319
    @homesfund9319 2 года назад

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

  • @mveteclemence1080
    @mveteclemence1080 2 года назад

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

  • @1118austin
    @1118austin 2 года назад

    Excellent video and I have saved for future reference since I don't do labels often. One question I have is when I view each label they are is too close to the left & tops margins. Then they sometimes print a little off the label if the label paper prints a tiny bit off. I don't know how to change the left and top spacing unless I do each one individually in layout. Not too much of a problem if I'm just doing one page, but not fun if doing large mailings. I can change left margin/spacing fairly easy, but not the top without doing individually.
    Any advice?

  • @shaunslaughter2646
    @shaunslaughter2646 2 года назад

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

  • @danagrace1091
    @danagrace1091 2 года назад

    Great Video, Very Helpful, Thank You!

  • @ronaldcoia6064
    @ronaldcoia6064 2 года назад

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

  • @JaneHouldsworth-c8r
    @JaneHouldsworth-c8r 9 месяцев назад

    Thanks for the video instructions!

  • @coreypospisil616
    @coreypospisil616 2 года назад

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

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

    Straight and to the point. Thanks.

  • @alexandria_g
    @alexandria_g 3 года назад

    Thank you so much! Very helpful video

  • @markmercnut
    @markmercnut 2 года назад

    Phenomenal video, clear and concise, thank you

  • @lisawilliamsen2888
    @lisawilliamsen2888 3 года назад

    Excellent tutorial!

  • @kittytuberty271
    @kittytuberty271 3 года назад +1

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

  • @wempy1452
    @wempy1452 3 года назад

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

  • @mustafabiviji00711
    @mustafabiviji00711 3 года назад +1

    Is it possible to conditionally color some of the text on the label?
    Say certain names (or cities) need to be colored red or some other color which is based on value. And excel has the conditional formatting - is there a way to color different names/cities in different colors?

  • @annettebarletta8014
    @annettebarletta8014 3 года назад

    Whah! Vodep scrambled!! Sounds really great!!

  • @marissadimare-thedimaregro1739
    @marissadimare-thedimaregro1739 3 года назад

    Great job!! Your video is on point!