Mail Merge from Excel to Microsoft Word

แชร์
ฝัง
  • เผยแพร่เมื่อ 31 พ.ค. 2020
  • Learn how to perform a mail merge from Microsoft Excel to Microsoft Word in order to produce mass mailings to a group of people. If you ever need to send form letters, this video will save you a lot of time and will teach you everything you need to know. Also watch the follow-up to this video, which covers mail merge envelopes: • Mail Merge Envelopes i... Join this channel to get access to perks:
    / @techteachersandstudents
    ***Consider supporting Technology for Teachers and Students on Patreon***: / technologyforteachersa... See my entire playlist of Excel videos: bit.ly/tech4excel Here are the practice files that go with this video: bit.ly/mailmergefiles My entire playlist of Word videos: bit.ly/2FY6NVT #excel #exceltutorial #msword #wordtutorial
  • แนวปฏิบัติและการใช้ชีวิต

ความคิดเห็น • 628

  • @talirobbins4185
    @talirobbins4185 3 ปีที่แล้ว +227

    I don't know who you are... But i love you and everything you have done. As a student in her finals, this video was extremely helpful. Thank you so much for this and what you do. You are a God send in my eyes.

    • @samzhabesha
      @samzhabesha ปีที่แล้ว +7

      Here in 2022 reading this thank you I love you too God bless you❤👍

    • @kivichishikivinotochishi4466
      @kivichishikivinotochishi4466 ปีที่แล้ว +2

      I love you too..

    • @prmath279
      @prmath279 5 หลายเดือนก่อน

      😢​@@samzhabesha

  • @ivankolev1606
    @ivankolev1606 3 ปีที่แล้ว +4

    Thank you, sir! I was trying to use Excel data for a tax form automation (57 pages per company, 71 companies in total) trough Macros and VBA, but failed superbly. This method of Mail Merge not only turned out way more easier, but it also fits perfectly for a completely different type of document requizit all along. And all thanks to you! It saved me weeks of mindless typing and copy-pasting. Cheers! :)

  • @joel4chaz
    @joel4chaz ปีที่แล้ว +5

    This was the best explanation I found and no fluff. All other tutorials talk about just merging directly but the way you explained being able to merge any information on any column in spreadsheet made a world of difference. I spent days looking for what you explained.

  • @bernadineschacht8175
    @bernadineschacht8175 3 ปีที่แล้ว +117

    Outstanding tutorial. Some of the tutorials on computer programs are so fast that you don’t have time to grasp the concepts. This one was not only informative, but delivered at a very good pace.

    • @ThanadidThingthai
      @ThanadidThingthai 2 ปีที่แล้ว

    • @godwinuche4669
      @godwinuche4669 2 ปีที่แล้ว +3

      The reason why I like his teaching is that he doesn’t rush in explaining

  • @kariziebarth7581
    @kariziebarth7581 3 ปีที่แล้ว +5

    Very helpful! You speak slowly, clearly, and you explain things well. Thanks, you're a life saver!

  • @catherinesaunders9175
    @catherinesaunders9175 3 ปีที่แล้ว +4

    Great video!! I love that you get straight to the point with CLEAR instructions. Well Done!

  • @rochellemincic4942
    @rochellemincic4942 3 ปีที่แล้ว +49

    Great information. Easy to understand and I love the step by step instructions. I would definitely be interested in an envelope tutorial as well if it's not already out!

  • @cliffp4968
    @cliffp4968 3 ปีที่แล้ว +15

    That was so great. Extremely easy to follow. You’re a great teacher

  • @veem5652
    @veem5652 3 ปีที่แล้ว +4

    Thank you for the EXCELLENT tutorial. I serve on a board and was tasked with creating a mail merge. I was terrified! After watching your tutorial, I feel I can confidently create the mail merge. Thank you so much!

  • @LizaLiza-jk4zh
    @LizaLiza-jk4zh ปีที่แล้ว

    This was the first video on mail merge I watched; I don't need to watch another because it was very complete and thorough. Also you spoke at a normal pace I could follow without needing to manually slow down the speed of the video. Job well done! Thank you very much!

  • @wdwbsu1
    @wdwbsu1 2 ปีที่แล้ว +4

    This tutorial saved me a ton of time and work. It was so easy to understand and follow. I had no idea Word and Excel could do this. When I need help with other tasks, I will be looking up this channel. Thank you for posting this.

  • @cambriebarnes7387
    @cambriebarnes7387 3 ปีที่แล้ว +9

    Thank you for teaching me what my professor couldn't! this saved my life

  • @leximusmaximus4593
    @leximusmaximus4593 4 ปีที่แล้ว +18

    Excellent presentation, clear and explained perfectly.

  • @tula__
    @tula__ 2 ปีที่แล้ว +8

    This whole video was worth it. No minutes wasted. And every thing covered well. 👏🏼

  • @80snewromatic
    @80snewromatic ปีที่แล้ว +1

    Clear. Concise. Articulate. Thank you! Finally a video which is easy to understand! You're the Best!!

  • @vahneb7260
    @vahneb7260 4 ปีที่แล้ว +29

    Excellent! Thank you. Yes, a tutorial on envelopes would be appreciated.

  • @alademi
    @alademi 2 ปีที่แล้ว +1

    You are a lifesaver, very detailed and covered most of the aspect of this function in an clear way. WONDERFUL.

  • @michelleharuzi462
    @michelleharuzi462 3 ปีที่แล้ว +21

    That was a great tutorial! Thank you! Very clear and very helpful! I like how you went over possible problems and how to fix them. I’m interested in the envelope tutorial :)

  • @krystlemiller5786
    @krystlemiller5786 3 ปีที่แล้ว +4

    Wow!! You sir deserve all the flowers for such a clear and easy to follow video.

  • @trueleyes
    @trueleyes 2 ปีที่แล้ว +3

    WHAT A GREAT TUTORIAL. You have covered so many aspects of this function and with great clarity and flow of knowledge. Thank you so much for this tremendous wealth of knowledge for us who do a lot of mailings. This one is a KEEPER.

  • @dashandcrows
    @dashandcrows 2 ปีที่แล้ว +1

    Brilliant - I really like the way this is explained so clearly without any unnecessary information. Exactly what I needed.

  • @michaellay5264
    @michaellay5264 2 หลายเดือนก่อน +2

    You are a god send for this. I spent 2 hours trying to figure it out on my own before I stumbled upon your video. Bravo sir.

  • @mrarronax
    @mrarronax 3 ปีที่แล้ว +1

    Excellent tutorial! Clear, concise and includes all important information.

  • @Linda0827able
    @Linda0827able ปีที่แล้ว +1

    Wonderful refresher if you haven't done mail merges recently. Well-organized presentation of steps and tips with great presentation. Thank you!

  • @123Bangtan
    @123Bangtan 3 ปีที่แล้ว +2

    Our teacher sent this to us to educate ourselves about mail merge. Didn't expect to like the video. You explained it very well! Thank you!

  • @tandygrant6288
    @tandygrant6288 3 ปีที่แล้ว +7

    This presentation was very detailed and well explained. Thank you

  • @pratikdash3436
    @pratikdash3436 2 ปีที่แล้ว +4

    2 mins silence for the people who thought this email was sent to them personally by the designated owner.

  • @ArielVisionary
    @ArielVisionary 3 หลายเดือนก่อน

    Thank you very much. In my secretarial career, I used to do mail merges fairly often, but it's been several years since I retired and I just needed a refresher. I was most impressed with a feature that I never used before, and that's to use mail merge to send to email addresses. Cool!

  • @niyabellaqua
    @niyabellaqua 3 ปีที่แล้ว +2

    Oh I found your video just when I needed it. Thank you so much for the tutorial. Really appreciate it.

  • @cosmobabe1733
    @cosmobabe1733 2 ปีที่แล้ว

    Great video! Straight to the point without useless information, thanks!

  • @betsywalker8904
    @betsywalker8904 3 ปีที่แล้ว +1

    Excellent demo. Clear and concise. Good job!

  • @investbrilliantly-
    @investbrilliantly- ปีที่แล้ว +2

    I coach & teach people for a living. I really appreciate your teaching style.

  • @jrstream5653
    @jrstream5653 3 ปีที่แล้ว +5

    All i can say is THANK YOU! THANK YOU!💓. you saved my life😇

  • @325TX
    @325TX ปีที่แล้ว

    Finally, I could do it. In the past I tried to rely on Microsoft web sites for instructions. But they were very poorly done. This video made it very clear and easy to follow. Thank you.

  • @darreledunbar3661
    @darreledunbar3661 4 ปีที่แล้ว +4

    Envelopes would be great! Thanks for making these videos!

  • @user-fi2tt8bh2u
    @user-fi2tt8bh2u 2 หลายเดือนก่อน +1

    WOW! This tutorial is exactly what I was looking for and exactly what I needed-thank you for the clear and concise step by step instructions.

  • @hchinchilla1
    @hchinchilla1 4 ปีที่แล้ว +1

    The tutorial was very clear and helpful. Thanks much. Yes, tutorial for envelopes would be very welcomed.

  • @annbrett9524
    @annbrett9524 2 ปีที่แล้ว

    Thank you for this tutorial, you speak slowly, clearly so I could understand what needs to be done. Very greatful :)

  • @daverobinson675
    @daverobinson675 3 ปีที่แล้ว

    Thank you - it's been awhile since I've done a mail merge and this is an excellent refresher. Much appreciated!

  • @jamiejohampton3738
    @jamiejohampton3738 3 ปีที่แล้ว +2

    Wonderful step by step!!! Thank you so much!

  • @lheivp_0633
    @lheivp_0633 4 ปีที่แล้ว +5

    Nice vid...
    Great presentation, simple explanation and informative.
    Thank u.
    👏👏👏

  • @lissyjohnson7561
    @lissyjohnson7561 3 ปีที่แล้ว

    Excellent!! This really refreshed my memory. Clearly explained! Kudos to you !!!!!

  • @jaydesamuels2366
    @jaydesamuels2366 4 ปีที่แล้ว +1

    100000× better than any other tutorial. You save me big time . Thanks alot sir.

  • @rajkumarcharotari1866
    @rajkumarcharotari1866 2 ปีที่แล้ว +1

    It was a very informative and understandable process. The speed at which it was explained it was easy to understand. Thank you very much.

  • @MrDrewpappas
    @MrDrewpappas ปีที่แล้ว +3

    Great video! Concise and to the point. Very helpful. Thank you!

  • @shirleendubuque3165
    @shirleendubuque3165 4 ปีที่แล้ว +2

    Excellent tutorial! Thank you.
    Yes! Please do an envelope merge tutorial.

  • @mka70
    @mka70 2 ปีที่แล้ว

    Outstanding! This made everything so clear and easy to follow for me. Thanks so much.

  • @elizabethserling3317
    @elizabethserling3317 3 ปีที่แล้ว +1

    This was extremely helpful as it made Mail Merge accessible.

  • @zee6066
    @zee6066 3 ปีที่แล้ว +8

    i'm a fresh grad who just started working in HR and this really helped. thank you!

    • @bebaifa0301
      @bebaifa0301 3 ปีที่แล้ว +1

      me too! and it helps a lot!

    • @zee6066
      @zee6066 3 ปีที่แล้ว

      @@bebaifa0301 Ooo a fellow malaysian? Wishing you luck with your career! InshaAllah we’ll both prosper ☺️

  • @aletaboydable
    @aletaboydable 3 ปีที่แล้ว

    THANK YOU! THANK YOU! THANK YOU! So clear, not to fast and easy to follow. THANK YOU!

  • @wilcojunkie
    @wilcojunkie 3 ปีที่แล้ว

    I use mail merges all the time at work and didn't know some of this. This will make my job a lot easier. Thanks!

  • @ufamartialartsacademy376
    @ufamartialartsacademy376 4 หลายเดือนก่อน +1

    I know this is an old tutorial but it is one of the best tutorials I have watched. It was a very clear and informative tutorial, thank you.

  • @gsantana0209
    @gsantana0209 3 ปีที่แล้ว

    Thank you, I really needed this refresher. I helped me remember how easy it is to mail merge documents.

  • @danywech5772
    @danywech5772 2 หลายเดือนก่อน +1

    Thank you for this new skill..saves a lot of time especially in HR when drafting several letters to staff members

  • @theesimson6182
    @theesimson6182 3 ปีที่แล้ว +5

    Excellent presentation as I am preparing for my examination

  • @mitsuomits9077
    @mitsuomits9077 2 ปีที่แล้ว

    This was very well explained and exactly what I was looking for. Also, you have very good communications skills. Thanks so much for the valuable information!!!

  • @MrPhilippeleduc
    @MrPhilippeleduc 2 ปีที่แล้ว

    Incredibly thorough and well explained.

  • @ivannaidoo1236
    @ivannaidoo1236 2 ปีที่แล้ว

    Excellent tutorial. Clear and precise.
    Much appreciated sir!

  • @kikikat9822
    @kikikat9822 3 ปีที่แล้ว

    Hi, I found this very helpful. I confuse easily so I really appreciate your teaching; clear concise. I was able to to do it along with you. I erred of course, then I only had to go back and rewatch and retry. Thank you so much. 🙂

  • @arthurlyons5609
    @arthurlyons5609 หลายเดือนก่อน

    AWESOME JOB. I was able to pause and follow the steps on my actual letter while following along. This saved me time and money paying a VA to do it! Im going to see what other tips you have ha!

  • @Bubbstar
    @Bubbstar 2 ปีที่แล้ว

    One of the best software tutorials I've ever witnessed

  • @sundishine2
    @sundishine2 3 ปีที่แล้ว

    You are so awesome! Thank you for this. So easy to do when you can follow along. Got my mail merge done in no time. Thank you, thank you, thank you!

  • @DarlingbroughSciFiBuilds
    @DarlingbroughSciFiBuilds 9 หลายเดือนก่อน

    Thank you for the tutorial! You saved me probably about 3 hours of work today using this technique! Really appreciate it!

  • @faizyfy
    @faizyfy 2 ปีที่แล้ว

    Very well explained. Your pace was so satisfying to my learning.
    Thank you.

  • @marianneroth1134
    @marianneroth1134 2 ปีที่แล้ว

    This was outstanding! One of the best tutorials I have seen. Thank you

  • @nunyabusiness2127
    @nunyabusiness2127 3 ปีที่แล้ว

    Great step-by-step explanation. Thank you!

  • @jaksoniatransportation640
    @jaksoniatransportation640 3 ปีที่แล้ว

    I followed every step, and understood everything, and every step. Great Job, I'm on my way to success

  • @anitantakarutimana5677
    @anitantakarutimana5677 2 ปีที่แล้ว

    Thank you for the video. The instructions are clear, easy to follow. I managed to do my assignement right away after watching the video. Thanks again.

  • @ShafiMukhtar
    @ShafiMukhtar 11 หลายเดือนก่อน

    Awesome video! Straight to the point, easy to follow!

  • @davidschweisthal7944
    @davidschweisthal7944 2 ปีที่แล้ว

    Great Tutorial. Thank you for simplifying this process!

  • @sallymoseley5266
    @sallymoseley5266 3 ปีที่แล้ว +2

    Thank you! That was just what I needed, and you made it easy to do.

  • @xyzabc1560
    @xyzabc1560 3 ปีที่แล้ว

    Another informative and, as usual, clearly articulated video. Thanks! :)

  • @HEATHERCHAIT
    @HEATHERCHAIT ปีที่แล้ว

    Tremendous tutorial and your voice is so easy to listen to. Thank you!!

  • @GEedify
    @GEedify ปีที่แล้ว

    This was so helpful, thank you for the step-by-step guide. You are just exceptional.

  • @edwardlukefernandez6314
    @edwardlukefernandez6314 8 หลายเดือนก่อน

    You are really a great teacher.I should have attended your classes earlier..This video is very helpful as I m preparing for an interview on computer proficiency and this has gained confidence for me.Thankyou so much and looking forward for more such helpful videos.God bless you...

  • @amuthavanoptisol9997
    @amuthavanoptisol9997 3 ปีที่แล้ว +1

    Thankyou Very Much. It Saves a lot of Time.

  • @richardcandia-realestatean3543
    @richardcandia-realestatean3543 3 ปีที่แล้ว +1

    very clear and helpful. Thank you for sharing!

  • @karaten6471
    @karaten6471 3 ปีที่แล้ว

    That was awesome! Exactly the info I needed! Very well explained. Thank you very much!

  • @juliethomas1469
    @juliethomas1469 2 ปีที่แล้ว

    Definitely, a very expressive, impressive tutorial.

  • @RojaJaneman
    @RojaJaneman 3 ปีที่แล้ว +2

    This was absolutely fantastic!!!
    Thanks 🙏 soooooo..... much!! 😊

  • @ElaineSarters
    @ElaineSarters ปีที่แล้ว

    Great tutorial. Steps are clearly explained along with the other possibilities and dont's of the process. I am interested in the mail merge envelope tutorial as well.

  • @danielamairena5739
    @danielamairena5739 9 หลายเดือนก่อน

    Thank you for this. Such a detailed, easy to follow tutorial.

  • @justinwduff
    @justinwduff 2 ปีที่แล้ว

    Great tutorial, exactly what I needed. Thank you.

  • @barbaraferrero9599
    @barbaraferrero9599 2 ปีที่แล้ว

    This tutorial is sooooo clear!!! THANK YOU SO MUCH

  • @administrativeassistant3371
    @administrativeassistant3371 3 ปีที่แล้ว +7

    This video was very helpful for the collection accounts I need to mail over 3000 letters out.

  • @jellywei0903
    @jellywei0903 3 ปีที่แล้ว +1

    Thanks for the clear guidance!

  • @amandaschmidt8769
    @amandaschmidt8769 9 หลายเดือนก่อน

    This was very helpful and exactly what I needed. THANK YOU!

  • @elycuaresma88
    @elycuaresma88 3 ปีที่แล้ว

    Thank you for sharing all the topics for Excel. Your Great. I learned a lot. Thank you again.More power to you.

  • @linda.cooks.
    @linda.cooks. 2 ปีที่แล้ว

    Amazing! So helpful and understandable.
    Thank you!

  • @yoursassyrealtor
    @yoursassyrealtor ปีที่แล้ว

    This was very helpful! Thank you so much for this tutorial!

  • @royz6080
    @royz6080 3 ปีที่แล้ว

    was not listening to my teacher, glad there's this video thanks!!

  • @olielapz3534
    @olielapz3534 2 ปีที่แล้ว

    You SIR are a great Teacher! Wish I had you in my High School and Uni days!

  • @Bensuism
    @Bensuism 3 ปีที่แล้ว +1

    Very helpful. Thank you.

  • @shamimejaz6350
    @shamimejaz6350 2 ปีที่แล้ว

    Excellent! I found it informative and very useful after i browse through a dozen of tutorials.

  • @cdreg9133
    @cdreg9133 ปีที่แล้ว

    Thank you so much for this great video. I haven’t done a mail merge since 2006 so I forgotten a lot. at first I almost had a heart attack when I saw it was 15 minutes but then I remembered why it takes 15 minutes to explain a mail merge, lol. You’re great and thank you for such an amazing video.

  • @rk8128
    @rk8128 2 หลายเดือนก่อน

    Appreciate you for sharing this wonderful tut!

  • @Bestdayever73
    @Bestdayever73 3 ปีที่แล้ว

    thank you - that was so clear and concise. Just what I needed to watch.

  • @maxx6050
    @maxx6050 2 ปีที่แล้ว

    The instructions are extremely helpful. Thank you!

  • @thomasjohnson3265
    @thomasjohnson3265 2 ปีที่แล้ว

    Thanks for doing this. I used it for names on certificates for National Honor Society and you saved me a lot of typing.

  • @prasadchappa3729
    @prasadchappa3729 ปีที่แล้ว

    Great explanation.... Easy way to understand each option .... Thank you. It helps my working efficiency as well as my developing my skill knowledge.