How to Mail Merge in Word, Excel & Outlook

Рет қаралды 1,858,426

Күн бұрын

Learn how to Mail Merge with Microsoft 365, Office 2021, Office 2019, Office 2016, Office 2013, or Office 2010. Mail Merge allows you to send customized envelopes, letters, and emails. Mail Merge leverages Microsoft Word, Excel, and Outlook.
📚 RESOURCES
- Mail Merge with Attachments, Custom Subjects, CC / BCC others, or set the default email address: • How to Mail Merge with...
- Mail Merge for free using WPS Office: • How to Mail Merge in W...
- Get Microsoft 365: bit.ly/3CUmtZw
📺 RELATED VIDEOS
- Videos on Microsoft Outlook: • 📨 How to use Outlook
📩 NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: kevinstratvert.com/newsletter/
🔽 CONNECT WITH ME
- Official web site: www.kevinstratvert.com
- LinkedIn: / kevinstratvert
- Discord: / discord
- Twitter: / kevstrat
- Facebook: / kevin-stratvert-101912...
- TikTok: / kevinstratvert
- Instagram: / kevinstratvert
🎒 MY COURSES
- Excel for Beginners in under 2 hours: kevinstratvert.thinkific.com/
🙏 REQUEST VIDEOS
forms.gle/BDrTNUoxheEoMLGt5
🔔 SUBSCRIBE ON KZfaq
kzfaq.info?...
🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: amzn.to/3kCP2yz
⚖ DISCLOSURE
Some links are affiliate links. Purchasing through these links gives me a small commission to support videos on this channel. The price to you is the same.
#stratvert

Пікірлер: 1 400

@KevinStratvert 5 жыл бұрын

🏫 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

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

@beamurray6044 4 жыл бұрын

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!

@TengBermudez 11 ай бұрын

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

@SadEmoji1298 Ай бұрын

are you still doing good at work?

@andrichvitug9462 3 жыл бұрын

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

@theresevanwyk9211 5 жыл бұрын

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

@jorgeoteo 3 жыл бұрын

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!

@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 6 ай бұрын

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

@glendadalton7525 4 ай бұрын

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

@Thecuriousincident1 2 ай бұрын

Thank you! this is the exact question I had.

@rachaelmay0 2 ай бұрын

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 15 күн бұрын

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

@pmamsc 4 жыл бұрын

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.

@susanbenzel3976 4 жыл бұрын

Perfect - exactly what I needed!

@EuropeanWorldTraveler 3 жыл бұрын

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.

@macky2green 3 жыл бұрын

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

@maryvescio787 6 ай бұрын

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.

@variesxify 4 жыл бұрын

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.

@leemarattan9700 4 жыл бұрын

This demonstration was awesome! Thank you so much Kevin.

@sarahfraser8965 3 жыл бұрын

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.

@suefranklin968 4 жыл бұрын

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.

@GlorifiedTruth 2 жыл бұрын

Exactly what I was going to say. Very good video.

@donincognito9006 4 жыл бұрын

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!

@itguy5192 4 жыл бұрын

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?

@josephwilk2159 4 жыл бұрын

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!

@angelbuffer6115 2 жыл бұрын

I need it can't you inbox me?

@channahbridgemantorres5698 3 жыл бұрын

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

@tashapalmer4519 3 жыл бұрын

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

@wongelinor4717 Жыл бұрын

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.

@leadscapeadvisors7705 4 жыл бұрын

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

@suzycanton9730 3 жыл бұрын

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!

@user-jo3fw1gi8c 7 ай бұрын

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.

@Schillerm82 3 жыл бұрын

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

@Lights_Darks 4 жыл бұрын

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

@sarvank669 2 жыл бұрын

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.

@walomac 4 ай бұрын

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

@admiralkidd 4 жыл бұрын

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

@annaprzychodzen5780 3 жыл бұрын

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

@jm4174 4 жыл бұрын

Thanks Kevin. It's nice to watching you do it vs reading difficult instructions; i think this is the 5th time you've saved me in last 12 months

@anram 3 жыл бұрын

Kevin, you are awesome, thank you so much for making mail merge so easy for me. I have read all the different instructions from all the geniuses and from Microsoft and I gave up 1/4 way through until I came across your step by step guidance for dummies. Thanks again

@jessicamayo8157 4 жыл бұрын

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

@tenc6491 5 жыл бұрын

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

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

@marlondaniels7023 3 жыл бұрын

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.

@estelabalderas4892 3 жыл бұрын

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.

@comehenry8075 4 жыл бұрын

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

@youngkim6720 2 жыл бұрын

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!

@arrowinquire 3 жыл бұрын

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

@alysha6770 4 жыл бұрын

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

@SaanjD 4 жыл бұрын

This was so helpful and explained perfectly, thank you Kevin

