Use Mail Merge to Create Mailing Labels in Word from an Excel Data Set

Поділитися
Вставка
  • Опубліковано 27 січ 2025

КОМЕНТАРІ • 1,3 тис.

  • @TheSpiritSing
    @TheSpiritSing 8 років тому +39

    Ralph, Thank you. I saved this video 3 years ago when making my 1st set of Christmas card mailing labels. I have to check in once a year! Watching your video has become a holiday tradition for our family. Some people watch "It's a Wonderful Life." I watch your video. Thanks & Happy Holidays to you & your family.

  • @brinnlieknavel3592
    @brinnlieknavel3592 7 років тому +1

    You deserve a Nobel Peace Prize, because let me tell you, If you hadn't created this video, there wouldn't be any more peace left on this earth after all my frustration. Thank you. And my company thanks you.

  • @cocoabutta600o3
    @cocoabutta600o3 4 роки тому +7

    This video made me feel like I learned something today! Thank you so much sir! You are a great teacher

  • @leonasalazar
    @leonasalazar 4 роки тому

    I've spent two hours looking at all sorts of websites trying to figure out how to do this. Your youtube presentation took 8:18 minutes AND IT WORKS PERFECTLY! Thanks so much.

  • @randismaldone9287
    @randismaldone9287 8 років тому +13

    One of the best tutorials I've seen! Great job and THANK YOU!

  • @rashidkhan11214
    @rashidkhan11214 6 років тому

    I had to print 3000 labels and I was doing it on Microsoft Word one by one. Then I search online how to bring my whole list from Excel to Word and I found you. Thanks a lot Mr. Ralph Phillips. It took me 3 minutes to bring this list into labels after watching your video. Thanks again

  • @SlayerPrincess
    @SlayerPrincess 11 років тому +9

    THANK YOU SOOOOO MUCH!!! this was sooooo helpful you just don't even know. I was trying to get ahead at work by helping to set up the mailing list and print out the labels for reminder letters and I didn't really have a clue how. This helped me so much, now I know what I am doing and can get my work done with confidence. Thank you soooo very much.

    • @SixMinutesSmarter
      @SixMinutesSmarter  10 років тому

      You're welcome. In my first job out of college I had to make thousands of mailing labels every week. If only their was an MS office method for stuffing the envelopes.

  • @maxdondada
    @maxdondada 7 років тому

    Ralph this is by far the easiest and most concise instructional video on creating labels. Job well done sir! A child could follow these instructions.

  • @steveshort7560
    @steveshort7560 9 років тому +5

    This is so helpful!!! I review this every year when putting together my Christmas cards.

  • @betsymancuso2007
    @betsymancuso2007 9 років тому

    You are the "true" Guru of tutorials! You saved the day this Christmas!!!!! Your directions are so simple, clear, and precise! Thank you! Thank you!!!!

  • @kathleenwingerson
    @kathleenwingerson 10 років тому +6

    Thank you so very much!!!! I tried to follow the instructions on the word website and just got more and more confused. Your instructions were simple and very easy to follow. AWESOME!!

    • @andreahaywood7485
      @andreahaywood7485 6 років тому

      Me too! It was more like "www.MSwtf.com" They are the worst... Ralph, on the other hand, is the best.

  • @XiomiVR6
    @XiomiVR6 2 роки тому

    I am 45 years old and mail merge has been ONE of those things in Word that I have avoided most of my adult life, because I just couldn't figure it out! But your video, has completely changed that. THANK YOU so vey much for making things so easy to follow and understand! You've made me the hero at the office today! :)

  • @pushkarindora3770
    @pushkarindora3770 8 років тому +5

    BEST TUTORIAL ON WHOLE UA-cam

    • @jsullivan518
      @jsullivan518 Рік тому

      Great and easy to follow instructions!!!

  • @jimhh12
    @jimhh12 3 роки тому

    OUTSTANING GUIDE. I tried many other supposedly helpful guides for this process, but this was the ONLY one with actual step by step design and finished document guidance. Excellent. My thanks.

  • @ChelseaSextonRuiz
    @ChelseaSextonRuiz 9 років тому +3

    Thank you so much! I was losing my mind until I found this!

  • @CarlLHopkins
    @CarlLHopkins 7 років тому

    THANK YOU!!!!! After an hour of trying to follow Microsoft instructions, which left out the all important "Update Labels" a few minutes with you solved my problem! Thank you a million times.

  • @Homeandlife1
    @Homeandlife1 8 років тому +5

    I'm going to label you as an Excel and Word expert. Thanks for your advice!

  • @YoliHarrisyllwrz
    @YoliHarrisyllwrz 10 років тому +2

    Thank you Mr. Phillips. Your tutorial was perfect, simple and easy to understand. My classmates were fumbling on how to do the labels properly but we had forgotten the steps. So I took the time to look for something on UA-cam. There is always more than one way and this was the easiest. I had done all the steps with the merge even using the existing excel sheet but I kept trying to use the other label menu which kept me stumped for a while. I do not like to waste time but I also try to figure things out on my own. One of the problems was with using the other menu I would create the label and try to update the others and it would go back to the beginning as if I never formatted the label...very frustrating. Believe it or not I had to watch your video three times because in class there are some distractions and I could not watch it all the way through without missing something. It's a done deal now thank you very much. You have a very personable voice which also helps with listening and watching tutorials.

  • @NellyInTheSky
    @NellyInTheSky 9 років тому +3

    Just logged in to say thank you for this video (can't remember when I last did that!). Very useful video - thumbs up :)

  • @j.c.2698
    @j.c.2698 7 років тому

    Ralph, THANK YOU!
    I had to type out 170 and after 40 of them I thought that I was going to try to do it by reading articles by Microsoft, etc. You were extremely helpful and saved me another 8 hours of work! I've saved your video for next time!

  • @debbiemellberg8077
    @debbiemellberg8077 9 років тому +4

    Thank you very much. You did an outstanding job explaining this process.

  • @motokatusa
    @motokatusa 8 років тому

    Thank you Thank you Thank you. Expertly explained. For first time in decades I can use mail merge labels!!! Have been trying to follow Microsoft instructions--repeatedly, including this morning-- since the 90s to no avail. Am so glad I thought about checking UA-cam today! Thank you for making this video

  • @LABeautifulDesigns
    @LABeautifulDesigns 8 років тому +5

    Perfectly explained. Thanks so much

  • @bardos
    @bardos 9 років тому

    Awesome video. I am so used to tutorials where the speaker is hard to understand. A lovely natural flow of instruction here.

  • @debraroberts7443
    @debraroberts7443 8 років тому +26

    OMG I was getting soooooooooo frustrated until I watched this video THANKS!!!

  • @ChunkyDrew33136
    @ChunkyDrew33136 6 років тому

    Thanks so much!! I spent literally HOURS trying to merge 88 records. Following your directions, I got it right the very first try. Kudos!

  • @lissawohltmann1585
    @lissawohltmann1585 8 років тому +5

    This is the best tutorial ever! Thank you so much; you make me look like a administrative god!

  • @Stvkrn
    @Stvkrn 9 років тому

    Thank you! The written microsoft office instructions were so complicated, you've saved the day!

  • @donnajhawkinswalsh382
    @donnajhawkinswalsh382 8 років тому +10

    Thank you Lord I found you! That was easy!

  • @MissTriciaMilitia
    @MissTriciaMilitia 9 років тому

    You saved me over $100 AND allowed me to have these same day by showing me to do this myself instead of uploading them to an online company! Thank You!!!!

  • @sarahbeswick6310
    @sarahbeswick6310 8 років тому +24

    Thank you so much. I was ready to kill the world and his wife over this and you calmly talked me through. As well as fixing my labels, you made my day happier. Thank you

    • @cocoabutta600o3
      @cocoabutta600o3 4 роки тому

      LOLOLOL Not kill the world LMAO! But yes I agree this is a great video

  • @lezliehiner5957
    @lezliehiner5957 9 років тому

    Out of all the tutorials, this one is the most easily understood - thank you

  • @itsmarialifestyle4355
    @itsmarialifestyle4355 7 років тому +3

    Thank you so much!

  • @mikkiharkin7087
    @mikkiharkin7087 7 років тому +1

    Thank you!!! not only did the video save me but your calming voice made this a breeze!!

  • @representing50plus
    @representing50plus 9 років тому +3

    How can I print just a few of the names from my list? Example I want to print 12 out of my 30 names in my excell database.
    thanks in advance.

    • @auroraautumn8764
      @auroraautumn8764 6 років тому

      Did you try copying and pasting the 12 names unto a new excel doc

  • @Mermaid4Ever
    @Mermaid4Ever 9 років тому

    Thank you Ralph for this easy-to-follow tutorial on how to create mail merge labels. I've been having trouble figuring it out how to do these correctly on my own, so I Googled the question and up popped your video. I just successfully printed over 100 labels for a non-profit organization postcard mailing. Thanks again! BR

  • @srr2717
    @srr2717 7 років тому

    I watch your video every time I need to use Mail Merge for my work. Very helpful. Thank you for taking the time to upload such videos.

  • @cdiclerico
    @cdiclerico 5 років тому

    This is STILL how is works 8 years later. Completely undiscoverable without the video. Almost committed murder. You saved lives my friend. You're a hero.

  • @trinitymechanical2029
    @trinitymechanical2029 9 років тому

    Thank You so much! I would pause .. do that step... start again and pause and on to the next step! I couldn't have done it without you! And I have taken an unused label and put it on my label packaging so I may refer to you again in the future when I need to do this again. Initially I had watched other tutorials but none was as easy as yours! Thanks again Ralph! ~Kim Barton

  • @adriennem6654
    @adriennem6654 4 роки тому

    I am so glad I found your tutorial. I use mail merge maybe once a year in a school setting. Now, that school personnel are working from home, I definitely saved it this time! THANKS!!

  • @BettyFranksArt
    @BettyFranksArt 7 років тому

    You are a life saver! I was starting to pull my hair out. You made this every easy. Thank you so much for sharing your talent with the world!

  • @SanJoseFoghead
    @SanJoseFoghead 10 років тому

    This is the clearest and most concise tutorial on creating mail merge labels that I've ever seen. I breezed right through it - and believe me, that's saying a lot!

  • @jacquelinejackson5191
    @jacquelinejackson5191 7 років тому

    By far one of the best mailing labels tutorial ever.............

  • @creepulkins
    @creepulkins 10 років тому +1

    This instructional video kicks the CRAP out of every other one on the web. This video was easy to understand and it wasn't 13-25 minutes like the other ones....THANK YOU!!

  • @christiancook9122
    @christiancook9122 8 років тому

    After 3 phone calls and hours wasted, I watched this video. SAVED!
    Thank you Ralph.

  • @aditigupta7663
    @aditigupta7663 4 роки тому

    Thank you so much Ralph! You saved me! I have got an IT practical tomorrow and I have been looking all over the web. Your video is the best!

  • @shindogsf
    @shindogsf 5 років тому

    This is the most helpful online item I've found in a longtime. Why this isn't easier is just crazy, but this video is foolproof.

  • @willied42
    @willied42 8 років тому

    Thanks so much for this video! I had a contact list of 150 in excel that I needed to make labels for. I spent 2 days trying to figure it out, reading everything I could find, but I still couldn't get it to work until watching this video. I am so very thankful to you.

  • @lindapiccotti3311
    @lindapiccotti3311 4 роки тому

    Thanks so much, Ralph. This easy step by step tutorial helped me set up an excel list and mailing labels for our home owners association. I am very grateful!

  • @crystaldejesus-munoz8809
    @crystaldejesus-munoz8809 7 років тому

    OMG I cant tell you how long i have been trying to learn how to mail merge labels & this video is like AMAZING! Thank you so much ... I know every Bride will be happy to find this video :)

  • @58southwinds
    @58southwinds 5 років тому

    It works....I ran the video on my iPad in front of my PC and followed step by step...brilliant thanks.

  • @AddisonZandeWoods
    @AddisonZandeWoods 6 років тому

    Ralph, I search and find you every Christmas! You've helped me create my Christmas card mailing labels for years now! Thank you!Jill

  • @jenniferrader4869
    @jenniferrader4869 10 років тому

    Thanks for the easy-to-follow video! I read instructions on the Internet but couldn't figure it out until I watched your video. Thank you!!

  • @liliyaandriychuk4636
    @liliyaandriychuk4636 10 років тому

    You have a gift of teaching. Thank you for simplifying it. If only you taught Excel in college..I would of passed mine with flying colors!

  • @deaconmn
    @deaconmn 5 років тому

    My wife and I , who have both done this in the past, were not able to get the merge to work. Your video provided the missing piece to the step by step instructions and now I have two sheets of labels printed off. Thank you!

  • @peggieconner6913
    @peggieconner6913 10 років тому

    I have worked on this for a week and once I got onto this information I was able to do this within 15 minutes!!!!
    Thank you sooooo very much!

  • @sarahphillips495
    @sarahphillips495 8 років тому +1

    I love this tutorial.. I'm dyslexic, and wordy instructions, drive me bonkers. You were detailed precise and to the point. Very user-friendly instructions. Thanks, I learned today.. lo

  • @da1anonle
    @da1anonle 10 років тому

    You are AWESOME!! Thank you so much! :) I have 500 labels to print next week. You have no idea how much time you just saved me.

  • @danielled6541
    @danielled6541 8 років тому

    Thank you for your easy to follow video. It saved me a lot of time! I had first followed the instructions from the Word step by step mail merge and it only takes you through half the steps. I didn't understand why "next record" was appearing in the labels and thought it wasn't working properly. Their instructions were incomplete and yours were very thorough! Thanks again!

  • @darlenesirrine4525
    @darlenesirrine4525 6 років тому +2

    Can't tell you how thankful I am for you and this video. I was beginning to think I was going to have to type in all 150 names and addresses for my class reunion mailing. Very clear instructions. Thanks so much again.

  • @candicehoffman2818
    @candicehoffman2818 3 роки тому

    I can't tell you how many times I have come back to this, thank you for the quick and easy run through. SO MUCH HELP!!!

    • @SixMinutesSmarter
      @SixMinutesSmarter  3 роки тому

      Glad it helped! Mail merge is one of those things that most of us only need to do 1-2 times per year.

  • @janineheck4081
    @janineheck4081 9 років тому

    Thank you soooooo much!!! I've been battling for a few days and came across your video.. you saved my life! LOL... so easy and simple...you're a STAR!!

  • @christrayer5560
    @christrayer5560 6 років тому

    This video was phenomenal. I was not familiar at all with how to do this and my boss had asked me to extract address from our database and create labels. Wanting to show him I could do on my own and not ask questions. I found this Video - THANK YOU!!!

  • @MaCherieMcAli
    @MaCherieMcAli 8 років тому

    Saw you video this morning, and now I am trying it. And it worked perfectly. Thank you! Most appreciated.

  • @JesseniaGarciaMadrueno
    @JesseniaGarciaMadrueno 10 років тому

    Thank you, Mr. Phillips. Your tutorial was short and to the point. Got the point across so clearly that even a person with no Windows experience can understand. :)

  • @jamesettaadkins6994
    @jamesettaadkins6994 10 років тому

    Thank you so much!! First time doing a mail merge on my job and your instructions helped me tremendously. I tried all the other instructions on the internet but didn't get the accurate guidance that this instructional gave me. Thank you again.

  • @everlever7275
    @everlever7275 8 років тому +1

    Ralph i have been trying to do this all day, and your instruction was sooooo seamless... thank you! I could literally say i love you right now!!! GREAT TUTORIAL!!!

  • @granthockhomes768
    @granthockhomes768 Рік тому

    Every video was so complicated. I love that this is 10 years old and still applicable. Thank you!

  • @mkp2900
    @mkp2900 4 роки тому +1

    Thank you so much, this is by far the best tutorial on merging labels from excel to word, your tutorial saved my job, you are awesome.

  • @kaiser397
    @kaiser397 5 років тому +1

    Thanks I just spent a lot of time trying to work with Google only to find out it doesn’t work anymore. You were a tremendous help thank you very much

  • @smd2768
    @smd2768 9 років тому

    This was a huge help. I spent an hour trying to figure out how to do a simple mail merge for labels by reading the help topic on MS word and trying to play around with it on my own. Even using the wizard did not help. Once I saw this video I was able to complete my merge without any problem. Thank you so much. It's exactly what I needed. I'm much better at seeing someone else do it first. You made things so much easier for me. Thanks again.

  • @Makinbadchoices
    @Makinbadchoices 8 місяців тому

    You are an incredible instructor! I found the directory of contacts I needed for a mailer on an official website, converted the downloaded PDF to Excel and added a couple of fields, followed your instructions and Shazam! My project partners will be impressed. ;-) Also learned that easy copy/paste function of the drag bar. Very cool.

  • @peggynagle903
    @peggynagle903 3 роки тому

    Never saw this done before and wasted 2 hours trying to understand from word instructions. Thank you so much!

  • @christaljustiana-riddle2854
    @christaljustiana-riddle2854 2 роки тому

    I know this is 9 years old, but still the best! I struggled all day looking for something relevant, thank you so much! !

  • @vonbeaufen
    @vonbeaufen 10 років тому +1

    I have struggled with this for weeks and now I'm able to successfully make labels from my spreadsheet. Thank you for such a great video!

  • @lisasmithyoungs5322
    @lisasmithyoungs5322 10 років тому +1

    You are an excellent teacher! Wonderful voice modulation for teaching - calm, friendly and collected. This lesson was easy to understand and very helpful! Thank you!

  • @shaziyamanzoor1846
    @shaziyamanzoor1846 5 років тому

    Its the first time I am commenting on someone's video. You are just an amazing Mr. Ralph. A big Thank you.

  • @BeachAmbassadors
    @BeachAmbassadors Рік тому

    Wow....this video was so good and so easy to follow. I have been struggling with mail merge over the years and this video saved me SOOO much time.

  • @LorriMPhoto
    @LorriMPhoto 8 років тому

    seriously, Ralph ... you are a GODSEND!!!! I was about to lose my mind, and that's the G rated version of what i really wanted to say ..... but you were SO helpful with teaching me how to use an existing list to make labels after i spent SEVERAL hours, and a day to recoup from the near homicidal state i was about to be in over it all..... :)

  • @ritacatl
    @ritacatl 9 років тому

    OMG you are a life saver!!! Thank you SO much!! I'm moving my office and I need to send out mailing lists to let everyone know I'm moving. I called the program IT guys to see how to transport my pt info and they told me they don't offer that function! I literally would have had to figure out how to physically write out over 400 labels .... I knew there had to have been a way to do it on the computer ... OMG thank you thank you thank you!!!! Definitely subscribing!

  • @clarkfamilylife
    @clarkfamilylife 10 років тому

    This instructional video was extremely well done. I was able to get half way through the process and then thought there were issues with my Excel formatting. After watching this video, I was on the right track but needed the additional guidance to take me all the way through. Thank you!

  • @leslieoberst9248
    @leslieoberst9248 7 років тому +1

    I would have NEVER figured this out without you. Thank you!!!

  • @crazyhorsechickjulie2051
    @crazyhorsechickjulie2051 9 років тому

    Your tutorial was really good! Since I do not use mail merge on a regular basis I need to pop over to a tutorial. Thank you!

  • @manjushree90
    @manjushree90 7 років тому

    One of the best videos to learn mail merge labels. Very clearly explained! Keep it up !

  • @Mmeyer36
    @Mmeyer36 10 років тому

    Thank you so much for this tutorial. After 15 years in non-business employment, I have had a steep learning curve. This information is really going to help me out at work!

  • @576103
    @576103 7 років тому

    Thanks so much for this! We need to print labels only once a year and it takes ages to stumble through and figure out how to do it. Your video is crystal clear and makes the job simple. Thanks again!!!!!!

  • @FrankBowmanmalta
    @FrankBowmanmalta 8 років тому

    Ralph, Thank You very much, I used to do this with previous MS Win software, but it wasn't as easy as this (You can imagine).... beside the detailed and clear instruction you gave here, your voice also contributes to a relaxing educative lesson .... well done and I will continue to follow .... have a good day.

  • @ryanbartlett6672
    @ryanbartlett6672 9 років тому

    This is great..tried to work from a written set of instructions and this blew it away hands down. Great job!

  • @johnostendorf6865
    @johnostendorf6865 5 років тому

    Thanks for the easy to understand instructions. I was struggling until walking through this excellent video.

  • @debbiepayne6815
    @debbiepayne6815 7 років тому

    Thank you for your calm voice, when I wanted to chuck my computer through the window. Christmas Labels DONE!!!

  • @shereepritchett4560
    @shereepritchett4560 8 років тому

    Very nicely produced video. Its just long enough to get across the concept. I especially appreciate your commentary providing insight into what you are doing and what to look out for.

  • @AddisonZandeWoods
    @AddisonZandeWoods 5 років тому

    Ralph, I used you again this holiday to create my Christmas card mailing labels. See you again next year! Thank you!

  • @melymel81
    @melymel81 8 років тому

    Incredibly helpful - thanks so much for posting!!!! First time I have every done mail merging and labels (need for my wedding invites) - saved me from having a huge headache

  • @msdez8475
    @msdez8475 6 років тому

    Thank you so much for your directors were so much easier to follow and you did not overly babble in your instructions. It took me over an hour going through different tutorials and they were long-winded.

  • @rodrigofernandez5569
    @rodrigofernandez5569 10 років тому

    I have to wrestle with the Xmas preparation of labels. Your instructions are great and easy to understand. Thanks.

  • @lynchjan
    @lynchjan 10 років тому

    I was about to give up and handwrite my labels. Thank you so much for taking the time to make this video!!!!!!

  • @ellentrach4723
    @ellentrach4723 3 роки тому +1

    This tutorial video was the most helpful I found on the web

  • @kimenglestead4935
    @kimenglestead4935 4 роки тому

    Thank you Ralph! You walked me through the process. It help's that you have a nice soothing voice!

  • @JackieBrownSBC
    @JackieBrownSBC 7 років тому

    5 years have come and gone and this still works. Thanks.

  • @imaswt1
    @imaswt1 6 років тому

    Thank you so much!! Recently, I started my own business and my objective was to send out invitations, cards and such for my clients. I appreciated the step by step instructions!!!