How to Mail Merge in Word, Excel & Outlook

[@KevinStratvert]

🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com ⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: kzbin.info/aero/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY ✉ Mail Merge with Attachments, Custom Subjects, CC / BCC others, or set the default email address: kzbin.info/www/bejne/r5vCpGaZmcuJers 🆓 Don't have Microsoft Office? Mail Merge for free using WPS Office: kzbin.info/www/bejne/Y5y7oJmYaa6Gj9k

[@ra8784]

I am taking this video and using it for something... Evil. Pure burning evil.

[@KRSportsVideo]

Make sure you read the comment by Chana Ellman before watching this video!

[@stormsentertainment5270]

Apple recipe reference. 🎉

[@marisolkiffen8634]

I’m watching this video a night before my CAT exam and I hope it helps 😭😭

[@TengBermudez]

My boss asked me if I was familiar with mail merging, and thanks to watching your Excel tutorial video, my colleagues now have a newfound respect for me. They are impressed by my knowledge and think I possess various skills. About 30 minutes ago, my boss inquired if I could handle mail merging, and confidently, I responded affirmatively. I promptly referred back to your tutorials, where I learned how to perform the task. As a result, my colleagues have even more confidence in my abilities and regard me as someone knowledgeable. Thank you very much Mr. Kevin

[@HolyMoly919]

are you still doing good at work?

[@jorgeoteo]

Just sent an invitation for a webinar for 100 clients; the time invested looking at this video is well worth it-- it defintely beats copying-and-pasting X 100!

[@beamurray6044]

I've watched several videos on how to do this and this is the first one that actually made sense and that I've been able to reference back to. Thank you so much!

[@peggymunoz]

You did a great job but I think this should be added to the lesson. I found this in the comments below. "Heads up folks, if you’re doing emails, Outlook may send them automatically instead of leaving them sitting in your outbox. If you prefer to double-check your emails before sending, you need to turn off Automatic Send/Receive. To do this, go to File --> Options --> Advanced, and then scroll down to “Send and Receive”. Uncheck the box there, and also open the settings (by clicking the Send/Receive… button) to make sure there are no other settings that might make your messages send automatically. Don’t forget to turn it back on when you’re done with your mail merge!"

[@Trending_songo9838]

Full video on my channel how to setup outlook and how to add email and send bulk emails .

[@glendadalton7525]

This just happened to me. I had to recall about 30 emails without attachments.

[@ActuallyDoubleGuitars]

Thank you! this is the exact question I had.

[@rachaelmay0]

This was also my need, I want a draft first so I can go back in an do final hyperlinks or attachment specific to individuals, but using mail merge to generate the initial draft to save time.

[@nicholasdoliszny7231]

Thanks for that tip. For some reason my mail merge doesn’t sent emails. I did all the steps, preview is working. Clicked finish and send emails and nothing is coming out. Went to file-options -advanced, scrolled down, but there is no such option to check/ uncheck send and receive 🤔🤔

[@estelabalderas4892]

I did it! Though you may want to warn folks that once you click send email, it's actually sent and not put in a draft folder so you have to be sure about the email before the final click.

[@youngkim6720]

Thank you sooooo much. I work in an industry that requires me to email my warm leads and I couldnt use third party email marketing websites due to company compliance reasons and access rejects, but we do use outlook emails and excels. This tip is literally going to save me 2 hours every single day and that is MONEY!! Thank you so much again!

[@annaprzychodzen5780]

Kevin, thank you very much~! I've done this last few times with your video, and now even if I already know how to do it I feel much safer with your voice in the background :)

[@EuropeanWorldTraveler]

I discovered your channel a few weeks ago. You have taught me so much, and I've learned shortcuts and other interesting features I didn't know about before. Your teaching manner is easy to understand and follow, precise and informative. Keep up your good work.

[@leadscapeadvisors7705]

Excellent. So clearly explained. After grappling with this problem for so many days, I could do this in minutes. Thank you!

[@walomac]

Finally a tutorial that shows the last step, how to actually send the emails. I have watched 4 before and they all missed that very important step! Love it. You just gained a suscriber :)

[@susanbenzel3976]

Perfect - exactly what I needed!

[@andrewmcallister-f6v]

Hi Kevin, I am an IT professional, but don't do a lot of mail merge tasks, so..... I did a quick search. I found your video by far the easiest to follow and get straight away. You have a good pedagogic stile. concise and clear. Thank you.

