Oof. Every year Christmas I get to the part where I want to print the labels to put on the envelopes to hand people their checks and every year I have cycled through the Avery instructions, visited the internet, hoped that somebody else would do it and at last!!! I found these instructions. Simple. Clear. They work. Thank you thank you thank you.
You have done an excellent job with your instructional video. I can't believe Microsoft would develop such a convoluted path to develop labels. Without your excellent video, I never would have figured it out. Thank you. Good job.
Thank You for producing this vid! I've been so intimidated by this task for so long and thanks to your video, I am putting out labels to help my non-profit. Thanks again!
Thank you so much! I had already wasted two days trying to figure this out. I don't know why making labels from a database seem so hard. Then I found your four-minute instructional video. Your explanation and illustrations are terrific. You saved my sanity, thank you!
Thank you for a concise and thorough explanation. I was very frustrated trying this on my own but your explanation helped me get it right on the first try.
Nice job explaining this. I have always had trouble doing all the steps correctly and your video helped me print labels in one try. Thanks for your time and effort to make this. I appreciate it.
Thanks so much. Been an Admin for years and just couldn't take not knowing this anymore! One issue was the large space between the 3 rows: Name, Address, City, State, Zip but that's for another day.
Any advice how to update the labels if you were to save, then add more to the spreadsheet. For example if I have a client list and create these labels and save as a word doc. When I add 100 more clients do I need to start a new one or can I simply update the existing word label file? Thanks!
Thank you! can you only do 30 addresses at a time? I have a mailing list of about 150 and when I get to Finish and Merge my Microsoft freezes. I made another excel with just 30 and it worked. Is there a way to do more?
Nice... Easy .. EXCEPT that when printing, by the bottom of the page ... the text is no longer aligned with the label. and Microsoft Help is NO HELP! I am using Avery 8161 label and template. (Actually, the first row of labels ride "low" to the label and the text bottom labels ride high. Are the margins wrong in the template that mage it go wrong?
I wonder if you could help me. I have Avery file folder labels 8926 however apparently they dont make that one now. I would like to use them as am setting up my files finally and I am a senior and not great at computer stuff. Is there any way to be able to use them I have Windows 10 on my computer. I would really appreciate any help you can offer.
I would be more than happy to help. Can you take a picture of your avery file folder labels 8926 so i can see the front of it and the size of each label and # on each page.
Your much appreciated presentation was helpful, efficient, effective, and informative -- NICELY DONE! And Thank You sir! I wish you, your family, and all your endeavors the best and that you remain healthy and well.
Hi. I was wondering how I can print some names off of the spreadsheet, but not every person every time? What if I send one person 10 pieces of mail a month where somebody else only gets one? Thanks for the great video
Great simple, easy-to-understand instructions. My question - how or when in this process do I change the format of the merged data. I would like to change the font and size and have different fonts and sizes for the fields. Thank you. I think I figured it out. I'll make all the font and size changes in Excel.
I was hoping to find a complete tutorial. In another video they mentioned about editing the options and setting the printer (inkjet or laser) but they didn't explain it completely. Thanks for the upload though.
Before I print all addresses from excel,where can I get the access to all addresses let’s say I want to sent my post cards to desired areas,how can I get the zip codes with address
How can I save this as a format for future mailing lists? (i.e. not have to select fields and format each time if not changing, just the recipients list).
Hi Christopher, great video. I’d like to learn how to make 60mm round thank you labels that I put on clothes that I sell on eBay. Currently I’m buying them on Etsy and they are super expensive. Can you help me. Thanks
![Blox Fruits Dragon Rework Update [Full Stream]](http://i.ytimg.com/vi/EqDAp8udhm0/mqdefault.jpg)
Everyone tried showing me weird ways and manually adding each address into a label. This is the BEST way to do it!!! Thanks!!!
So glad I could help!
Hands down clearest and easiest directions. Thanks so much.
thank you I appreciate your comments
I haven't created labels in years. Your tutorial was just what I needed as a refresher. It was very helpful in helping me remember the process!!
Thank you so much. I appreciate your kind comments.
Oof. Every year Christmas I get to the part where I want to print the labels to put on the envelopes to hand people their checks and every year I have cycled through the Avery instructions, visited the internet, hoped that somebody else would do it and at last!!! I found these instructions. Simple. Clear. They work. Thank you thank you thank you.
you have no idea how much i wish i came across this video a week ago before i sent out all my holiday cards lol great video
Thank you for this clear explanation!
Nevermind, I just figured it out. Thank you for this video! It is so much appreciated.
You saved me today..I had no clue what to do to print the labels!!!Thank you sooo much...Thank God for you and RUclips!!
God bless you for being simple, succinct, quick, easy, clear.
Thanks for your kind comment
You have done an excellent job with your instructional video. I can't believe Microsoft would develop such a convoluted path to develop labels. Without your excellent video, I never would have figured it out. Thank you. Good job.
Thank You for producing this vid! I've been so intimidated by this task for so long and thanks to your video, I am putting out labels to help my non-profit. Thanks again!
After hours on this issue and many tutorials I was at an impasse, then your video solved it all---thanks a ton!
Thank You for watching
Best explanation of how to use Avery products I think that’s far, thank you
Thankyou. I haven't had access to Microsoft office software, for several years and really a refresher, your video was very helpful. Thankyou.
Thank you for the kind comments
Best instructional video of how to create labels EVER!! Thank you. I was done in like 5 minutes.
Very good demonstration, I hated doing Christmas labels each year, but you have made it easy to follow.
Word 2016 has issues. I was about ready to cry, but you saved the day. Thank you:))
Glad I could help!
Thank you for this well made tutorial. This has been a big help and I now have no more excuses.
Thank you for your kind words
@@TECHTOKDOC Keep up the great work :)
It's amazing at how many people need help with this. Thanks for posting this! Very helpful
Thank you so much! I had already wasted two days trying to figure this out. I don't know why making labels from a database seem so hard. Then I found your four-minute instructional video. Your explanation and illustrations are terrific. You saved my sanity, thank you!
Thank you so much! You have SAVED MY CHRISTMAS!!!! I was able to follow along and get my new label document created l, printed and saved. Yay!!!
Awesome Glad it Helped
You are a SAINT for creating this & offering to help others! Thank you so so so much!
Thank you for a concise and thorough explanation. I was very frustrated trying this on my own but your explanation helped me get it right on the first try.
Thank you for your kind comments
Thanks for the concise explanation. You saved me lots of time setting up my labels.
Hi Chris, Thanx for the nice tutorial. I added a "comma" and "space" after the "City" Merge Field
this is the easiest you tube to understand EVER! Thank you so much!
Nice job explaining this. I have always had trouble doing all the steps correctly and your video helped me print labels in one try. Thanks for your time and effort to make this. I appreciate it.
Well done!! As noted in previous comments, you saved me in hours in making this happen. Why would anyone give you a "thumbs down"?
Thank you for your kind comments. If there is anything else I can explain let me know. Thanks again
Exactly what I needed, I've never used excel before. I had no issues completing. Thanks!!!
Thank you so much for an excellent video. I hadn't made labels in a long time and yours was perfect.
This was an absolute God-send. Thank you!
THANK you. I appreciate your comments.
Thank you so much for taking the time to put this out there!!
Thank you !
Great explanation! Very helpful!
Very nicely done. I was able to generate my labels without a problem. Thank you for presenting this so clearly.
Thanks so much. Been an Admin for years and just couldn't take not knowing this anymore!
One issue was the large space between the 3 rows: Name, Address, City, State, Zip but that's for another day.
Your welcome
How can I print my full list? it is only giving me one page of labels and not all the entries in my excel list
@@clarestokolosa x2
Thank you the label temple that I had was messed up by a coworker this worked perfectly!! Thanks
Thank you very much MD TECH. Your tutorial was so useful. God bless you!
You are very welcome. If I can help in any other way please let me know!
Great job, a colleague needed help with this and I sent your video to him as a resource!
A perfect explanation! Thank you for saving me hours of frustration!
Your videos are amazing!
Thank you so much! The last time I needed to do his was eons ago and you made it easy for this dinosaur !
Thank you soo soo much. I’m sending out my wedding save the dates and I did not want to write out the addresses. This saved me so much time.
Thank you for the video. I want the addresses to single spaced, not double spaced, how do I change that?
Exactly what I needed! Thank you!
Thanks for the video.
My Word program doesn't have the labels that I use (5160) in the option box. How do I add Avery labels to the options list?
Oh my goodness!!! Thank you for this awesome video!!! I was about to pull my hair out!!!
YOUR WELCOME!
Thank you so much for this! You made Christmas card season so much easier! Not sure what I would have done otherwise!
Any advice how to update the labels if you were to save, then add more to the spreadsheet. For example if I have a client list and create these labels and save as a word doc. When I add 100 more clients do I need to start a new one or can I simply update the existing word label file? Thanks!
THIS WAS AWESOME!
How do I get it to not print on both sides?
I need to add a comma after the city. How do I do that in all of my labels? Thanks!!
Thank you! can you only do 30 addresses at a time? I have a mailing list of about 150 and when I get to Finish and Merge my Microsoft freezes. I made another excel with just 30 and it worked. Is there a way to do more?
Hey, I got a question. How do I print my Avery that I already created and save on my computer.? Can you make a video on that please?
If I have 30 labels and I only need 3 specific addresses, do I need to fill 30 areas in order to get all labels covered or just 3?
This is so close to what I need. Is there a way to insert images instead of an actual address?
Let me look into it for you thank you
@@TECHTOKDOC I appreciate it!
Great video, quick and easy explanation thank you
Thank you. I appreciate your comments.
Thank you for making this video. Very helpful.
Excellent Video, very detailed. Much appreciated. Thank you so much, Christopher!!!
Thank you. I appreciate it.
Thank you- much appreciated 🙏
Very helpful thank you!
Can I do this with good sheets?
You know how to teach , thank you sir.
Thank you so much , very well explained. I’m printing off labels now... yay
Glad to hear! Please share!
Nice... Easy .. EXCEPT that when printing, by the bottom of the page ... the text is no longer aligned with the label. and Microsoft Help is NO HELP! I am using Avery 8161 label and template. (Actually, the first row of labels ride "low" to the label and the text bottom labels ride high. Are the margins wrong in the template that mage it go wrong?
Whoops .. Never mind ... I had a "print to fit" setting in my printer driver that was ignoring all actual settings! Problem SOLVED
can you have an image in a cell? a different image for each row from the XLS file
duder, not sure if anyone else has caught on, but there are times when you are speaking in this video - you sound exactly like Tom Cruise. very cool 😎
Perfect, wonderful explanation. Many thanks!
Great video. Clear and up to date.
Concise, up to the point and very clear
is there a way to alter the alignment? I have done each step but upon printing the name is on the seam of the sticker?
I wonder if you could help me. I have Avery file folder labels 8926 however apparently they dont make that one now. I would like to use them as am setting up my files finally and I am a senior and not great at computer stuff. Is there any way to be able to use them I have Windows 10 on my computer. I would really appreciate any help you can offer.
I would be more than happy to help. Can you take a picture of your avery file folder labels 8926 so i can see the front of it and the size of each label and # on each page.
@@TECHTOKDOC ok I have taken photo how do I send it to you? email? Thank you so much
CMBMD79@gmail.com
Hi, one question... I noticed that each of your address is double space. Can you change it to single space? Thanks for your video!
Yes absolutely I believe that is just the way mine was formatted. Thank you.
Great tutorial!
I got a question if you just need one label how do you do that
Your much appreciated presentation was helpful, efficient, effective, and informative -- NICELY DONE! And Thank You sir! I wish you, your family, and all your endeavors the best and that you remain healthy and well.
Hi. I was wondering how I can print some names off of the spreadsheet, but not every person every time? What if I send one person 10 pieces of mail a month where somebody else only gets one? Thanks for the great video
Thank you for this tutorial! You've saved me.
Great simple, easy-to-understand instructions. My question - how or when in this process do I change the format of the merged data. I would like to change the font and size and have different fonts and sizes for the fields. Thank you. I think I figured it out. I'll make all the font and size changes in Excel.
You're the best! Gracias
I was hoping to find a complete tutorial. In another video they mentioned about editing the options and setting the printer (inkjet or laser) but they didn't explain it completely.
Thanks for the upload though.
Do these labels work with a regular printer??
Before I print all addresses from excel,where can I get the access to all addresses let’s say I want to sent my post cards to desired areas,how can I get the zip codes with address
Very nicely explained! Really appreciate it.
Thank you so much!
How can I save this as a format for future mailing lists? (i.e. not have to select fields and format each time if not changing, just the recipients list).
I will have to try and test that and see if it is possible
Can I add a graduation cap to each label?
Seriously... thank you!
Thank. you
Very good tutorial
Thank you I appreciate your comment
You're a lifesaver! Thank you so much ❤️
Is there a way to alphabetize the labels by last name?
do you put the label in printer face up or face down?
That depends on your printer. Look at your printer to see if the sheet should go content up or content down.
How do I choose only one or a few names from excel spreadsheet to make address labels instead of the whole list?
Thank you! very informative!
Thank you, this video is so helpful.
running MS Office 2007 and Microsoft word has crashed 6 times when selecting an list from MS Excel, also 2007
Where and what do I do?
Sir, thank you so much for this video!
Hi Christopher, great video. I’d like to learn how to make 60mm round thank you labels that I put on clothes that I sell on eBay. Currently I’m buying them on Etsy and they are super expensive. Can you help me. Thanks
I have done that and will show you as soon as possible. It won't be till next week though or end of week
Please email me so I can talk to u on email and help you with your project. I actually found the ones I made!
Can you control the font?
I followed every step exactly but when I preview results it only does 4 rows and not the full 10. Why?
Let me take a look later for you
What are your margins set at and you are using the exact same avery address labels?
Very useful, thank you
When I print out the labels they don't fit in the box of the label sheet. (5160). Any suggestions?
I dealt with the same problem today. I had to adjust the size of the text in Xcel. Afterwords, I centered the text in Word. Frustrating for sure...