Best tutorial I've seen!! Every year I go to print Christmas labels and I search for the instructional video or instructions to do it and every year I struggle. Not this year!! I have saved this video and will refer to it time and time again! Also loved the little tidbits nobody else has ever passed along like changing the cell margins and spacing between lines. Bravo!
This is exactly what I needed. When I last searched for this information, the demonstration used the wizard and that did not work for me. I needed the full process. Thanks again!
I have continue to use your Mail Merge tutorial to produce my labels….always works….except the one time I used italics in one of the Excel fields. Although all the text in each cell was in italics, when merged with the Word Mail Merge program, the italics were not recognized and the font was the normal Arial type…just as you see in this note. If there is fix or work-around for this issue, could you make a video about it? All RUclips searches just deal with number formats or converting numbers to text….Thank you very much…
Can this method of creating labels be used with different size labels, such as with Avery label 5366 or 5262? Your video was very clear and easy to follow. Thank you
First thanks for information, very helpful. My question to you, is there a way to insert from excel by just highlighting the People that i want to include in the labels ? I have quite of few people i don't want to include in this print. Thanks
If one adds a column for print qty, is it possible to map the functionality to print more then one label per row of data based on the cell value in that colum for that row? 🤞
Since you are so knowledgeable in both Excel AND Avery, I have an Excel Sheet where, through an AD-on (QR4Office), I have generated QR Codes specific to each Excel Line. Would the Mail Merge function permit the associated QR Code to be merged into each label as well? I see in your example the 6 Fields of Text that you have merged sequentially to each label on the the left side of the labels. Can a generated QR Code be imported and placed on the rights side say through a designated framed box or other placement technique? Great videos by the way!!
@ChesterTugwell... or any. Can you give me tips of why the moment I export the Excel list into Word it only shows me 1 (ONE) page with names on the labels layout? I have more than 1000 names to print but it only shows the first 30.!!!!!! Please help me. What am I doing wrong???
I have one questions. I followed your list and created a list in Excel for my 90 clients for chrstimas. I followed everythign but word created 32 pages of duplicates and just big mix up instead of 3 pages that were needed (30 per page) please help. What am i doing wrong?
You just saved me blood, sweat, and oh, so many tears. Bless you.❤
Best tutorial I've seen!! Every year I go to print Christmas labels and I search for the instructional video or instructions to do it and every year I struggle. Not this year!! I have saved this video and will refer to it time and time again! Also loved the little tidbits nobody else has ever passed along like changing the cell margins and spacing between lines. Bravo!
This was one of the most thorough and helpful tutorial's I've seen in a long time! Thank you!
That was EXCELLENT! I spent 2 hours trying to print labels and just watched this great video and it got the job done!
You by far explained the merge/label process the best!!
As others have said, you just saved me about 154 years of my life lol. Thank you!
FANTASTIC VIDEO!!!! Precise and to the point, very helpful!
😎
Super easy tutorial and exactly what I was looking for! Thank you so much!
At work and the shipping person doesnt know how to do her job, so i needed a refresher course to do it for her 😊 this was perfect!
1 word.. Perfect!
This was the best how-to video. It literally covered every issue I was having. Thank you!!
Direct and straight to the point. Thank you for the Tutorial.
Absolutely brilliant video - very clear and easy to follow. Thank you so much.
Thank You!
You explain very well. Easy to understand.
Glad it was helpful!
Step by step directions. Easy to follow and understand.
You are an amazing instructor. Thank you so much !
Yours is one of the better vids on how to use mailmerge features.
Easily showed me how to do it! Simple and quick. Thank you!
Great tutorial... Success after many tries.. Chester is awesome!!
Excellent - Clear, precise, easy, fast - THANK YOU!
This is exactly what I needed. When I last searched for this information, the demonstration used the wizard and that did not work for me. I needed the full process. Thanks again!
Great video on how to convert an excel into MS Word for an Avery Label sheet.
Thanks for taking the time to do this. Great little tutorial to get off the ground.
Great tutorial! Exactly what I needed. Thank you for being so thorough.
Thank you so much!! Super helpful. Works perfect!!
Fantastic Help, Thank You!
Best tutorial on this topic. Thank you.
Best ever! Thank you so much for doing this! It helped me so much!
Could done with this a month ago. I was going round in circles then. Thanks for the clear explanation.
Thank you - thank you - thank you! Very clear instructions! Was going around in circles - again thank you!
Glad it helped!
Perfect. Fast, easy, exactly what I needed.
Very well explained!
Thank you for the help! You made it very easy!
Very Best - you have saved me hours of frustration
Very helpful and clear. It was just I needed. Thank you
Thank you! This was great.
Thank you very much. Worked like a charm!
Great job - clear and concise
Such a great explanation! I was stressing out adding one by one!! ❤
thank you, one step and I just couldn't have done it without you!
Best tutorial! Thank you so much for your help!
Awesome video, used this to do some direct mail marketing for my business.
Thank you very much.
Thank you soooo much for the detailed step by step. Well articulated!
Awesome. Thank you!
THANK YOU! This was the video I needed!!
Thank you sir.....helped me lot....
Great tutorial
Gracias! saludos desde Ciudad de México.
I have continue to use your Mail Merge tutorial to produce my labels….always works….except the one time I used italics in one of the Excel fields. Although all the text in each cell was in italics, when merged with the Word Mail Merge program, the italics were not recognized and the font was the normal Arial type…just as you see in this note. If there is fix or work-around for this issue, could you make a video about it? All RUclips searches just deal with number formats or converting numbers to text….Thank you very much…
Excellent tutorial
Thanks! I'm just working out how to set up some formatting and once that's done it looks like 1-2 days worth of data entry saved. Thanks!
very good, just what I was looking for
Do you have a video on what to do before the step of word. Do you just save the excel file and then do the mail merge or are there steps to do before.
Hi Chester, awesome tutorial! When I printed most pages were full but some came out half printed or with just a few addresses on, why did this happen?
Can this method of creating labels be used with different size labels, such as with Avery label 5366 or 5262? Your video was very clear and easy to follow. Thank you
Awesome Mr T 👍👏👏
First thanks for information, very helpful. My question to you, is there a way to insert from excel by just highlighting the People that i want to include in the labels ? I have quite of few people i don't want to include in this print. Thanks
Excellent. Thanks
Perfect. Thank you!
exactly what I needed thanks!
wow, that was easy. What else can you teach us? Great job!!
Thanks!
Very helpful! Thank you
You’re a godsend
Thank for making this!!
No problem!!
great this is what i needed
Thank you!
thanks bro this really helps
exactly what I needed!
Thank you so much!!
This was perfect!
Thank you! Why did only 1/4 of my addresses transfer over from Excel to only fill one Word page worth?
Thank you !!!!!
Good tutorial but I cannot find my label product number. Is it possible to update the product number list in word?
If one adds a column for print qty, is it possible to map the functionality to print more then one label per row of data based on the cell value in that colum for that row? 🤞
Since you are so knowledgeable in both Excel AND Avery, I have an Excel Sheet where, through an AD-on (QR4Office), I have generated QR Codes specific to each Excel Line. Would the Mail Merge function permit the associated QR Code to be merged into each label as well? I see in your example the 6 Fields of Text that you have merged sequentially to each label on the the left side of the labels. Can a generated QR Code be imported and placed on the rights side say through a designated framed box or other placement technique? Great videos by the way!!
Good tutorial but I can only see the first page in the xcel file even when I change the print areas. What am I doing wrong.
P-E-R-F-E-C-T
Is there a way to include the title on the label too? Like, Name: Chester Tugwell, Address: XYZ ???
nsweet video thank you
what about if there are fields in the Excel you want to not print as blanks in the label?
@ChesterTugwell... or any. Can you give me tips of why the moment I export the Excel list into Word it only shows me 1 (ONE) page with names on the labels layout? I have more than 1000 names to print but it only shows the first 30.!!!!!! Please help me. What am I doing wrong???
I have one questions. I followed your list and created a list in Excel for my 90 clients for chrstimas. I followed everythign but word created 32 pages of duplicates and just big mix up instead of 3 pages that were needed (30 per page) please help. What am i doing wrong?
My Avery 5160 labels are 4 columns across. When I print, the left column is "squished" How do I correct this?
I get right up to Preview Results and draw a blank page. Any ideas?
What if I want to print the same address several times on each page?
Create the appropriate number of copies in excel by duplicating the row.
May i know the purpose of this email lables in word
I wish someone could tell me why this doesn't work for me? I get blank labels!! Ughh
Question--why did only 30 insert into the 1 page of labels? I actually have 37 addresses in the document?
Because the labels are only 30 per page
ini my Laptop doesn't appear like that, please tell me Why?
This only created the first page which contains 30 labels. I have to print 334 addresses. Where are the rest of the labels?
No fuss. Other videos were nearly 20 minutes long and I thought, it can't be that hard. It isn't.
wont show "next record"
This was very concise and extremely helpful. Just what I needed! Thank you!!!
EXCELLENT tutorial! Very easy to follow. Thank you!!!
Thank you!!!