Creating Labels from a list in Excel

Тәжірибелік нұсқаулар және стиль

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.easyexcelanswers.com/templates.html
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/?pid=barbhenderson 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.easyexcelanswers.com/courses.html
For more help visit my website www.easyexcelanswers.com or email me at easyexcelanswers@gmail.com.
www.amazon.com/shop/barbhenderson
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.io/easyexcelanswers
Check out Crowdcast for creating your webinars
app.linkmink.com/a/crowdcast/83
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.

Пікірлер: 924

  • @vivianbiondolillo3681
    @vivianbiondolillo36814 жыл бұрын

    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!

  • @ultint90
    @ultint907 жыл бұрын

    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.

  • @happy1025
    @happy10254 жыл бұрын

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

  • @nokpiadariusconstantino1333

    @nokpiadariusconstantino1333

    2 жыл бұрын

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

  • @nycollassilva3558

    @nycollassilva3558

    Жыл бұрын

    Gkhfffefdde11kj

  • @peterfpowers
    @peterfpowers4 жыл бұрын

    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.

  • @barbwaltermark
    @barbwaltermark5 жыл бұрын

    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!

  • @rebeccafay9738
    @rebeccafay97385 жыл бұрын

    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
    @elissacarey90957 ай бұрын

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

  • @BarbHendersonconsulting

    @BarbHendersonconsulting

    7 ай бұрын

    You're very welcome!

  • @phoenixmoon3
    @phoenixmoon35 жыл бұрын

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

  • @ellensackett727
    @ellensackett7276 жыл бұрын

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

  • @toddwolgamuth6673
    @toddwolgamuth66734 жыл бұрын

    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

  • @jimwingate5687
    @jimwingate56874 жыл бұрын

    I have been reading books of instruction attempting to follow the directions of how to complete functions in word and excel. You make it sound so simple. Now I can write my letters and create labels to mail them with having to write the address on the front of the envelope. I love you!

  • @staceyranee5756
    @staceyranee57562 жыл бұрын

    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

    @BarbHendersonconsulting

    2 жыл бұрын

    Glad it was helpful!

  • @Innerspacemarketing
    @Innerspacemarketing5 жыл бұрын

    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!

  • @StairwayToVideo
    @StairwayToVideo6 жыл бұрын

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

  • @michaelboysuk5285
    @michaelboysuk52854 жыл бұрын

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

  • @ssagarwala
    @ssagarwala6 жыл бұрын

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

  • @daniemarie4884
    @daniemarie48846 жыл бұрын

    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.

  • @edwinkroon4212
    @edwinkroon42126 жыл бұрын

    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 ;)

  • @heatherschwartz7093
    @heatherschwartz70935 жыл бұрын

    Thank you so very much! I appreciate the step by step! I have been pulling my hair out for 3 days trying to do this. Glad I found your video.

  • @lenibjerg3771
    @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 KZread. Thank you from Denmark.

  • @BarbHendersonconsulting

    @BarbHendersonconsulting

    Жыл бұрын

    Glad it was helpful!

  • @BrookBowenVideos
    @BrookBowenVideos7 жыл бұрын

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

  • @nokpiadariusconstantino1333

    @nokpiadariusconstantino1333

    2 жыл бұрын

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

  • @MsShanarun
    @MsShanarun4 жыл бұрын

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

  • @moniqueferris2252
    @moniqueferris22526 жыл бұрын

    Thank you! short and precise without the fluff. Just what I needed!

  • @scottbringe7087
    @scottbringe70875 жыл бұрын

    I tried using the "step-by-step" instructions on Microsoft's support page and they are horrible. Your instructions were perfect! Thank you.

  • @toucotrip2249
    @toucotrip22497 жыл бұрын

    Very helpful Barb. I'm getting ready to do my first mass mailing .... Thank you.

  • @michelemichaelsen2643
    @michelemichaelsen26435 жыл бұрын

    Thank you so much! I spent WAY too much time today trying to figure this out using the "HELP" feature. With your video I was able to get it done in minutes!

  • @Tanchel37
    @Tanchel375 жыл бұрын

    THANK YOU SOOOOOOOO MUCH!! I was going crazy trying to figure this out. You just saved me from ruining my week-end.

  • @evasazonova7118
    @evasazonova711811 ай бұрын

    Thanks Barb, you helped two offices in Florida

  • @BarbHendersonconsulting

    @BarbHendersonconsulting

    11 ай бұрын

    Happy to help!

  • @chinta-louisetorpey7247
    @chinta-louisetorpey72474 жыл бұрын

    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!

  • @PWDsRock
    @PWDsRock6 жыл бұрын

    I have been trying to figure this out forever and I finally found this! Thank you, thank you, thank you!!

  • @marissaalix7380
    @marissaalix73807 жыл бұрын

    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!

  • @byeloth3
    @byeloth35 жыл бұрын

    This video has come in handy for my business two years in a row! Thank you!

  • @addisonoberg3588
    @addisonoberg35886 күн бұрын

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

  • @BarbHendersonconsulting

    @BarbHendersonconsulting

    5 күн бұрын

    happy to help

  • @KatherineOrho
    @KatherineOrho5 жыл бұрын

    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.

  • @urbandave
    @urbandave2 жыл бұрын

    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

    @BarbHendersonconsulting

    2 жыл бұрын

    Great point!

  • @sylvainthome1548
    @sylvainthome15485 жыл бұрын

    Thanks Barb for this excellent tutorial which explains how to produce labels from Excel in a clear way. I like your quick and simple explanation. Again Thanks!

  • @lizconrow2068
    @lizconrow20684 жыл бұрын

    Thank you! This was so helpful in getting my Christmas card labels printed! Easy to follow! Perfect instructions!

  • @kellyedmondson1634
    @kellyedmondson16342 жыл бұрын

    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

    @BarbHendersonconsulting

    2 жыл бұрын

    Love that!

  • @mnkelley84
    @mnkelley842 жыл бұрын

    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

    @BarbHendersonconsulting

    2 жыл бұрын

    Great to hear!

  • @amylynn14p
    @amylynn14p4 жыл бұрын

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

  • @davidbernstein3406
    @davidbernstein34066 жыл бұрын

    Thanks for this great video! After struggling for hours trying to make sense of the Microsoft support document, I managed to print labels in just a few minutes!

  • @JC-jp7uz
    @JC-jp7uz5 жыл бұрын

    Excellent! Thanks Barb saved me a TON of time

  • @michellemurphy779
    @michellemurphy7793 жыл бұрын

    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

    @BarbHendersonconsulting

    3 жыл бұрын

    thank you!

  • @lisasmith2784
    @lisasmith27843 жыл бұрын

    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

    @BarbHendersonconsulting

    3 жыл бұрын

    Glad it was helpful!

  • @lorrainesmith5193
    @lorrainesmith51932 жыл бұрын

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

  • @BarbHendersonconsulting

    @BarbHendersonconsulting

    2 жыл бұрын

    Glad it was helpful!

  • @mariajohnson2037
    @mariajohnson20375 жыл бұрын

    Thank you so much! I have struggled trying to figure this out, but you made it very simple to follow!!!

  • @jonathanczyscon8293
    @jonathanczyscon82935 жыл бұрын

    Incredibly helpful and concise, thank you!

  • @jennyrandall6777
    @jennyrandall67775 жыл бұрын

    Thank you so much for this tutorial. I have gone to it several times for reference.

  • @l_pete_l6501
    @l_pete_l65015 жыл бұрын

    Thank you! Very clear and easy to follow instructions.

  • @aplusprintshop
    @aplusprintshop4 жыл бұрын

    thank you so much!!! people like you is what makes KZread great!

  • @jimd2819
    @jimd28194 жыл бұрын

    Short to the point and easy to understand. Thank you, great job.

  • @chrispayne750
    @chrispayne7505 жыл бұрын

    Best video that FINALLY helped me get this to work. Thanks!

  • @savarisgroup
    @savarisgroup4 жыл бұрын

    Thank you! You just saved me several hours and a headache! Bless you!!!!

  • @annakozak2033
    @annakozak20333 жыл бұрын

    Best updated (1/2021) explanation yet! Thank you!

  • @BarbHendersonconsulting

    @BarbHendersonconsulting

    3 жыл бұрын

    Wow, thanks!

  • @adambranton4499
    @adambranton44993 ай бұрын

    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

    @BarbHendersonconsulting

    3 ай бұрын

    happy to help

  • @karenmiller5003
    @karenmiller50036 жыл бұрын

    Thank you for a VERY simple and clear explanation!

  • @lilCecy1986
    @lilCecy19865 жыл бұрын

    Thank you Barb! Your tutorials are very helpful!

  • @coparaji4616
    @coparaji46165 жыл бұрын

    Thanks Barb, so detailed and explained in an easy way.

  • @isolorza90
    @isolorza906 жыл бұрын

    Thank you. Very helpful.

  • @danieleaker9622
    @danieleaker96227 ай бұрын

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

  • @BarbHendersonconsulting

    @BarbHendersonconsulting

    7 ай бұрын

    Glad it was helpful!

  • @elizabethhousefkapotter5024
    @elizabethhousefkapotter50246 жыл бұрын

    Thank you, Barb!! I appreciate this video!

  • @DenverJohn11
    @DenverJohn115 жыл бұрын

    It looks like you have helped so many in need. Add another grateful to the list.

  • @kirkcoulter1180
    @kirkcoulter11804 жыл бұрын

    Thank you for this. I appreciate your efforts. This is exactly what I've been looking for.

  • @wveldred
    @wveldred5 жыл бұрын

    Your videos are WONDERFUL. Thank you so much for your time and effort

  • @laclearbrook7754
    @laclearbrook77542 жыл бұрын

    Oh my gosh, you ROCK!!! You just made my life SOOOO much easier and in turn, happier. THANK YOU!!!!

  • @BarbHendersonconsulting

    @BarbHendersonconsulting

    2 жыл бұрын

    You are so welcome!

  • @johatt3402
    @johatt34024 жыл бұрын

    Thank you Barb, this is so helpful for name badges that I need to produce for a conference.

  • @nokpiadariusconstantino1333

    @nokpiadariusconstantino1333

    2 жыл бұрын

    орвьма. А. Аиабтэвьзвтовжцзхцхцхулщутатшуьоужут

  • @lordpisces5019
    @lordpisces50194 жыл бұрын

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

  • @soflans
    @soflans4 жыл бұрын

    THANK YOUUUUUUU. DEAR BARB THIS WAS A PERFECT EASY HOW TO YOU SAVED ME

  • @hannahdalsoglio7169
    @hannahdalsoglio71692 жыл бұрын

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

  • @BarbHendersonconsulting

    @BarbHendersonconsulting

    2 жыл бұрын

    thank you

  • @janicehansen999
    @janicehansen9996 жыл бұрын

    Thank you so much! Even though this is slightly outdated and the mail merge looked different in Word, it was very helpful. I watched it several times wile I created my mail merge and successfully printed labels! One glitch with word, if you look at the preview and then print, it will only show you the first page. Once you edit all recipients and save, you can see the entire document.

  • @jayne9452
    @jayne94524 жыл бұрын

    So glad I found you again. Subscribed this time. I used this last year and so happy to have found your video again. Excellent and Easy to Follow!

  • @mrmorksstuff
    @mrmorksstuff5 жыл бұрын

    Thank you..you just saved my life ! wish I had found your video yesterday !

  • @CK-op7ho
    @CK-op7ho6 жыл бұрын

    I can't even tell you how helpful this was. :)

  • @2009lynch
    @2009lynch2 жыл бұрын

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

  • @BarbHendersonconsulting

    @BarbHendersonconsulting

    2 жыл бұрын

    Happy to help!

  • @stephanyswarts5849
    @stephanyswarts58492 жыл бұрын

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

  • @BarbHendersonconsulting

    @BarbHendersonconsulting

    2 жыл бұрын

    Wonderful!

  • @fidel0217
    @fidel02178 ай бұрын

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

  • @BarbHendersonconsulting

    @BarbHendersonconsulting

    8 ай бұрын

    Thanks so much!

  • @northcarolinataxidermy318
    @northcarolinataxidermy3186 жыл бұрын

    Thanks for the label tutorial Barb!

  • @prorespluscom
    @prorespluscom2 жыл бұрын

    Phenomenal video. Clear, concise, step by step - very professional. Just what I was looking for.

  • @BarbHendersonconsulting

    @BarbHendersonconsulting

    2 жыл бұрын

    Glad you enjoyed it!

  • @jennymcnulty5037
    @jennymcnulty50373 жыл бұрын

    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

    @BarbHendersonconsulting

    3 жыл бұрын

    Great to hear!

  • @andreaderose146
    @andreaderose1464 жыл бұрын

    Thank you so much!!! You are so easy to follow and I love your voice!! hugs from Cali!

  • @leahredapple
    @leahredapple3 жыл бұрын

    Thanks so much - I've been working on this for a couple of hours......and watching you video cleared it all up in a few minutes!!

  • @BarbHendersonconsulting

    @BarbHendersonconsulting

    3 жыл бұрын

    Glad it helped!

  • @thebrilliancemine
    @thebrilliancemine4 жыл бұрын

    Thank you so much! I really appreciate you took the time to make this great and very helpful video. It saved my Christmas letter mailing!

  • @seanmele9611
    @seanmele9611 Жыл бұрын

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

  • @BarbHendersonconsulting

    @BarbHendersonconsulting

    Жыл бұрын

    that's great! thanks

  • @woganjones2012
    @woganjones20127 жыл бұрын

    Thank you Barb. Just what I needed. Very clear.

  • @deangarner6594
    @deangarner65947 жыл бұрын

    Thanks, this was helpful.

  • @harperpitts3288
    @harperpitts32882 жыл бұрын

    This wonderful woman just saved the day

  • @BarbHendersonconsulting

    @BarbHendersonconsulting

    2 жыл бұрын

    Thank you, I glad I could help

  • @gabbyhall8655
    @gabbyhall86555 жыл бұрын

    This was so helpful!! Thank you so much!

  • @anthonykent00
    @anthonykent00 Жыл бұрын

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

  • @BarbHendersonconsulting

    @BarbHendersonconsulting

    Жыл бұрын

    happy to help

  • @sandybenoit791
    @sandybenoit7913 жыл бұрын

    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

    @BarbHendersonconsulting

    3 жыл бұрын

    Glad it helped!

  • @kardenyafalls7739
    @kardenyafalls77392 жыл бұрын

    Thank you so much! This helped me more than you’ll ever know. You explained it in such a simple and slow way. Much appreciated!!

  • @BarbHendersonconsulting

    @BarbHendersonconsulting

    2 жыл бұрын

    You're very welcome!

  • @RagingEarthSWERVE
    @RagingEarthSWERVE4 жыл бұрын

    Thank you, Barb! This has been very helpful.

  • @tatergirl100
    @tatergirl1006 жыл бұрын

    Thank you for making this so easy to understand!

  • @jennifermott2436
    @jennifermott24366 ай бұрын

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

  • @BarbHendersonconsulting

    @BarbHendersonconsulting

    6 ай бұрын

    Glad it helped!

  • @valkillion6869
    @valkillion68695 ай бұрын

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

  • @BarbHendersonconsulting

    @BarbHendersonconsulting

    5 ай бұрын

    de rien

  • @jennyshear2862
    @jennyshear28625 ай бұрын

    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

    @BarbHendersonconsulting

    5 ай бұрын

    Glad it helped!

  • @midwestpeterbiltgroup
    @midwestpeterbiltgroup4 жыл бұрын

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

  • @BarbHendersonconsulting

    @BarbHendersonconsulting

    4 жыл бұрын

    Glad it helped!

  • @lisaaawall
    @lisaaawall5 жыл бұрын

    You are an angel, thank you for this!

  • @ebk24
    @ebk24 Жыл бұрын

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

  • @BarbHendersonconsulting

    @BarbHendersonconsulting

    Жыл бұрын

    You're very welcome!

  • @kzzink649
    @kzzink6493 жыл бұрын

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

  • @BarbHendersonconsulting

    @BarbHendersonconsulting

    3 жыл бұрын

    You're very welcome!

  • @Phodiographer
    @Phodiographer2 жыл бұрын

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

  • @BarbHendersonconsulting

    @BarbHendersonconsulting

    2 жыл бұрын

    You are so welcome!