[@alysha6770]

THANK YOU! I had to do this for an assignment and was clueless before seeing your video.

[@carolynhill6306]

Txs Kevin. Your videos are so darn helpful! Email Merge is something I rarely do, but I knew you'd have a video for it. It's now saved under a special KZbin folder for all the handy videos you create. Thanks a bunch. You're a life saver.

[@leemarattan9700]

This demonstration was awesome! Thank you so much Kevin.

[@aliyaha.3222]

Let me boost your confidence then, I’m literally seing the end of tunnel in my job search thanks to your videos. Short, concise with clear examples. Thank you soooooo much.😊

[@ehabal-ani9102]

Thank you! for this amazing video, but I need to ask you, how to choose from which email account to send the emails, as matter of fact I have 5 email accounts in MS Outlook, thanks again and keep the amazing work on.

[@RussellWalshAIMDirect]

Did you ever get an answer?

[@ehabal-ani9102]

​@@RussellWalshAIMDirect I've looked around and tried many attempts, I managed to choose between the accounts as long as there is no Outlook account among them, you can choose the account you want to send from as your default account by clicking on the account settings choose your account then click "set as default". But this didn't work when my Outlook account was among the Gmail accounts, therefore I deleted my Outlook account.

[@PMA-so4wt]

I'm too embarrassed to say how many years I've been trying to use mail merge - this tutorial finally helped me crack it! Wish I had tried this all those years ago. Thank you so much

[@KevinStratvert]

Glad it helped!

[@admiralkidd]

Kevin, Thanks so much! You answered all of my questios with ease.

[@sarvank669]

I browsed through lot of mail merge videos but I found this one is very easy to follow up. Kudos Kevin for this wonderful time saving video.

[@tonybrylski7909]

This was so helpful, my boss sent this to me so I can learn it during remote. Is there a way to adjust to send from a different account in my outlook?

[@dfents]

In Outlook go to File > Account Settings and then set as default the email account from which you want to send.

[@chrisholben6180]

KEVIN MY MAN YOU'VE SAVED ME DAYS OF WORK, I WAS CREATING 250 NEARLY IDENTICAL DOCUMENTS AND NOW I CAN JUST MAKE LIKE 5

[@lorettaguerra1542]

Kevin, this was really great and exactly the help I needed! I appreciate you so much for this. Question: If I have an alias email box versus my personal email box, I presume I should have the alias email box open before I begin this process so that the emails come from the alias and not from me, correct?

[@estelabalderas4892]

I have the same question.

[@samanwahedazez1204]

ةة

[@SharonJackson-d7z]

This was exactly what I was looking for. Thank you for the step-by-step instructions. :)

[@andrichvitug9462]

This is great! Just the type of tutorial I need. Straight forward and easy to follow. Keep it up, Kevin!

[@ashrei26]

I think you just changed my life! I'm thinking of all the ways this is going to simplify our bulk mailings!

[@Raphael-zl5jb]

Great overview but is there any way of changing the 'from' email when you have access to multiple inboxes?

[@onelifeonetransformation]

I have the same question. Also could we CC anyone in these mails?

[@MrRakeshkiran]

Very Nice Bro - It worked for me - Till date Mail Merge is Big Block for me and you made me to learn this is less than 10 mins. Keep Shining and let us to shine more with your tutorials.

[@comehenry8075]

BRO YOU ARE THE BEST YOU EXPLAINED EVERYTHING I NEEDED TO KNOW THX

[@poerc]

Thanks so much for making this! I used to do mail merges and it's been so long I've forgotten all of it.

[@tenc6491]

Thank you. Explained beautifully! You've earned a subscriber!

[@teabaggins3517]

Best tutorial I could find. No bullshit and unnecessary explanations. Thank you!

[@SaanjD]

This was so helpful and explained perfectly, thank you Kevin

[@vermabalraj]

Kevin you have very nicely explained mail merge. I would like to suggest only one thing that you should record the video little zoomed so that it becomes easy to read as well. Otherwise its outstanding and awesome.Thanks for putting up the tutorial.

[@SkromnitsaKrasotka]

