Create Labels from a List in Excel | Mail Merge Labels from Excel to Word | Print Avery Labels

Click here to download the featured file: www.bluepecantraining.com/wp-...
In this video I demonstrate how to print labels from an Excel list. This can easily be achieved using Microsoft Word's mail merge feature. Microsoft Word includes built-in templates for labels such as Avery labels.
Table of Contents
00:00 Introduction
00:06 Set up your list of recipients in Excel
00:25 Select the correct label template in Word
01:18 Connect your labels to your Excel file
02:04 Insert merge fields into your labels
03:36 Add padding to your labels
03:58 Update all labels
04:10 Preview and print your labels
*************************************
------------------------

[@andreawymer2625]

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!

[@michaelmatthews2818]

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!

[@gracedavis1347]

You just saved me blood, sweat, and oh, so many tears. Bless you.❤

[@tmriley04]

Direct and straight to the point. Thank you for the Tutorial.

[@donnalandry4743]

That was EXCELLENT! I spent 2 hours trying to print labels and just watched this great video and it got the job done!

[@BaysideHousing]

This was one of the most thorough and helpful tutorial's I've seen in a long time! Thank you!

[@karendavenport2721]

You by far explained the merge/label process the best!!

[@kae146]

Super easy tutorial and exactly what I was looking for! Thank you so much!

[@subharmonicj8811]

Thanks for taking the time to do this. Great little tutorial to get off the ground.

[@user-lq4jv3gw6g]

Excellent - Clear, precise, easy, fast - THANK YOU!

[@alisastandley9237]

Great tutorial! Exactly what I needed. Thank you for being so thorough.

[@bexboster2174]

Perfect. Fast, easy, exactly what I needed.

[@user-cv3fk4uf3z]

This was the best how-to video. It literally covered every issue I was having. Thank you!!

[@vanessastafford5749]

This was very concise and extremely helpful. Just what I needed! Thank you!!!

[@tinplategeektoo]

Could done with this a month ago. I was going round in circles then. Thanks for the clear explanation.

[@GlitzyPixie]

Absolutely brilliant video - very clear and easy to follow. Thank you so much.

[@amartinez1513]

Best ever! Thank you so much for doing this! It helped me so much!

[@reneehansen8529]

EXCELLENT tutorial! Very easy to follow. Thank you!!!

[@Jan-oi3du]

Thank you soooo much for the detailed step by step. Well articulated!

[@parrisgjerde9212]

Thank you very much. Worked like a charm!

[@Homesbyhelenkburke]

FANTASTIC VIDEO!!!! Precise and to the point, very helpful!

[@ChesterTugwell]

😎

[@user-qq5or6tq3k]

Easily showed me how to do it! Simple and quick. Thank you!

[@laurieshanderson]

Thank you for the help! You made it very easy!

[@EkaterinaHagen]

Such a great explanation! I was stressing out adding one by one!! ❤

[@user-wq7bh8vx5m]

Awesome video, used this to do some direct mail marketing for my business. Thank you very much.

[@beatricerodriguez6645]

You are an amazing instructor. Thank you so much !

[@user-zm1cg2ug1h]

thank you, one step and I just couldn't have done it without you!

[@ProfessorBones2012]

Best tutorial on this topic. Thank you.

[@tonymanfredi7869]

Great tutorial... Success after many tries.. Chester is awesome!!

[@TEM14411]

THANK YOU! This was the video I needed!!

[@nettenet438]

Perfect. Thank you!

[@stephaniewhite6692]

Best tutorial! Thank you so much for your help!

[@amyhoneywell1041]

exactly what I needed!

[@michelecormier8160]

Great job - clear and concise

[@PaulGodfrey]

Excellent. Thanks

[@Salvatore218]

Very helpful and clear. It was just I needed. Thank you

[@user-kn5lv8ef3p]

This was perfect!

[@kerrieholleman9047]

exactly what I needed thanks!

[@ntxsubie4282]

Great tutorial

[@connyarias1]

Gracias! saludos desde Ciudad de México.

[@shellijohnson9918]

Very helpful! Thank you

[@mahmudulhasanshahi8960]

Thank you!

[@sheilalussier6788]

Thank you - thank you - thank you! Very clear instructions! Was going around in circles - again thank you!

[@ChesterTugwell]

Glad it helped!

[@alexhenderson1838]

thanks bro this really helps

[@lupitacardenas8717]

Thank You! You explain very well. Easy to understand.

[@ChesterTugwell]

Glad it was helpful!

[@cecilparker2866]

very good, just what I was looking for

[@1Rachaell]

Thank you!!!

[@Mogers95]

Thank you so much!!

[@MrDhunpagla]

Awesome Mr T 👍👏👏

[@renatosanchez5968]

Excellent tutorial

[@user-xw3gf5je5b]

Thanks!

[@DavidBoeff]

great this is what i needed

[@ricktomaski603]

Thank for making this!!

[@ChesterTugwell]

No problem!!

[@Sausage4580]

You’re a godsend

[@potatopack]

nsweet video thank you

[@Anthony-js2cv]

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!

[@skydivesmitty]

wow, that was easy. What else can you teach us? Great job!!

[@hht437]

P-E-R-F-E-C-T

[@janicesharpe7159]

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

[@amyerickson2447]

Question--why did only 30 insert into the 1 page of labels? I actually have 37 addresses in the document?

[@jenniferguerrero3636]

Because the labels are only 30 per page

[@gbauctionsales7808]

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!!

[@cristinawheeler5417]

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?

[@alishanagle6538]

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.

[@jwothedj]

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? 🤞

[@bigrabbit5617]

Good tutorial but I cannot find my label product number. Is it possible to update the product number list in word?

[@carolynwhite465]

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.

[@Ivette_ba]

@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???

[@catherineedwardquill]

Thank you! Why did only 1/4 of my addresses transfer over from Excel to only fill one Word page worth?

[@erfanuddin9821]

Is there a way to include the title on the label too? Like, Name: Chester Tugwell, Address: XYZ ???

[@trepuryllas]

what about if there are fields in the Excel you want to not print as blanks in the label?

[@Alder1967]

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?

[@mwilliams4371]

I get right up to Preview Results and draw a blank page. Any ideas?

[@user-nn1mt6se4o]

My Avery 5160 labels are 4 columns across. When I print, the left column is "squished" How do I correct this?

[@mohanmadhava3078]

May i know the purpose of this email lables in word

[@muhamadahadisatyaguna3545]

ini my Laptop doesn't appear like that, please tell me Why?

[@kannanaiyar5291]

What if I want to print the same address several times on each page?

[@adamkramer2066]

Create the appropriate number of copies in excel by duplicating the row.

[@erikaewers1335]

This only created the first page which contains 30 labels. I have to print 334 addresses. Where are the rest of the labels?

[@BenDonahower]

No fuss. Other videos were nearly 20 minutes long and I thought, it can't be that hard. It isn't.

[@lorraineferrerhopgood2308]

Thank you !!!!!