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.
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.
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!
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!!!!
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!
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.
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!
Hi Dave, thank you for making this great video, can you please tell me the steps to print the rest of the pages ? as finish & Merge ---> print doc will onl print 1st page, thank you
Hi Dave very useful video. Thank you!!! Any idea why I dont get all labels with "Next Record" except from the first? I just get a blanc page only marked...
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!
Hi Dave, great video. If some addresses have 4 lines and others only have 2 or 3 is there a simple fix to get rid of the gap between lines, i hope i am explaining this properly . Thanks for your help.
Thanks! I have found the same problem with some addresses. I think I have found a good solution: After you have done Select Recipients and Edit Recipient List, you need to go back to the Home tab. In the 'Styles' section, you should see Normal selected. You need to select No Spacing instead. Now follow the rest of my video - except where I say you need to press Shift and Enter, just press Enter. When you get to the end, it should produce labels with no spaces where the line is empty. Let me know if it works!
@@DavesTechRescue Hi Dave, Thank you so much for your quick reply. Your solution worked perfectly and will make things so much easier for me and I really appreciate it. I have subscribed and wish you all the best in your TH-cam career!!
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.
You saved my wedding invitation process!! I was afraid to even try but writing an address on each one wasn't worth the hassle. Thank you! I'm saving this to my favorites!
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.
At about 5:00 into your presentation, you give instructions for selecting recipients. When I select 'use an existing list' on my Mac and select the Excel file, a popup message appears warning me of a security risk. Since I am confident my file is not malicious, I select 'yes' to proceed. Then a popup menu appears showing the Excel document I'm opening and it asks for a 'cell range.' The half-tone default is 'entire worksheet.' Whether or not I accept that or enter a cell range, I can not access 'edit recipient list' following this step. I'm stuck here...
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.
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.
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!
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.
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!
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
At the 4 minute mark, you suggest selecting a label so i picked Avery L7160 which was on the list. When I click the sheet is still blank. When I include recipents I get a pop-up for 'Select Table' showing Sheet1$ thru Sheet5$. I didn't see that in the tutorial.
Hi Dave, You saved us again this year on printing Christmas Card labels that we only do once a year. Thank you for your video it is easy to understand since we only do this once a year!
Thank you for the tutorial! Every year, when it comes to printing addresses for my Christmas cards, I forget how to to do it. When I search for instructions on line, they often leave something out. Your lesson was well paced, clear, and understandable. I have bookmarked it so that I can return to it when I forget the next time.
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! !🙂
So very helpful! I desperately needed to do this today and done and dusted. One question, if I want to print one page of labels from that spreadsheet, how is this done as I can't see it in preview. help please
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.
Very good video - The challenge with not using Avery 7160 labels but a stationery store similar product is a mm here or there can wreck your labels. I am using Word 2013 and the controls for the leading are pretty pants. Thanks for sharing your content.
Hi Dave, thanks a lot for this tuto, it was very clear to me and help me to create my labels in a few minutes. You saved my evening ! All the best for 2022. Diane
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!
very instructive video. Thank you. I have a question about my HP Pavilion with windows 10 Pro version 1903. When I press system shutdown or hibernation, the screen goes off, the disk stops, but the on / off switch light illuminates until I press and hold the switch again to turn off the light. Only then the computer is completely turned off. I tried different settings but not the way that would fit my problem. Im asking for help. Thanks and best regards from Slovenia
Hi, I've seen an HP Pavilion with the same problem recently. Nothing I did would fix the problem, including updating the BIOS/UEFI. Are you able to contact HP support about this problem?
@@DavesTechRescue thanks for the reply, i might try to contact HP, but the error is still less annoying to me. if I find out, I'll let you know. thanks again and best regards
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 exactly what I was looking for, but as an additional step, please would you be able to explain how - if I import a list of names and addresses & the address comes across as one column- is there an easy way to split the address up into the different columns like your layout in the tutorial? Thanks
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.
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.
I have wasted time trying to learn from other sources how to do this. You're video is the Best! Works well.
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.
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.
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!!!!
I have Microsoft 365. I hit to mailings and there isn’t an “options” to open. I found labels under Create . Glad I found your site!
You've taught an old dog new tricks! Well done, you! Your instructions are so clear. Thanks so much!!😀
Thought you were very easy to follow, no fuss just straightforward tuition. Thank you.
Even though this video is a few years old, it was EXCELLENT for my education. It worked like a champ!
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!
Your tutorial is just what I had to do today. Thanks for the video Dave. 👍
Thank you so much, I struggled for an hour trying to figure out the on line instructions. Your video was super helpful and easy.
Hi Dave, thank you so much for this video. You saved my bacon at work! Much appreciated.
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!!!!
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?
This was a brilliant and very clear explanation with some small but critically important detail missing from other explanations. 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!!
Very clear and informative for Normal computer users like me. Helped me when I needed it most
Thanks so much. Very straightforward and easy to understand. Next step getting blank labels and following the instructions.
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.
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!!
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!
Once you get past the mundane business of purchaser and ordering, etc....this was spot on. Thanks for the help mate.
I just want to thank you for making this process much easier for me to comprehend.
Excellent, I couldn't figure out why it was just printing the first page! 7:57 thank you.
Thanks. I've never ever printed labels before. Thank you for making it so easy to follow you.
thank you for this video was worth watching
THANK YOU! Your instructions were very easy to follow and at the perfect pace for me.
Hi Dave, thank you for making this great video, can you please tell me the steps to print the rest of the pages ? as finish & Merge ---> print doc will onl print 1st page, thank you
Hi Dave very useful video. Thank you!!!
Any idea why I dont get all labels with "Next Record" except from the first? I just get a blanc page only marked...
This tutorial was helpful. It saved me a lot of typing. Thank you so much for such a detailed tutorial.
So helpful! I've tried printing labels so many times in the past, and this was my first success! Thank you!
This may be an old video however the way you explain everything is fantastic, you made it easy to follow and learn. Thanks for the video.
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!
Hi Dave, great video. If some addresses have 4 lines and others only have 2 or 3 is there a simple fix to get rid of the gap between lines, i hope i am explaining this properly . Thanks for your help.
Thanks! I have found the same problem with some addresses. I think I have found a good solution:
After you have done Select Recipients and Edit Recipient List, you need to go back to the Home tab.
In the 'Styles' section, you should see Normal selected. You need to select No Spacing instead.
Now follow the rest of my video - except where I say you need to press Shift and Enter, just press Enter.
When you get to the end, it should produce labels with no spaces where the line is empty.
Let me know if it works!
@@DavesTechRescue Hi Dave, Thank you so much for your quick reply. Your solution worked perfectly and will make things so much easier for me and I really appreciate it.
I have subscribed and wish you all the best in your TH-cam career!!
This video is brilliant and so easy to follow, because of the excellent way you have presented it! Many thanks!😊
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.
Thank you! Very helpful and easy to follow. I especially needed the step to remove the space between lines! So helpful!
Excellent tutorial. He speaks clearly, and moves his cursor smoothly enough I could follow it easily. Again, EXCELLENT tutorial. Thanks!
You saved my wedding invitation process!! I was afraid to even try but writing an address on each one wasn't worth the hassle. Thank you! I'm saving this to my favorites!
Thank You so much!! You are an amazing teacher. Thank you for going slow and explaining everything. VERY HELPFUL!!!
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.
very clear, well presented - easy to follow - greatly appreciated
the extra about printing was very helpful -again - thank you for an fantastic presentation
Every Christmas I come back here to print my address labels. ❤😊
same!! haha
🎉🎉 same…
At about 5:00 into your presentation, you give instructions for selecting recipients. When I select 'use an existing list' on my Mac and select the Excel file, a popup message appears warning me of a security risk. Since I am confident my file is not malicious, I select 'yes' to proceed. Then a popup menu appears showing the Excel document I'm opening and it asks for a 'cell range.' The half-tone default is 'entire worksheet.' Whether or not I accept that or enter a cell range, I can not access 'edit recipient list' following this step. I'm stuck here...
Thank you so much for creating this video! Your step-by-step directions were perfect!
Nice job, Dave. I print labels so infrequently that I'll bookmark this and come back to it. again.
Dave, Thank you!! This video was so helpful! instructions were so easy to follow!
Thanks for the GREAT tutorial! I've been struggling with details on how to do this. You were very methodical and detailed!
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.
Thank you for saving me hours and hours of typing!!! Your video was very accurate in its instructions.
This is the BEST explanation on you tube ever. Can you please do all of them?!!
What a clear and concise presentation! This is exactly what I need. Thank you!
Awesome. Finally was able to convert the excel data into Word Labels. Thanks so MUCH!!!
Your easy instructions were indispensable. Thank you so much and keep up the great work!
Extremely clear and made no assumptions about prior knowledge. Many thanks
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! This was very involved and you helped every step of the way and did not leave anything out. Not too fast. Excellent tutorial!
Really easy to follow directions. Thankyou so much!
what fabulous tutorial! you made a list to print easier....many thanks
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!
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.
Thanks Dave. Not the simplest thing to remember but managed with your superb instructions.
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 :)
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
wonderful simple instructions and easy to understand. Great speaker .
Excellent tutorial. I have never understood why labels have to be so complicated with word/excel.
Wonderful job! Thanks for the clear explanation. I was finally able to make labels from Excel! Thanks and God bless you!
Brilliant - correct, clear, essential steps shown. Thank you
At the 4 minute mark, you suggest selecting a label so i picked Avery L7160 which was on the list. When I click the sheet is still blank. When I include recipents I get a pop-up for 'Select Table' showing Sheet1$ thru Sheet5$. I didn't see that in the tutorial.
Thank you. Needed a refreser course.
Hi Dave, You saved us again this year on printing Christmas Card labels that we only do once a year. Thank you for your video it is easy to understand since we only do this once a year!
Thank you for the tutorial! Every year, when it comes to printing addresses for my Christmas cards, I forget how to to do it. When I search for instructions on line, they often leave something out. Your lesson was well paced, clear, and understandable. I have bookmarked it so that I can return to it when I forget the next time.
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! !🙂
Very minor differences using Word on a Mac, but your tutorial made everything crystal clear. Thank you
So very helpful! I desperately needed to do this today and done and dusted. One question, if I want to print one page of labels from that spreadsheet, how is this done as I can't see it in preview. help please
This info is just what I needed and Very Helpful! Thanks so much for your time!
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.
You always cover important subjects and make them understandable....or easily corrected....Thanks !!
First timer making labels! Feel like a pro now! Thanks!
Very good video - The challenge with not using Avery 7160 labels but a stationery store similar product is a mm here or there can wreck your labels. I am using Word 2013 and the controls for the leading are pretty pants. Thanks for sharing your content.
Thank you so much, I was totally lost and thanks to your easy to follow video I was able to accomplish the task. Blessings.........
Hi Dave, thanks a lot for this tuto, it was very clear to me and help me to create my labels in a few minutes. You saved my evening ! All the best for 2022. Diane
Thank you so much! Your video was the only one of many, that worked for producing labels i needed from Excel.
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!
Thank you,
Your Presentation is characterized by careful reasoned thinking with heedful anticipation of the needs and wants.
very instructive video. Thank you.
I have a question about my HP Pavilion with windows 10 Pro version 1903. When I press system shutdown or hibernation, the screen goes off, the disk stops, but the on / off switch light illuminates until I press and hold the switch again to turn off the light. Only then the computer is completely turned off. I tried different settings but not the way that would fit my problem.
Im asking for help. Thanks and best regards from Slovenia
Hi, I've seen an HP Pavilion with the same problem recently. Nothing I did would fix the problem, including updating the BIOS/UEFI.
Are you able to contact HP support about this problem?
@@DavesTechRescue thanks for the reply, i might try to contact HP, but the error is still less annoying to me. if I find out, I'll let you know. thanks again and best regards
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!!
Thank you so much! I could not find anything online to help and this was perfect
This is exactly what I was looking for, but as an additional step, please would you be able to explain how - if I import a list of names and addresses & the address comes across as one column- is there an easy way to split the address up into the different columns like your layout in the tutorial? Thanks
Excellent, easy to follow, and useful video!
You saved the day! Clear, accurate and concise too! Big Huge Thanks!
This was so clear and to the point. Excellent video 😊
Thanks Dave, great & easy to follow step by step instructions. Thank you
Thank you so much for this!! I have used it several times and appreciate the detail and ease of it!
Excellent instructions! Thank you very much! My labels came out perfectly.
Thank you!! This was so easy to follow and it was so easy to complete! Thank you!
Awesome Dave! You have saved my day. Thanks for your clear and precise instructions. Printed my boss's greetings card mailing successfully.