I agree, and no need to see the person`s video :-)

[@tashapalmer4519]

Thank you so much. I've been putting off a task for months. The written instructions online weren't making a whole lot of sense and then I thought to see if there was a video on KZbin. You've saved me so much time :)

[@feliciameredith8254]

Thank you for this easy to following video. I just had one problem, when I opened Outlook the emails had been sent. They did not go to my outbox. Did I miss a step or do I need to adjust settings in Outlook?

[@chrismorley2560]

I think this is a setting on outlook you need to change.

[@LauraaMichellle]

@@chrismorley2560 What setting is this?

[@anesethemi5054]

If you want to delay the send, before you initiate mail merge, set Outlook into offline mode. This will allow you to review the emails before they go out. Once you're comfortable with the emails, simply toggle Outlook back online.

[@neginkord5057]

You are a life saver! I spent days trying to do this through VBA macro, almost gave up and your video popped up! THANK YOU. I'll be sure to follow your other videos as well. :)

[@cybercruiser69]

Is there a way to change the FROM: email different from the person that is sending the eMail merge??

[@itguy5192]

@Aye-B I need to know whether this can be automated or not: I get one raw data details on excel sheet on mail with attachment, this attached excel sheet gets automatically downloaded to certain location and then macro runs on that excel file as per schedule and then that excel sheet is send to several email addresses as per schedule without human intervention? What is required to do this automation?

[@procurementhmpl438]

Hi Kevin, I am from India, I do watch your videos to learn. Keep Posting.. Your way is simple and good.

[@kavyanageshkandala5983]

I can’t thank you enough for uploading such simplified tutorials for non techie person like me ! Thank you soo much !!

[@niranjanself7453]

NICE EXPLANATION WITH SIMPLE EXAMPLE WHICH IS VERY EFFECTIVE, THANKS KEVIN

[@carmenjohnson9733]

I’ve done mail merge for years and didn’t realize you can use mail merge for e-mails. Thank you! Question: How can we send mass e-mails in Outlook and include attachment? Carmen 😊

[@buzwefani6984]

Was there a response @carmen?

[@TRTPRODS]

Thank you.... you were very clear in your direction and instructions. I took me 3 videos to finally get to yours and OMG... you made it so easy and it made sense. I guess there's a reason you have 1.39M Subcribers. Thank you.

[@caitlinmorehouse3576]

This helped me prepare for my job interview today! Thank you Kevin!!

[@sharonkrone9021]

super helpful and succinct. thanks. nice dual camera detail!

[@channahbridgemantorres5698]

Thank you Kevin. You are an excellent trainer! Very professional, engaging tone, concise, clear instructions and examples.

[@sarahfraser8965]

Your videos are my go to videos for all the new digital work on Office 365 that I now have to do. Clear, no waffling and straightforward.

[@jor771572]

Thank you, Kevin, for this tutorial! You don't know how much time I have saved by doing mail merge with Outlook! Keep up the magnificent work in your channel.

[@royyanapreston2377]

Just totally used this to send out 116 emails that I was instructed to send manually! Saved me soo much time!

[@iamajblove]

Before this video, it was kinda difficult for me to do, and now i am master in it. Thank you so much ❤

[@MsMcGillivray]

So so easy!! I feel like an idiot but I rarely have to mail merge, the few times I have, I go straight to this tutorial for perfect easy peasy instructions! Don't get me wrong, I literally have to do it step by step and pause here and there while I get it together but it works perfectly every single time!

[@adriennemulkey9718]

Thanks for the help Kevin! I have had to come to your videos for help multiple times to get me through schooling that I'm having to pay a ton for!

[@PeenTip]

I am currently taking an application integration class as one of my core classes and the video lesson as well as the book they have us reading made this appear confusing. Watching this video made it much easier to understand by applying it to a real world scenario. Thank you very much for this!

[@justakiss15]

Thank you so much !!! My director asked me to send 300 mail merge emails, I accepted without having a clue how to do it... 7 minutes later now I know!

[@stevenfairlie3407]

Brilliant, thanks Kevin. Easy to understand and you have a very amiable nature.

[@tobydunnagan]

I have used this video multiple times. Thank you sir!

[@nnedland]

Just found this, got it within minutes. Really appreciated. Saved me so much time.

[@t.g2089]

Thank you, Kevin. This is just what I need for my new job.

[@sylvielecourtois4443]

Never used mail merge before and your video was very informative and so easy to understand Thank you..

[@amanjitgill3396]

Oh wow. You're a legend. I'm a former software developer, so I'm pretty handy with computers. But I just don't have the time to faff about, figuring out new things. So this video is a godsend. Thank you!!

[@amanjitgill3396]

Oh, and I'm subscribing now!

[@munibahmadxx]

Very helpful. I've watch few videos regarding this topic, but your explanation is comprehensive.

[@llawliet4889]

Thanks Kevin! You're videos have helped me so much! I really appreciate you!

[@nrmilford9316]

Thanks Kevin, very helpful. Saved me from bothering a co-worker who always does this for me.

[@qone2363]

Fantastic tutorial. I needed something quick and easy to learn and this fit the task very well!

[@arnauita1]

OMG THANK YOU, Kevin. You just saved me literally dozens of hours of work.

[@nedaari1]

This video is still helpful. Feel like I watch it once each year.

[@iriswong3233]

Thank you so much for sharing this video, and all other videos. It saved me a lot of time to generate >100 emails today. Your videos are always easy to understand.

[@avisilverman5224]

Chana that instruction was very helpful. Keven, well explained presentation. I am not computer savvy, but was able to send after watching the video and doing the steps with you.

[@hasan_nisthar744]

oh man thank you i watched this 30 mins bfr my exam helped a lot

[@jamesgraber3727]

Brilliant! A colleague shared this video and what a great help. Thank you Kevin!

[@RonDuckett]

Dude you have helped me out of some tight situations, thanks!

[@Artech.Ranjit]

Its great hidden feature, We can skip lot of steps designing RPA by doing this. Excellent for broadcast emails for sales etc..

[@belaazores]

I love your videos! many thanks for doing them. I have used several of your videos now so I am a fan. Thank you! :)

[@margaretseibert5604]

I am trying to send emails like you show in this video, but when I get to the Finish and Merge step, the choice to Email is grayed out. I've looked up several reasons why but can't find.

[@vinny1995]

Upvoted and Thanks! The tip I needed was to select the"Insert Merge Field. I did everything right but it didn't work until I did that step. So glad you mentioned it early on in your video! (I'm sure the rest of your video was great!)

[@lantizzle]

Very helpful and easy to follow! Thank you!

[@missmjl2468]

so satisfying to see them all go.....Thanks!

[@braswellphilidian]

Short and sweet…thanks!!!

[@earthtrack]

Thank you for this tutorial Kevin, Really good stuff. Keep it up :) I like the way you are straight to the point and keep it short. (Liked and subscribed)

[@AyushSingh-js3rf]

Love the way you changed aspect ratio of your desktop for recording in 16:9

[@sumansen1807]

Very useful video with hands-on demo.

[@mamoeketsimusa2541]

You made it so easy, thank you Kevin

[@TheStoudtLife]

Thank you so much, this was a life saver when I needed to send out 57 "personalized" emails about something for work!

[@VishalKumar-ll9wi]

Thanks man really helpful when needed! Keep up the good work 🤟🏻😃

[@arrowinquire]

Thank you - quickly executed the MMerge with an impending deadline!

[@mohamadalkaiyat4493]

thank you. I truly liked the video as it's concise and direct to the point ...

[@ahjin05]

Super easy to understand. I wished I had found this video and not spending 20 minutes trying to figure out on my own.

[@Danabreion]

You saved me hours of sending manual emails!! Thank you!

[@qimengzhao2431]

Thank you Kevin for such great help, much appreciated !

[@shelbyarnold]

Thank you Kevin. This was a great vid. I have been struggling figuring this out.

[@lucahelenflaherty7295]

This was so helpful. Thank you for the tutorial!

[@quackstk6418]

Brilliant Video, simple, Crisp and Precise. I have to do the merge next week at my Work. Thanks again...!

[@Soumya009]

Brilliant.... Thanks a lot for making me understand it so easily. I have been looking for it for quite some time now. Finally I got it.

[@patrickanderson9089]

Thanks Kevin, appreciate this and all your tutorials. They are my go to for learning and refreshing my how to's.

[@irenenibo8627]

Very educative and easy to follow with.

[@quantumv8738]

Awesome vid, Kevin! :) Thanks for sharing!

[@utsosie4483]

Super helpful! Thank you for making these videos

[@manaetches3986]

Thanks Kevin. Great tutorial. Can you please show us how to set the default email account for mail merge. I'd like to send bulk emails from a different email address. Cheers

[@MrSaichandp]

You have explained it very clearly about the mail merge in this video. Thank you for sharing this video.