How to print mailing labels from Excel
ฝัง
- เผยแพร่เมื่อ 25 ก.ค. 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 - วิทยาศาสตร์และเทคโนโลยี
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.
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.
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!!
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!
THANK YOU! Your instructions were very easy to follow and at the perfect pace for me.
Excellent tutorial. He speaks clearly, and moves his cursor smoothly enough I could follow it easily. Again, EXCELLENT tutorial. Thanks!
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!
😂
I won't 96 labels per page .how can I do?
Thank you for this wonderful step-by-step guide. Very easy to follow, and it worked perfectly the first time. Appreciate your clarity.
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!
Top tutorial !!!!
I wish everything on TH-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.
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!
I’m happy it helped!
This was tremendously helpful. Thanks so much. Clear and concise and easy to follow. Good job!
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!
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.
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
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! !🙂
Dave, I come here twice a year for my mailings. Without you, it would not get done. So easy to understand and follow.
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!!
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.
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!
So helpful! I've tried printing labels so many times in the past, and this was my first success! Thank you!
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!
Perfect presentation. Absolutely the best TH-cam tutorial I have ever followed. Thank you!
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.
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.
Well thought out and explained in great detail. Thank you!
Saved me. Spent an hour on another tutorial and it never worked. I needed a good Englishman to help sort me out. Cheers Dave!!
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.
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!!
Every year I forget how to print my labels from Excel. Thank you for helping me print my labels once again!!!!
This tutorial was awesome and very detailed. Highly recommend it!
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.
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. 👍
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😀
Exquisitely simple directions! I'm so grateful for the instruction.
Thank you, Dave! Great video. It was clear and east to understand.
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!!!!
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!
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.
Your tutorial is just what I had to do today. Thanks for the video Dave. 👍
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!
This video was insanely helpful! Thank you so so so much!
Thank you! This is the best video I have found to walk me through this!
You always cover important subjects and make them understandable....or easily corrected....Thanks !!
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!
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!
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!
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!
Happy to hear my video helped! Congratulations :)
Awesome Dave! You have saved my day. Thanks for your clear and precise instructions. Printed my boss's greetings card mailing successfully.
Great info! Exactly what I needed. Clear and nicely paced. Bravo!
Thank you so much for this. Just what I needed!!
So appreciate this tutorial! Quick and easy to follow along!! THANKS
This was so clear and to the point. Excellent video 😊
Excellent tutorial, Dave. Very well done. I have tried previously to make labels from Excel without success. This is awesome!
THANK YOU! This was so helpful and I appreciate it!
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!!
This is an excellent tutorial! Thank you very much. It is exactly what I needed!
Dave, Thanks for a very comprehensive explanation with a couple of tips I didn't know. Something you might like to know is that if you use the Shift Return trick, you can't edit the result because you are left with a large gap in the resultant labels at that position. Also the editing and reuse of the label does depend on you saving the label!
Thank you! This was straight forward and easy to follow. Super helpful!
Very well done. Good attention to detail. Easy to follow and logical presentation. Thank you.
I have wasted time trying to learn from other sources how to do this. You're video is the Best! Works well.
Great info. I like the way you keep it concise and straight to the point..
Thank you! This was very detailed, helpful, and easy to follow.
Extremely clear and made no assumptions about prior knowledge. Many thanks
Extremely helpful and easy to follow tutorial. Much appreciated.
Clear instructions - SO HELPFUL!! Thank you so much!!!!
Your easy instructions were indispensable. Thank you so much and keep up the great work!
I fixed it and completed the labels. You are fantastic!
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.
This info is just what I needed and Very Helpful! Thanks so much for your time!
Super helpful. in 5 minutes i had my labels printed. thank you so much.
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.
This worked REALLY well for me. Great job. Thank you!!!
Thank you so much for creating this video! Your step-by-step directions were perfect!
Clear, concise tutorial. Thank you!
Excellent job, very clear and direct instructions. Very much appreciated.
I feel like this is going to help me a lot when i need to print my labels for my save the dates thank you!!!
Wonderful job! Thanks for the clear explanation. I was finally able to make labels from Excel! Thanks and God bless you!
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!
Thank you so much! Your video was the only one of many, that worked for producing labels i needed from Excel.
You've taught an old dog new tricks! Well done, you! Your instructions are so clear. Thanks so much!!😀
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!!
Absolutely what I needed - Thank you!
Thanks Dave. Not the simplest thing to remember but managed with your superb instructions.
Once you get past the mundane business of purchaser and ordering, etc....this was spot on. Thanks for the help mate.
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!
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.
Thank you so much for this. Straight to the point!👍🏼
Followed your steps exactly and it worked! Ty!
Thanks so much! Your tutorial worked perfectly for me. Christmas address labels are all done. New subscriber!
Thank You so much!! You are an amazing teacher. Thank you for going slow and explaining everything. VERY HELPFUL!!!
Hi Dave, thank you so much for this video. You saved my bacon at work! Much appreciated.
What a clear and concise presentation! This is exactly what I need. Thank you!
Excellent Job, Dave!! Thanks!!
Exactly what I was looking for, thank you!!!
Thank you so much, I struggled for an hour trying to figure out the on line instructions. Your video was super helpful and easy.
This was a brilliant and very clear explanation with some small but critically important detail missing from other explanations. Thank you.
Thank you for making this simple!! 💜
Thank you! Very helpful and easy to follow. I especially needed the step to remove the space between lines! So helpful!
Dave, Thank you!! This video was so helpful! instructions were so easy to follow!
Great tutorial! Thanks Dave!