Creating Labels from a list in Excel

Подписаться 38 тыс.

Просмотров 1,9 млн

50% 1

Creating Labels from a list in Excel, mail merge, labels from excel. Create labels without having to copy your data. Address envelopes from lists in Excel. Keep your customer list in Excel and be able to print labels from customer lists. Check out my templates page for free and purchased templates www.easyexcela...
Are you struggling to update your Microsoft SQL Server data?
I recommend using well-known Excel to update and manage your data in SQL Server using the SQL Spreads Excel add-in.
Click sqlspreads.com... to find out how SQL Spreads works best for non-technical end users and download our free 14-day trial. You will get two months free when purchasing an annual subscription using our link.
Check out my online training www.easyexcelan...
For more help visit my website www.easyexcelan... or email me at easyexcelanswers@gmail.com.
www.amazon.com...
To purchase more labels click the link below
amzn.to/2pz0ILC
I am able to provide online help on your computer at a reasonable rate.
Check out my next one-hour Excel Webinar
www.crowdcast....
Check out Crowdcast for creating your webinars
app.linkmink.c...
If you need to buy Office 2019 follow
amzn.to/2VX5dv8
Follow me on Facebook
/ easyexcel.answers
Follow me on twitter
easyexcelanswers
IG @barbhendersonconsulting
*this description may contain affiliate links. When you click them, I may receive a small commission at no extra cost to you. I only recommend products and services that I've used or have experience with.

Опубликовано:

26 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 963

@vivianbiondolillo3681 5 лет назад

You literally got me a raise and job promotion. My boss' last secretary did the mail merge for him and left 2 years ago. Now he is desperate to have the projects done and told him I can do mail merge. I wasn't aware that this was being done in Excel and spent a whole day training and couldn't come up with these last steps that were provided in this creating labels from a list in Excel. XOXO!

@happy1025 4 года назад

Thank you! You answered in 4 minutes what Office Support couldn't answer in several articles! Very helpful indeed!

@nokpiadariusconstantino1333 2 года назад

Цтгуьткьклбду

@nycollassilva3558 Год назад

Gkhfffefdde11kj

@peterfpowers 4 года назад

Barb, I gotta tell you....this video was phenomenal. I've never seen mail merge explained more concisely and accurately. I feel like I can conquer mail merge. Thank you. Like....you are an icon.

@urbandave 2 года назад

I cannot stress how good this video was. Clear, well spoken and to the point. The only tip I'd add, is that if you change the font, size etc prior to adding a field of information, that field will hold those changes on each label.

@BarbHendersonconsulting 2 года назад

Great point!

@barbwaltermark 5 лет назад

I have never printed labels from an excel spreadsheet before and your tutorial was so easy to follow. I feel like a pro at this now! Thanks so much!

@celiagraterol1519 11 дней назад

Barb, your explanation was so to the point, quick and clear! Everyone should learn from you how to explain things. Thank you.

@BarbHendersonconsulting 11 дней назад

You are very kind

@rebeccafay9738 5 лет назад

Barb, you are a life saver! After pulling most of my hair out trying to figure out the label merge, your simple and clear instructions worked!! Cheers to you, dear lady!

@elissacarey9095 10 месяцев назад

Even 7 years later this was simple and easy to understand. Thanks so much!!

@BarbHendersonconsulting 10 месяцев назад

You're very welcome!

@staceyranee5756 3 года назад

In 2021 and so happy to have found this EXCELLENT tutorial! Step by step and no extra fluff. Again this was wonderful! Thank you so much. You have just made my mailing project much easier.141 addresses to print for school. Whew!

@BarbHendersonconsulting 3 года назад

Glad it was helpful!

@StanleyMartinCustomHomes 2 месяца назад

This video has been a true blessing every time our org has to make labels for holiday cards! Thanks for everything Barb!

@BarbHendersonconsulting 2 месяца назад

You are so welcome!

@phoenixmoon3 5 лет назад

This is excellent. It helped me with a project today. I use this so rarely that i forgot. You were direct, spoke clearly, and you got right down to business. Thank you!!!!

@valkillion6869 8 месяцев назад

Greetings from New Orleans. Excellent instruction & presentation. Used your directions for my Mardi Gras Group. Merci Beaucoup!

