🏫 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: kzfaq.info/sun/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY ✉ Mail Merge with Attachments, Custom Subjects, CC / BCC others, or set the default email address: kzfaq.info/get/bejne/r9CPppaUycy6dI0.html 🆓 Don't have Microsoft Office? Mail Merge for free using WPS Office: kzfaq.info/get/bejne/Y9GIosmTma-3ias.html

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

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

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!

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.

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!

I am a public school teacher who is attempting to send critical information so that my families can have access to personalized materials during the COVID-19 shutdown. This tutorial was so helpful in allowing me to automate this process so that I can efficiently serve my families. Thank you so much for such a clear and direct tutorial!

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

Like most, I have watched hundreds of these type vids and without a doubt, this was the best! Step by step without skipping any steps and without adding unnecessary comments.

Dude you are my hero! A Google search was useless, your guide actually worked. I had to email 119 people without anyone else email showing up on the receiving end. This saved so much time!

Thanks a million Kevin! I was DREADING having to figure this out, and you made this so easy and OK! Goodness, I'm so grateful I didn't have to sit here for two days faffing around to make it work without a video tutorial! It means spending more effort on reaching my targets at work and less on figuring out my toolbox...

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!

Thanks! Saved me about 10 hours of work by watching a to the point 7 minute video!

This was a really helpful tutorial, very clear and easy to follow. Going to attempt my first ever mail merge today and i think you have saved me hours of work. Thanks Kevin.

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.

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

*_OMG, Kevin! You're a lifesaver. I felt like a god when I was able to execute this successfully. As a Clerk (in a hospital laboratory) having many staff/colleagues to keep track of, this is the perfect way to get things done. Thank you so much._*

Great thanks Kevin! I need this for an office task and your explanation is clean and clear. If larger fonts have been used on the WORD and EXCEL documents, that would even be better. But it's already gorgeous now. Thanks again.

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

I never leave comments on videos, but your tutorial was so easy and without all the unnecessary bs that most tutorials do with the subsribe sell etc. I felt like such an expert after watching it. Thanks so much.

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.

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

Perfect - exactly what I needed!

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

This is one of the easiest and cheapest ways for me to have learned how to send an email merge, instead of buying into something that costs and is still complicated. Thank you

Thanks, Kevin! You just made it so easy to know, understand and do. I watched the video at 1.5x for want of time thinking that I might have to watch more than one of them and it still made such perfect sense that I had to look no further. I could use the spare time to leave this note instead.

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

I just got an email campaign assignment from my employer and wasn’t sure how to go about it. I probably would’ve chosen the long way to do this. But your video just saved my life. Thank you so much for creating content like this. I hope to continue learning more helpful tips from you and become marketable as an employee.

This was so helpful! I've done plenty of word merges, but never an email merge. I knew it could be done but just didn't know all the steps in their correct order. Thanks for breaking it down and making it simple!

This demonstration was awesome! Thank you so much Kevin.

Straight to the point and easy to understand. Thanks very much!

Thank you very much, Kevin! I dreaded doing an email mail merge, and your careful instructions meant a successful outcome for me!

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.

Your explanation was way better to follow and better comprehended than the one given for my online college course. Thank you for the great content! So many awesome features that Microsoft has that I have no idea about.

We just started using MS 365 this week and your video has been a lifesaver for this ancient worker. Thank you for creating these helpful content Kevin!

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

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

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?

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.

Wow! This is fantastic, I was able to follow your all instructions and it worked for me. The only this is that, at final step, it sent all emails instead of saving in outbox.

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

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?

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

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

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

Thank you for this video! This is gonna make my life so much easier! I like the way you explain things.

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

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

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

This was so helpful and explained perfectly, thank you Kevin

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

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.

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?

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

Your video alerted me to the minor problem I was having with my mail merge, clear concise, easy to follow - absolute life saver thank you so much

Very helpful and nice and short - so much better than the others I watched. Thank you!

Amazing! Quick, clear and spot on. Keep it going, Kevin.

Great Tut Kevin I wished you zoomed in so we can actually see what you're doing

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 KZfaq. You've saved me so much time :)

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.

bruhhh you explained much clearer than my lecturer lol😂

Great tutorial! Thanks a lot! May I ask for extra help? How can I change the default email in the "from" section of the message? I am also managing the info/inquiry email of our company and I'd like to use that for bulk messages instead of my personal work email. Thank you very much and looking forward to your reply!

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

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

Wow! That was a lot easier than I thought it would be. Thank you so much for sharing.

Thank you so much. I love how you present these tutorials. So clear and helpful.

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

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!

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!

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

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 😊

Straight to the point, thank you for your guidance Kevin!

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.

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

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!

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

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

This is a great tool. I have been feeling powerless against scammers and it is very satisfying to send them a few hundreds of E-mails! Thank you!!!

To the point and easy to follow. Took care of business and had extra time for coffee. Big like from me.

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.

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

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

Thank you so much we have 120 guests makes my life easier

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.

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

You just made my life so much easier. THANK YOU.

Very helpful, concise and accurate. Thanks for doing this!

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

Finally, I now understand how to do mail merge! Thank you so much!

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

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

I've watched this Vid a number of different times. Thank you for making it so easy. I think its because you can really feel the how much you enjoy what you do.

Thank you for the tutorial Kevin! Nice haircut, it looks good on you!!

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

I used this video for work purposes, honestly I am so grateful for the short and direct instruction. Thanks sooo much

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

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

Thank youuu!! I was stuck until I found your video!!

Thank you so much for your tutorials. They have helped me get through all of my Microsoft classes, especially my integrated Microsoft applications class with A's.

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