How to print mailing labels from Excel

Поділитися
Вставка
  • Опубліковано 6 лип 2024
  • In this video I show you how print your mailing labels from a list of addresses in Excel. I show you how to check which labels will work with Office.
    If you're looking to type directly onto your labels using Word, check out my other video that I'm releasing at the same time:
    • How to print mailing l...
    Buy the Avery L7160 address labels here:
    geni.us/bdOEao
    Buy genuine Microsoft Office at Amazon:
    Office 365 Personal - geni.us/365Persona
    Office 365 Home - geni.us/365Hom
    Office 2019 Home & Student - geni.us/Office2019
    DONATE - Several viewers have kindly asked how they can support my channel. You're welcome to make a donation through PayPal using this link if you wish. Thanks!
    www.paypal.me/davestechrescue
    #christmascards
    ** My gear **
    Camera - Canon EOS 700D (Rebel T5i)
    geni.us/mVaL
    Microphone - Rode Videomic Pro
    geni.us/ymKY5R
    Laptop - HP Spectre x360
    geni.us/OS4d
    As an Amazon Associate I earn from qualifying purchases.
    Music: www.bensound.com
  • Наука та технологія

КОМЕНТАРІ • 508

  • @janetmathews9713
    @janetmathews9713 3 роки тому +2

    I learned, or say was instructed in, Mail Merge over 25 years ago, but now, when I need it, you were there for me, and I so appreciate it! You made it so easy even on my older Word & Excel programs.

  • @carolynleechapman4942
    @carolynleechapman4942 2 роки тому +5

    This was an awesome tutorial. I tried to print from Excel a few years ago, and I had terrible problems then. This was smooth and easy! Terrific!

  • @devilsporkchop1263
    @devilsporkchop1263 2 роки тому +3

    this is one of the best you tube video's of any subject description that I've ever watched. Thank you for being clear, concise, and plain.

  • @christinalennon2224
    @christinalennon2224 2 роки тому +7

    This tutorial is so incredibly helpful! Thank you so much!! This is the second year in a row I have referred back to your tutorial for help printing my Christmas card labels. I must say the second time around was much quicker given I already had everything set up the way you explained. 10/10!!

  • @morganfamonly
    @morganfamonly 3 роки тому +2

    Excellent tutorial. He speaks clearly, and moves his cursor smoothly enough I could follow it easily. Again, EXCELLENT tutorial. Thanks!

  • @whozyourdaddy
    @whozyourdaddy 2 роки тому

    Dave, I come here twice a year for my mailings. Without you, it would not get done. So easy to understand and follow.

  • @sheilawayman5621
    @sheilawayman5621 3 роки тому +38

    This tutorial is just what I needed today. Your directions are very clear and at a pace that is easy to follow. Thank you so much for producing this tutorial that is so helpful!

  • @lisamercure3427
    @lisamercure3427 4 роки тому +8

    THANK YOU! Your instructions were very easy to follow and at the perfect pace for me.

  • @laurapainterfdnp
    @laurapainterfdnp 3 роки тому

    I cannot thank you enough. I have always relied on assistants to do these things and I don’t understand tech at all. And I was actually able to do this following step by step!!!! Really appreciate it.

  • @iantolchard7669
    @iantolchard7669 2 роки тому +1

    Top tutorial !!!!
    I wish everything on UA-cam was as professional and well explained as this.
    I was dreading having to write out hundreds of addresses and this very well structured tutorial has saved me heaps of time.
    I will definitely be following this channel from now on.

  • @michaeljay3
    @michaeljay3 Рік тому

    I have seen a few, but this is easily the best video on printing labels from Excel. Dave is very clear and logical. Most impressed and very well done! !🙂

  • @mariarolland6167
    @mariarolland6167 Рік тому

    So helpful! I've tried printing labels so many times in the past, and this was my first success! Thank you!

  • @beckykopesdy2569
    @beckykopesdy2569 Рік тому

    I can't thank you enough for making this video! For years and years I have been addressing my Christmas cards by hand, and its such a pain! I was determined to figure out how to make printer labels. You saved me so much time!!! Thank you!!

  • @bendonahower5325
    @bendonahower5325 2 роки тому

    You are a God among men. I've muddled my way through other tutorials for labels in the past. This one was by far the most foolproof.

  • @cindyboyles2323
    @cindyboyles2323 3 роки тому +2

    Thank you for this wonderful step-by-step guide. Very easy to follow, and it worked perfectly the first time. Appreciate your clarity.

  • @leonardbeddows3192
    @leonardbeddows3192 2 роки тому

    I spent several hours trying to follow MIcrosoft's Help columns without managing to produce labels. Then I looked at your video and it explained everything. Many thanks Dave.

  • @gezbo66
    @gezbo66 3 роки тому +2

    Saved me. Spent an hour on another tutorial and it never worked. I needed a good Englishman to help sort me out. Cheers Dave!!

  • @lenibjerg3771
    @lenibjerg3771 2 роки тому +1

    Thank you for this informative and easy to follow instructional video. You just saved me have to type our whole database into labels manually. Super job. xx

  • @janedriscoll7459
    @janedriscoll7459 2 роки тому

    I helped a friend today do this and your video was SO helpful. Thank you! My friend has rather minimal computer skills, so I sat next to him at my dining room table with your video on my laptop while he followed the steps on his laptop. Worked great!

  • @alanharding2026
    @alanharding2026 Рік тому

    An excellent tutorial. The first time I have compiled and printed address labels, using Dave's instructive 'step by step' video I was successful first time. Top class!

  • @carolmorgan9228
    @carolmorgan9228 3 роки тому

    Thank you so much! I struggle every Christmas to get my labels printed. This is so helpful and I am thrilled to never have to relearn how to do this every year. Merry Christmas!

  • @donandtammyhilt7237
    @donandtammyhilt7237 Рік тому +4

    This is a great tutorial! Dave explained clearly and patiently what to do, and it made creating and printing labels for my Christmas card list so easy! It was vert helpful!

  • @Don-uf4gt
    @Don-uf4gt 2 роки тому

    This is the clearest and most helpful video I've ever seen on any subject. I spent hours trying to find a way to reduce the space between the lines on an address label. Your hint about Shift/Enter solved the problem. If Microsoft would fix their design flaw, a workaround wouldn't be necessary.

  • @edbaartman4599
    @edbaartman4599 Рік тому +1

    Great tutorial. Easy to follow and not verbose as many of these are. Helped me out a ton printing labels for my Christmas card mail out.

  • @debbiemoore8058
    @debbiemoore8058 3 роки тому +1

    This was tremendously helpful. Thanks so much. Clear and concise and easy to follow. Good job!

  • @BrookeBullmasterStewart
    @BrookeBullmasterStewart 3 роки тому +2

    Hey thanks! I loved how you let us know how to adjust the list and it reflects this in the labels doc! Perfect for Christmas Card recipients list as addresses change!

  • @jimriding1074
    @jimriding1074 2 роки тому

    Just checked out your tutorial on how to print out labels from excel. Fantastic tutorial and very clear and concise. Saved me a lot of typing them individually. 👍

  • @amycarman6292
    @amycarman6292 3 роки тому

    Perfect presentation. Absolutely the best UA-cam tutorial I have ever followed. Thank you!

  • @annlord928
    @annlord928 3 роки тому +1

    Superb!! I'm not very IT savvy but this tutorial was brilliant - a very clear, step-by-step instruction video that even I could understand, with added hints to make life easy!! Many thanks!

  • @michaeldoyle5242
    @michaeldoyle5242 2 роки тому

    Having commented on your Word tutorial, suffice to say that this too was a very easy to follow and clearly explained video tutorial, the flow of the explanation is at such a relaxed pace, and even though I do like to view tutorials twice, there really is no need with the way in which this whole method of address label preparation and printing is illustrated, the delivery as I said previously is first class, thank you so much for your well presented tutorial.

  • @eulainemcintosh6538
    @eulainemcintosh6538 2 роки тому

    I have wasted time trying to learn from other sources how to do this. You're video is the Best! Works well.

  • @AmandaJYoungs
    @AmandaJYoungs 3 роки тому

    Your instructions are so clear and straightforward. A person can become quite frazzled when the technology doesn't follow what seems most logical to the person, but you make it so simple, I had to subscribe. I know where to come in future when my technology and I are having a disagreement! Thanks so much.

  • @zigmundwriggs
    @zigmundwriggs Рік тому +2

    I absolutely love this video. Every year I get a pit in my stomach when I have to print labels for company holiday cards. The directions were easy to follow. Thank you Dave!

  • @MrSteve90266
    @MrSteve90266 Рік тому

    Very helpful and well done. I love the way you deliver your message. Clear, concise, and at an easy pace. I also like that you've broken up your presentation into easy to find sections. Cheers!

  • @connorfoley5459
    @connorfoley5459 Рік тому

    This was so incredibly helpful! I avoided this for a while because I thought the process would be much more daunting. thank you for explaining it in a way that was easy to understand!!

  • @suzyk08021
    @suzyk08021 Рік тому

    You helped so much letting me do my own labels for my wedding envelopes! It was so confusing trying to figure it out myself-
    Thank you very much Dave😀

  • @petedarr9250
    @petedarr9250 Рік тому +1

    Your tutorial is just what I had to do today. Thanks for the video Dave. 👍

  • @cynthialilly5855
    @cynthialilly5855 2 роки тому +2

    Every year my Christmas labels are a nightmare - this year I saved your video and it was a walk in the park!!! thank you so much!!

    • @irenemessina
      @irenemessina 6 місяців тому

      Every year I forget how to print my labels from Excel. Thank you for helping me print my labels once again!!!!

  • @johnmeacham7162
    @johnmeacham7162 3 роки тому

    Extremely clear and made no assumptions about prior knowledge. Many thanks

  • @alicetan7141
    @alicetan7141 2 роки тому

    Awesome Dave! You have saved my day. Thanks for your clear and precise instructions. Printed my boss's greetings card mailing successfully.

  • @donr8191
    @donr8191 4 роки тому

    You always cover important subjects and make them understandable....or easily corrected....Thanks !!

  • @marilynbaxter1626
    @marilynbaxter1626 9 місяців тому

    Very helpful! Great directions. I watched this 2 years ago with great success, so I came back for a refresher (and I'm so glad I did)!! Thank You!!

  • @susandavis2132
    @susandavis2132 2 роки тому

    Omg THANK YOU SO MUCH for making the task of printing labels for wedding invitations so easy!!!! Very clear and concise instruction! Best video out there on how to mail merge and print!

    • @DavesTechRescue
      @DavesTechRescue  2 роки тому

      Happy to hear my video helped! Congratulations :)

  • @kathleenclouse1397
    @kathleenclouse1397 3 роки тому

    Exquisitely simple directions! I'm so grateful for the instruction.

  • @kennethhaubert6301
    @kennethhaubert6301 3 роки тому +2

    Excellent, comprehensive instructions that covers a few quirks in MSWORD that drove me nuts for years. First, the process used by WORD is not nearly as intuitive as other functions. Also, the need to "insert merge field" has to be used and closed with each field as no mechanism to add spaces or punctuation. Even more helpful is his hint to use SHIFT/ENTER to start new line in label. Without this critical but hidden trick, WORD will space lines too far apart... EXCELLENT help. Finally, the hint to NOT use typical print command in WORD as this will only print first page... Follow tutorial and engage FINISH/MERGE tab to engage printing... great help!!!!

  • @theresakirsch9179
    @theresakirsch9179 3 роки тому +1

    This tutorial was awesome and very detailed. Highly recommend it!

  • @thomasdouglass8778
    @thomasdouglass8778 2 роки тому +1

    Wow! What a great video! Everything that you mentioned was very clear, concise, and paced quite nicely. You even put our minds at ease by covering the quirks that we run across in Word. Again, great job! Bravo! You now have a new subscriber. Well, back to my 2021 Christmas card list. Thanks again and God bless.

  • @rhodylanehoa7749
    @rhodylanehoa7749 Рік тому

    This info is just what I needed and Very Helpful! Thanks so much for your time!

  • @janetcorreia8130
    @janetcorreia8130 Рік тому

    Clear instructions - SO HELPFUL!! Thank you so much!!!!

  • @gajjfitch
    @gajjfitch 2 роки тому

    I have always been intimidated to print labels in excel/word but this video has made me think I can do it! Great directions!, and I'm a teacher so I appreciate it. Pretty intensive, but I'm gonna go for it.

  • @sheepishusername
    @sheepishusername 7 місяців тому

    This was a brilliant and very clear explanation with some small but critically important detail missing from other explanations. Thank you.

  • @jackiehafler6264
    @jackiehafler6264 Рік тому +1

    This was so clear and to the point. Excellent video 😊

  • @cynthiaamador5691
    @cynthiaamador5691 2 роки тому

    Thank you so much, I struggled for an hour trying to figure out the on line instructions. Your video was super helpful and easy.

  • @janacreek6184
    @janacreek6184 2 роки тому

    You are awesome!!! I’m retired and don’t use labels much anymore so It gets so confusing and I’m not very patient. You explain so clearly. You just saved me a headache. Thanks

  • @theresalanning5817
    @theresalanning5817 2 роки тому

    Dave, Thank you!! This video was so helpful! instructions were so easy to follow!

  • @carlabrutico6978
    @carlabrutico6978 2 роки тому

    Excellent tutorial, Dave. Very well done. I have tried previously to make labels from Excel without success. This is awesome!

  • @evarae7531
    @evarae7531 2 роки тому +1

    Thank you so much! Exactly the instructions I needed and you explain in a way that makes it super easy to follow! Perfect thank you again!

  • @richardwilhite8316
    @richardwilhite8316 Рік тому

    Thank you. A very easy to understand tutorial. First time I've ever used an Excel spreadsheet to merge with Word in order to create labels. Never would have figured it out but with the tutorial, very simple. Thanks.

  • @srjackiejean-mariegitonga7186
    @srjackiejean-mariegitonga7186 2 роки тому

    Wonderful job! Thanks for the clear explanation. I was finally able to make labels from Excel! Thanks and God bless you!

  • @barbarapayne4964
    @barbarapayne4964 Рік тому

    Thank you so much for creating this video! Your step-by-step directions were perfect!

  • @margaretfederal7378
    @margaretfederal7378 11 місяців тому

    Your easy instructions were indispensable. Thank you so much and keep up the great work!

  • @mikeschumacher9715
    @mikeschumacher9715 2 роки тому

    Once you get past the mundane business of purchaser and ordering, etc....this was spot on. Thanks for the help mate.

  • @shashidharkamath7817
    @shashidharkamath7817 Рік тому

    Very clear and informative for Normal computer users like me. Helped me when I needed it most

  • @conniethomas1622
    @conniethomas1622 2 роки тому

    Thank You so much!! You are an amazing teacher. Thank you for going slow and explaining everything. VERY HELPFUL!!!

  • @sharonkennedy8701
    @sharonkennedy8701 Рік тому

    You've taught an old dog new tricks! Well done, you! Your instructions are so clear. Thanks so much!!😀

  • @CatRolfesMusic
    @CatRolfesMusic 3 роки тому

    Really appreciate this!! I was on the phone with Avery and they were not able to help me essentially do what you just showed how to do. Thank you!

  • @NBBCLU
    @NBBCLU Рік тому

    Thank you for saving me hours and hours of typing!!! Your video was very accurate in its instructions.

  • @G_Boom
    @G_Boom 3 роки тому

    I watch a couple of videos and saw yours. I then came back to it and did it along with it (pausing several times) until I got it right. Everything came out perfect, thanks.

  • @bobdyer1010
    @bobdyer1010 Рік тому

    Great info! Exactly what I needed. Clear and nicely paced. Bravo!

  • @mistybishop-martiss4565
    @mistybishop-martiss4565 3 роки тому

    Thank you! This is the best video I have found to walk me through this!

  • @inhybridmoments
    @inhybridmoments 3 роки тому

    Extremely helpful and easy to follow tutorial. Much appreciated.

  • @sharonavery8347
    @sharonavery8347 2 місяці тому

    What a clear and concise presentation! This is exactly what I need. Thank you!

  • @joannroskoski199
    @joannroskoski199 2 роки тому

    Thanks so much. Very straightforward and easy to understand. Next step getting blank labels and following the instructions.

  • @Tritonspring
    @Tritonspring 3 роки тому +1

    This worked REALLY well for me. Great job. Thank you!!!

  • @1955Reach
    @1955Reach 3 місяці тому

    Absolutely what I needed - Thank you!

  • @terrybingham325
    @terrybingham325 Рік тому

    Thank you! This was very involved and you helped every step of the way and did not leave anything out. Not too fast. Excellent tutorial!

  • @rogerbick6437
    @rogerbick6437 Рік тому

    Wow! Super Helpful. I tried understanding how to print labels from an excel file using microsofts written and cryptic videos. I was a waste of time. Dave's Step by Step approach was clear and led to success. Since I do not print labels but once a year or less having this instruction was wonderful. Thanks.

  • @mikebower5811
    @mikebower5811 Рік тому

    Thank you so much! Your video was the only one of many, that worked for producing labels i needed from Excel.

  • @lisadoxey7563
    @lisadoxey7563 2 роки тому

    Thank you for making this simple!! 💜

  • @letyt8175
    @letyt8175 3 роки тому

    Followed your steps exactly and it worked! Ty!

  • @kathyh.1720
    @kathyh.1720 Рік тому

    This was fantastic! Thank you! I'd looked at other things to learn how to do this, and they skipped steps or just didn't make sense to me. You went step by step, and I followed along and my results were just what you said I should get! Yea! Thank you SO MUCH!

  • @alecia175
    @alecia175 2 роки тому

    Excellent job, very clear and direct instructions. Very much appreciated.

  • @mikegoodman9276
    @mikegoodman9276 2 роки тому

    Thanks Dave. Not the simplest thing to remember but managed with your superb instructions.

  • @tinathaotran2795
    @tinathaotran2795 2 роки тому

    THANK YOU so much for making the video. The last time I created a mail merge document is more than 10 years ago. I remembered some steps but I was struggled to create a final product. Your video saves me.

  • @FrannyPancakes
    @FrannyPancakes 3 роки тому +1

    This video was insanely helpful! Thank you so so so much!

  • @katherinecunningham2466
    @katherinecunningham2466 4 місяці тому

    Excellent instructions! Thank you very much! My labels came out perfectly.

  • @harryeyre4714
    @harryeyre4714 2 роки тому

    Even though this video is a few years old, it was EXCELLENT for my education. It worked like a champ!

  • @cooktoy1
    @cooktoy1 Рік тому

    Best tutorial, just made my Christmas Card Labels, Thanks and Merry Christmas!

  • @donnagabler2609
    @donnagabler2609 Рік тому

    wonderful simple instructions and easy to understand. Great speaker .

  • @AmyBluntRealtor
    @AmyBluntRealtor 3 роки тому

    So appreciate this tutorial! Quick and easy to follow along!! THANKS

  • @jimmoon87
    @jimmoon87 6 місяців тому

    Dave, thanks so much. Excellent explanation with details and good pacing.

  • @leahstewart6979
    @leahstewart6979 2 роки тому

    Excellent, easy to follow video. Thank you!

  • @shannonbarnhart388
    @shannonbarnhart388 2 роки тому

    Thank you! This video was SUPER HELPFUL!!!!!

  • @andriaking5302
    @andriaking5302 2 роки тому

    Perfectly explained! Thank you!

  • @vinoawilson1049
    @vinoawilson1049 Рік тому

    This tutorial was helpful. It saved me a lot of typing. Thank you so much for such a detailed tutorial.

  • @hellokandykatz
    @hellokandykatz Рік тому

    thanks Dave - this video was so helpful - I had issues using Avery's template, and this saved the day. Happy Holidays!!

  • @alisonderham1529
    @alisonderham1529 Рік тому

    Thank you so much for this. Clear and concise and worked perfectly.

  • @Lovforu2
    @Lovforu2 3 роки тому

    Great info. I like the way you keep it concise and straight to the point..

  • @michellelopez9564
    @michellelopez9564 Рік тому

    Thanks. I've never ever printed labels before. Thank you for making it so easy to follow you.

  • @marytunney1108
    @marytunney1108 6 місяців тому

    Thank you! Very helpful and easy to follow. I especially needed the step to remove the space between lines! So helpful!