@BarbHendersonconsulting 8 месяцев назад

de rien

@BrookBowenVideos 7 лет назад

Very good. I don't know why Excel just doesn't include its own label printing option without the extra MS Word step.

@nokpiadariusconstantino1333 2 года назад

Ьвдуьлбоввлзубтвщлушужовтвщтщыьлвжовжтв ьвовьыдьвжжвэвжвхбвээвтгкьивжвлэыэыэжвишулшузкт

@addisonoberg3588 3 месяца назад

You just saved me HOURS if not days of work - thank you!!

@BarbHendersonconsulting 3 месяца назад

happy to help

@toddwolgamuth6673 5 лет назад

Thank you Barb. You just ended my fumbling around trying to figure it out. Your tutorial was clear and easy to follow and my task will be a breeze! thank you again for an excellent video

@jennymcnulty5037 3 года назад

Thank YOu! I read everything online and couldn't figure it out! You explained it all in less than four minutes!!! thank you thank you thank you!

@BarbHendersonconsulting 3 года назад

Great to hear!

@StairwayToVideo 6 лет назад

Excellent!!! I was stuck until I found your video. Thank you!!

@stephanyswarts5849 2 года назад

Thank you Barb!!! You saved me from retyping 350 labels!

@BarbHendersonconsulting 2 года назад

Wonderful!

@MsShanarun 4 года назад

From, "Oh, I can't remember how to do these and the directions refer you to manuals...." to.. "This is explained to simply!!" Thank you so much!!!

@harperpitts3288 2 года назад

This wonderful woman just saved the day

@BarbHendersonconsulting 2 года назад

Thank you, I glad I could help

@daniemarie4884 6 лет назад

Thank you so much! This made making the labels for my wedding invites so much easier! I did my sister's baby shower invitations by hand and it was awful. This video was such a time saver and very well explained.

@2009lynch 2 года назад

Barb - you rock! Thank you, thank you, thank you!!

@BarbHendersonconsulting 2 года назад

Happy to help!

@Innerspacemarketing 5 лет назад

Thank you! I got stuck on the update label part, I couldn't remember I had to do that. Your video was my life saver!

@niam3630 Год назад

Thank you so much!!! You are a great teacher; easy to understand and straight to the point! TY TY TY

@BarbHendersonconsulting Год назад

Happy to help

@edwinkroon4212 6 лет назад

Thank you so much Barb! Very easy to follow tutorial and you actually take the time. No rush, no need to pause the video, I can just click along. =) Made my Christmas envelope labeling a breeze this year ;)

@lenibjerg3771 Год назад

Many thanks for this easily accessible instruction. I rarely have to print labels, so always forget how to. Now under time pressure, you saved the day. Easily the best on RU-vid. Thank you from Denmark.

@BarbHendersonconsulting Год назад

Glad it was helpful!

@ellensackett727 7 лет назад

Barb! Thank you so much this was awesome, I was struggling with Microsoft's version, that did not work (very out dated) yours was a complete success THANK YOU...THANK YOU!!!

@belief831 17 дней назад

Thank You Barb, you have just saved my life. you video was well put together and easy to follow.

@BarbHendersonconsulting 17 дней назад

Glad it was helpful!

@ultint90 7 лет назад

You made this so easy. Clear and precise, no extra chatter or nonsense, just the directions. Showed me the steps I was missing. Excellent presentation.

@bryanhutzler7010 Месяц назад

Thank you so much. It took me less than 5 minutes. It would have taken a lot longer than that to figure it out myself.

@BarbHendersonconsulting Месяц назад

Glad it helped!

@tagapatag Месяц назад

Thank you! It was easy and instructions were very clear. It saved much time reading and getting confused with the Microsoft instructions.

@BarbHendersonconsulting Месяц назад

Glad it helped!

@seanmele9611 2 года назад

I honestly refer to this video about five times a year. It's the best!

@BarbHendersonconsulting 2 года назад

that's great! thanks

@adambranton4499 6 месяцев назад

I use to do this all the time, 20 years ago, but I had forgotten. This video is great for me as it's short and sweet and straight to the point of what I had forgotten, thank you!

@BarbHendersonconsulting 6 месяцев назад