@daviethetaxlady 10 ай бұрын

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

@katyallen8680 5 ай бұрын

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!

@TheRealPuruka 2 жыл бұрын

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.

@user-zz6ge6tn3k 4 жыл бұрын

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

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

@sureyavassallo805 4 жыл бұрын

This was so useful, thank you! I've set everything up to send, but it was so much easier to do than I thought :)

@tonybrylski7909 4 жыл бұрын

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

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

@Raphael-zl5jb 3 жыл бұрын

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

@onelifeonetransformation 3 жыл бұрын

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

@alpinehippie 2 жыл бұрын

This was great! Super well done and easy to follow. Helped me with a very important work project. This service is greatly appreciated. Keep up the good work!

@TheStoudtLife 3 жыл бұрын

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

@lorettaguerra1542 3 жыл бұрын

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

I have the same question.

@samanwahedazez1204 2 жыл бұрын

ةة

@feliciameredith8254 4 жыл бұрын

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

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

@LauraaMichellle 4 жыл бұрын

@@chrismorley2560 What setting is this?

@anesethemi5054 4 жыл бұрын

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.

@teabaggins3517 3 жыл бұрын

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

@sharonkrone9021 3 жыл бұрын

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

@ehabal-ani9102 3 жыл бұрын

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

Did you ever get an answer?

@ehabal-ani9102 2 жыл бұрын

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

@daniel20022 4 жыл бұрын

bruhhh you explained much clearer than my lecturer lol😂

@kavyanageshkandala5983 Жыл бұрын

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

@stephaniedouglas8845 3 жыл бұрын

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

@cybercruiser69 4 жыл бұрын

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

@itguy5192 4 жыл бұрын

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

@swee8181 3 жыл бұрын

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

@wastedtime101 2 жыл бұрын

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

@joasante1672 3 жыл бұрын

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

@stefav100 4 жыл бұрын

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!

@irissears981 3 жыл бұрын

Did you ever find out how?????

@VictorAntunes72 Жыл бұрын

Same problem to me!

@cflmkingdomkids3417 10 ай бұрын

I had the same issue. It sent from the wrong email. Have spent an hour trying to figure out how to not do that again. Still can't figure it out.

@brucemartin4972 3 жыл бұрын

Thanks! This is one of the most helpful and concise Office 365 how-to videos I've come across. I really appreciate the clarity of instruction.

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

@ferencdaroczi Жыл бұрын

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

@DaphodillyDo 3 жыл бұрын

Precise, easy to follow tutorial. Thank you, Kevin!

@MrRakeshkiran 2 жыл бұрын

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.

@iigrevanii 4 жыл бұрын

This was exactly what I needed and you were so clear and succinct. I logged in my KZfaq just to thank you! Thanks!

@belaazores 3 жыл бұрын

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

@veronicagdowning 6 ай бұрын

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.

@ashrei26 2 жыл бұрын

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

@alexglasson4537 3 жыл бұрын

Super duper helpful! Thank you Kevin! And very straightforward--thanks for going through the content efficiently (some videos similar to these can be extremely long and I feel like I'm watching a turtle teach me how to use a computer)

@wenqinhuang2396 3 жыл бұрын

Thank you, Kevin, for sharing your knowledge and putting your time into this video to help others! :) I find it informative and am happy about it!

@vinny1995 3 жыл бұрын

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

@nnedland 2 жыл бұрын

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

@peacetreefilms Жыл бұрын

Brilliant! This was super easy to follow along. I needed to send out about 35 custom emails, and this made easy work of it. Thank you!

@stevenfairlie3407 Жыл бұрын

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

@arnauita1 2 жыл бұрын

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

@tobydunnagan 2 жыл бұрын

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

@713theresa 10 ай бұрын

Such a great video. I return to it time and time again because it's concise and short!

@lucyfernandez1559 3 жыл бұрын

Thank you so much for making this video. Just exactly what I needed.

@MommysNestRobbinsdale 3 жыл бұрын

Thank you - we have updated to Office 365 since the last time I had to do a mail merge, this was helpful.

@karimhajiani8828 4 жыл бұрын

Perfect Kevin. This is exactly what I needed.

@MsMcGillivray 2 жыл бұрын

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!

@cristianecampese8948 5 ай бұрын

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

@sincericaruso5644 4 жыл бұрын

Thank you! Simple and clear. I totally will be watching your other videos.

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

@Soumya009 3 жыл бұрын

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.

@karenobrien9526 5 ай бұрын

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

@katpuppy-love1923 3 жыл бұрын

Thanks for making it EASY! Thanks for just getting straight to the point too!

@bethanym8318 2 жыл бұрын

This was simple, easy, and to the point! Thank you

@TRTPRODS 2 жыл бұрын

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.