Mail Merge from Excel to Microsoft Word

Рет қаралды 2,546,657

Technology for Teachers and Students

4 жыл бұрын

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

Пікірлер: 638

@joel4chaz Жыл бұрын

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.

@talirobbins4185 3 жыл бұрын

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 Жыл бұрын

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

@kivichishikivinotochishi4466 Жыл бұрын

I love you too..

@prmath279 6 ай бұрын

😢@@samzhabesha

@bernadineschacht8175 3 жыл бұрын

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 2 жыл бұрын

บ

@godwinuche4669 2 жыл бұрын

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

@ivankolev1606 3 жыл бұрын

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

@rochellemincic4942 3 жыл бұрын

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!

@catherinesaunders9175 3 жыл бұрын

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

@kariziebarth7581 3 жыл бұрын

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

@wdwbsu1 2 жыл бұрын

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.

@veem5652 3 жыл бұрын

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!

@cliffp4968 3 жыл бұрын

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

@LizaLiza-jk4zh 2 жыл бұрын

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!

@leximusmaximus4593 4 жыл бұрын

Excellent presentation, clear and explained perfectly.

@cambriebarnes7387 3 жыл бұрын

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

@tula__ 2 жыл бұрын

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

@nurainshuhadah6762 9 ай бұрын

88888888888

@michelleharuzi462 3 жыл бұрын

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

@trueleyes 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 2 жыл бұрын

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

@alademi 2 жыл бұрын

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

@vahneb7260 4 жыл бұрын

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

@michaellay5264 3 ай бұрын

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.

@ArielVisionary 4 ай бұрын

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!

@80snewromatic Жыл бұрын

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

@123Bangtan 3 жыл бұрын

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!

@investbrilliantly- Жыл бұрын

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

@tandygrant6288 4 жыл бұрын

This presentation was very detailed and well explained. Thank you

@jrstream5653 3 жыл бұрын

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

@krystlemiller5786 3 жыл бұрын

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

@Linda0827able Жыл бұрын

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

@brendanthomas7873 3 жыл бұрын

Very helpful for schools report ✍ writing.

@mrarronax 3 жыл бұрын

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

@niyabellaqua 3 жыл бұрын

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

@325TX 2 жыл бұрын

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.

@betsywalker8904 4 жыл бұрын

Excellent demo. Clear and concise. Good job!

@daverobinson675 3 жыл бұрын

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

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

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

@cosmobabe1733 2 жыл бұрын

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

@administrativeassistant3371 3 жыл бұрын

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

@darreledunbar3661 4 жыл бұрын

Envelopes would be great! Thanks for making these videos!

@ufamartialartsacademy376 5 ай бұрын

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.

@jaydesamuels2366 4 жыл бұрын

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

@user-fi2tt8bh2u 3 ай бұрын

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 4 жыл бұрын

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

@danywech5772 3 ай бұрын

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

@DarlingbroughSciFiBuilds 10 ай бұрын

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

@gsantana0209 3 жыл бұрын

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

@annbrett9524 2 жыл бұрын

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

@sallymoseley5266 4 жыл бұрын

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

@theesimson6182 3 жыл бұрын

Excellent presentation as I am preparing for my examination

@lissyjohnson7561 3 жыл бұрын

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

@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. 🙂

@jamiejohampton3738 3 жыл бұрын

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

@ivannaidoo1236 2 жыл бұрын

Excellent tutorial. Clear and precise. Much appreciated sir!

@elizabethserling3317 3 жыл бұрын

This was extremely helpful as it made Mail Merge accessible.

@rajkumarcharotari1866 2 жыл бұрын

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

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

@lheivp_0633 4 жыл бұрын

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

@MrDrewpappas Жыл бұрын

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

@emilyward4556 Жыл бұрын

Thank you

@mka70 2 жыл бұрын

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

@claudegelinas903 28 күн бұрын

what a easy explanation, I will buy one of your shirt, you've saved me sooooo much time!

@marianneroth1134 2 жыл бұрын

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

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

@edwardlukefernandez6314 9 ай бұрын

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

@shirleendubuque3165 4 жыл бұрын

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

@xyzabc1560 3 жыл бұрын

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

@zee6066 3 жыл бұрын

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

@bebaifa0301 3 жыл бұрын

me too! and it helps a lot!

@zee6066 3 жыл бұрын

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

@MrPhilippeleduc 2 жыл бұрын

Incredibly thorough and well explained.

@arthurlyons5609 2 ай бұрын

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!

@anitantakarutimana5677 3 жыл бұрын

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.

@GEedify 2 жыл бұрын

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

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

@richardcandia-realestatean3543 3 жыл бұрын

very clear and helpful. Thank you for sharing!

@karaten6471 3 жыл бұрын

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

@aletaboydable 3 жыл бұрын

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

@jaksoniatransportation640 3 жыл бұрын

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

@RojaJaneman 3 жыл бұрын

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

@barbaraferrero9599 2 жыл бұрын

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

@2ltnavarropaf228 5 ай бұрын

Thank you for sharing this video! Helped me a lot for my tasks for today, I'm also very happy to learn. Now I can stop copy pasting everything for several letters. Again, thank you!

@linda.cooks. 2 жыл бұрын

Amazing! So helpful and understandable. Thank you!

@juliethomas1469 2 жыл бұрын

Definitely, a very expressive, impressive tutorial.

@Bubbstar 2 жыл бұрын

One of the best software tutorials I've ever witnessed

@nunyabusiness2127 3 жыл бұрын

Great step-by-step explanation. Thank you!

@davidschweisthal7944 2 жыл бұрын

Great Tutorial. Thank you for simplifying this process!

@clarisseg4868 3 жыл бұрын

Thank you for this. This helped me a lot!

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

@justinwduff 2 жыл бұрын

Great tutorial, exactly what I needed. Thank you.

@sonyalowrie2687 4 жыл бұрын

Thank you so much this helped me with work. 🤗

@faizyfy 2 жыл бұрын

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

@jongirodes 3 жыл бұрын

This was fantastic and just what I needed. Thank you.

@dashcane1 2 жыл бұрын

Thank you Sir for such an informative video. You have each and everything step by step so a beginner like me understood and successfully created my mail merge in first attempt.

@amuthavanoptisol9997 3 жыл бұрын

Thankyou Very Much. It Saves a lot of Time.

@yoursassyrealtor Жыл бұрын

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

@danielamairena5739 10 ай бұрын

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

@gracekyengo8855 3 жыл бұрын

clearly explained, thank you

@anvitadatt2768 2 жыл бұрын

The video is wonderful, it cleared all my doubts😃my half yearly exams are on the way and I am sure I am going to do the examination gracefully. Thank you a lot🌹🌹