happy to help

@ssagarwala 6 лет назад

Your best tip was to "update labels". Was driving me crazy that only one label was created until I did that! Thank you!

@lisasmith2784 3 года назад

The idea of creating labels from excel has been daunting me for years. This video makes it SUPER EASY to understand! I cannot thank you enough!

@BarbHendersonconsulting 3 года назад

Glad it was helpful!

@anthonykent00 2 года назад

The year is 2022 and this STILL helped me! Thank you!

@BarbHendersonconsulting 2 года назад

happy to help

@thateldoo 3 года назад

THANK YOU...saved me hours of trying to figure it out on my own...THANK YOU!

@BarbHendersonconsulting 3 года назад

You're welcome!

@evasazonova7118 Год назад

Thanks Barb, you helped two offices in Florida

@BarbHendersonconsulting Год назад

Happy to help!

@PlasmaCoolantLeak 2 года назад

Wife is finding it hard to handwrite mailing labels, and I volunteered to "automate" the process. This is a very concise way of explaining how to set up the process. Thanks!

@BarbHendersonconsulting 2 года назад

thanks very much

@caroljackson146 3 года назад

Perfect explanation! Thank you so much!!

@BarbHendersonconsulting 3 года назад

Glad it was helpful!

@michaelboysuk5285 5 лет назад

OMG!!!! I LOVE YOU!!! I printed out an 18 document on how to mail merge and gave up!! You showed me how in 3 mins. and 58 seconds!!! YOU ROCK!!!

@ZalyxTV Год назад

Great video, made it very simple and easy to understand. Quick and to the point.

@BarbHendersonconsulting Год назад

Happy to help

@jennyshear2862 8 месяцев назад

I was feeling nervous about doing this at my job, but I watched your video twice & my labels came out perfectly! Grateful for this video. Thank you!

@BarbHendersonconsulting 8 месяцев назад

Glad it helped!

@Phodiographer 2 года назад

Thank you! I was just tasked with creating labels for a co-worker and this video was a perfect demo!

@BarbHendersonconsulting 2 года назад

You are so welcome!

@faisalibnawal2815 3 года назад

2021 finished client project after watching this video learnt about print ready labeling within 5 mins. kudos for nice tutorial!

@BarbHendersonconsulting 3 года назад

Glad it helped!

@bellas6143 2 месяца назад

English is not my language, but I understood better than if it were, I spent days looking for how to do this and you were the best in my opinion, thank you very much, people like you who help by giving this type of information without any interest, thank you very much!

@BarbHendersonconsulting 2 месяца назад

You are welcome!

@jennifermott2436 9 месяцев назад

You just saved me a TON of time. Thank you! Super easy to follow.

@BarbHendersonconsulting 9 месяцев назад

Glad it helped!

@gaterealtyandmortgageservi7097 2 года назад

Thank you for this easy to follow tutorial. Anytime I forget how to create my mailing list, I come back to your page. Thanks again!

@BarbHendersonconsulting 2 года назад

Wonderful!

@KrystianThomas 2 года назад

It's 2022 and this is very helpful. Thank you for a very easy to follow video!

@BarbHendersonconsulting 2 года назад

I have been around for a while, I am glad it was helpful

@hannahdalsoglio7169 3 года назад

Barb, you are a national treasure. It's 2021 and you're still helping people. Queen shit

@BarbHendersonconsulting 3 года назад

thank you

@sandybenoit791 3 года назад

Thank You! You just ended 2 hours of frustration & stopped me from having to write out 74 labels by hand! Very clear & complete instructions.

@BarbHendersonconsulting 3 года назад

Glad it helped!

@danieleaker9622 10 месяцев назад

Outstanding! This is exactly what I was looking for! Simple and easy! Thank you!

@BarbHendersonconsulting 10 месяцев назад

Glad it was helpful!

@kellyedmondson1634 2 года назад

I have a sticky note on my address label package with the name of this video and your name and every Christmas, I come back here and using a split screen, create my labels. (Actually, this is your second version/video that I have used.) THANK YOU for saving my sanity!!

@BarbHendersonconsulting 2 года назад

Love that!

@razdchamp Год назад

Just because no one at my work knew how to do this I will subscribe.

@BarbHendersonconsulting Год назад

thanks

@mnkelley84 2 года назад

Thank you, this was probably the easiest tutorial I have ever watched. When I tell you I been searching high and low for someone to break this down and you just helped me so much so thank you.

@BarbHendersonconsulting 2 года назад

Great to hear!

@michellemurphy779 3 года назад

Thank you, super straight to the point and I didn't have to a watch a 10-minute video to get the tips I needed! Great Job!

@BarbHendersonconsulting 3 года назад

thank you!

@CrimsonGuard262 3 года назад

how does this video have down votes?!?!! This woman rocks! I used this now 3 times to try and make labels and figured it out every time. (bad memory lol)

@BarbHendersonconsulting 3 года назад

thank you

@ysamgreen Год назад

Barb, hear we are in 2022 and the video is still giving it!!! Thanks....you made me feel like a technical genius!!!

@BarbHendersonconsulting Год назад

I am glad it helped!

@lorrainesmith5193 2 года назад

This was so helpful with mailing out our office Christmas cards this year. Simple and clear instructions. Thank you for posting.

@BarbHendersonconsulting 2 года назад

Glad it was helpful!

@KatherineOrho 5 лет назад

Thank you for helping a happy volunteer at a national nonprofit organization. You made me look proficient and knowledgeable. I did subscribe and I sent your video to the office Executive Assistant.

@fidel0217 11 месяцев назад

Concise and has no extra chatter. Very Professional. Keep up the good work Barb!

@BarbHendersonconsulting 11 месяцев назад

Thanks so much!

@Kim-lc3fv Год назад

Thank you! Very well explained. And I could tell I was listening to a Canadian when a-Gain came up, and then a-Boot. I was born in Vancouver but we moved to LA when I was 6 so I lost that charming accent and now just sound like an international dual citizen American living in Europe. 😉

@BarbHendersonconsulting Год назад

Excellent!

@momof4loves 11 месяцев назад

Thanks for the excellent and succinct explanation! Short and sweet. Loved it.

@BarbHendersonconsulting 11 месяцев назад

Glad it was helpful!

@aplusprintshop 4 года назад

thank you so much!!! people like you is what makes RU-vid great!

@lordpisces5019 4 года назад

This video saved me a lot of busywork at my job. So I am leaving a comment for engagement

@kellydoherty3926 Год назад

You are a lifesaver Barb!! Many thanks!

@BarbHendersonconsulting Год назад

Happy to help!

@karenuebler5745 2 года назад

Wow! Thank you very much. Your directions were very easy to follow and I was able to easily convert the excel file to address labels.

@BarbHendersonconsulting 2 года назад

Glad it helped!

@nichoka61 Год назад

Oh my goodness! Thank you so much your video saved me so much time. I really like your teaching style as well.

@BarbHendersonconsulting Год назад

You are so welcome!

@7oclockmiracles88 3 года назад

Thank you! I feel so COMPETENT now! Lol. You’re a great teacher!

@BarbHendersonconsulting 3 года назад

thank you!

@marissaalix7380 7 лет назад

THANK YOU!!! My mom and I have been trying to figure out why we couldn't do this for the last hour. We looked at every website and couldn't find a thing that worked! You just made my mom very happy!

@caseytwill Год назад

I wish I could give you more than one thumbs up... clear, to the point, and informative. The BEST tutorial I've watched on this. Thank you!

@BarbHendersonconsulting Год назад

Glad it was helpful!

@davidrotondi5300 Год назад

You’re my new best friend. This was AWESOME

@BarbHendersonconsulting Год назад

Yay! Thank you!

@jamessteidl5260 3 года назад

THANK YOU BARB!!! This would have taken me days or weeks to figure out!

@BarbHendersonconsulting 3 года назад

You are so welcome!

@rhinosoundcontrol Год назад

Great tutorial even 6 years later. Goes to show you, some things never change! When you're good you're good!

@BarbHendersonconsulting Год назад

I appreciate that!

@ebk24 Год назад

This is by far one of the most helpful things I have ever seen in my entire life. Thank you so much!

@BarbHendersonconsulting Год назад

You're very welcome!

@Grace-e4u 10 месяцев назад

This is the best tutorial! Saved me a lot of blood, sweat and tears! Thank you.

@BarbHendersonconsulting 10 месяцев назад

Glad I could help

@kzzink649 3 года назад

Very easy to follow. Quick and fast. I was able to easily create the labels I needed. Thank you.

@BarbHendersonconsulting 3 года назад

You're very welcome!

@thegreektyphoon 9 месяцев назад

Great job, she does the best job explaining how to do it.

@BarbHendersonconsulting 9 месяцев назад

thank you, all my years of teaching software is paying off!

@madandart 8 месяцев назад

Best explanation! Easy to follow! Thank you!

@BarbHendersonconsulting 8 месяцев назад

Glad it was helpful!

@willowsprite591 3 года назад

Thank you!! I was searching all over trying to figure out how to do this!! I could not find answers until this video came along!

@BarbHendersonconsulting 3 года назад

Glad I could help!

@stemsteps7957 5 месяцев назад

thank you- just used this video and I can't believe how easy it is to do

@BarbHendersonconsulting 5 месяцев назад

Glad it helped!

@marenavelandia6819 3 года назад

Thank you so much for this video! it saved my life for the end of the year holiday greeting labels.

@BarbHendersonconsulting 3 года назад

You're so welcome!

@ronakrana1707 2 года назад

Thank you so so much, you have relieved my load of setting 500 addresses. God Bless you.

@BarbHendersonconsulting 2 года назад

Glad it helped

@jamilahamdane Год назад

Thank you very much for the tutorial, very helpful, clear and easy to follow.

@BarbHendersonconsulting Год назад

Glad you liked it

@ciaracooper6563 Год назад

Barb! I could kiss you! You just saved me countless hours making labels for literally thousands of clients!

@BarbHendersonconsulting Год назад

Happy I could help

@chinta-louisetorpey7247 5 лет назад

Barb - You are awesome...I have over 1000 labels to make and just knew there must be an easier way that copy paste. I'm ecstatically overjoyed!!!!! Thank-you so very much for your step by step expertise. I deeply appreciate your teaching. Thank-you again!

@midwestpeterbiltgroup 4 года назад

What a lifesaver! Love your directions and it worked perfectly!

@BarbHendersonconsulting 4 года назад

Glad it helped!

@rootzwiki Год назад

Awesome video. I've worked for a school and once a year we need to create bus tags. I always seem to forget one step and end up googling how to .... ? This is the best video ever.

@BarbHendersonconsulting Год назад

you are so kind!

@RRCharleston 3 года назад

Barb, you are amazing. Spent 30+ minutes trying to figure it out. Followed you step by step and BAM! Love your accent too!

@BarbHendersonconsulting 3 года назад

Awesome! Thank you!

@royaltylifeandhealth 2 года назад

THANK YOU! I hadn't done a merge since 1984!!!

@BarbHendersonconsulting 2 года назад

It is hard to remember these things when you have not used them in a while!

@memberperks674 Год назад

Simple and to the point ...thanks Barb!!

@BarbHendersonconsulting Год назад

You are so welcome!

@lep32456 Год назад

Thank you. I use this every year when I have to reach out to my clients. This is a life saver.

@BarbHendersonconsulting Год назад

Wonderful!

@bu5589 4 года назад

What a great video. So refreshing to follow the steps and have everything just work. Thank you!

@BarbHendersonconsulting 4 года назад

You are very welcome

@eam12kb24 3 года назад

very good explanation. Right to the point. No fluff or unnecessary talk.

@BarbHendersonconsulting 3 года назад

Glad you liked it

@nancyjimenez167 Год назад

You are such a great teacher! Thank you thank you!

@BarbHendersonconsulting Год назад

Happy to help!

@orincarr2215 Год назад

Absolute lifesaver Barb. Thank you so much!!

@BarbHendersonconsulting Год назад

Glad it was helpful!

@keithniehaus3050 4 года назад

Great Job!! This was just what I needed and easy to understand!!!

@BarbHendersonconsulting 4 года назад

Glad it was helpful!

@amylynn14p 4 года назад

Thank you for your easy to follow tutorial!! I knew it could be done! These programs are designed to do so much, and unless you use certain features all the time, it's impossible to know how to do it all. Thanks again!!