🏫 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
@ra87842 жыл бұрын
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. 🎉
@marisolkiffen86342 ай бұрын
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
@HolyMoly9192 ай бұрын
are you still doing good at work?
@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_songo98388 ай бұрын
Full video on my channel how to setup outlook and how to add email and send bulk emails .
@glendadalton75256 ай бұрын
This just happened to me. I had to recall about 30 emails without attachments.
@ActuallyDoubleGuitars4 ай бұрын
Thank you! this is the exact question I had.
@rachaelmay04 ай бұрын
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.
@nicholasdoliszny72312 ай бұрын
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 🤔🤔
@jorgeoteo3 жыл бұрын
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!
@estelabalderas48924 жыл бұрын
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.
@beamurray60444 жыл бұрын
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!
@josephwilk21594 жыл бұрын
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!
@angelbuffer61152 жыл бұрын
I need it can't you inbox me?
@andrichvitug94623 жыл бұрын
This is great! Just the type of tutorial I need. Straight forward and easy to follow. Keep it up, Kevin!
@pmamsc4 жыл бұрын
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.
@donincognito90064 жыл бұрын
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!
@itguy51924 жыл бұрын
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?
@theresevanwyk92115 жыл бұрын
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...
@youngkim67202 жыл бұрын
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!
@Schillerm823 жыл бұрын
Thanks! Saved me about 10 hours of work by watching a to the point 7 minute video!
@suefranklin9684 жыл бұрын
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.
@GlorifiedTruth2 жыл бұрын
Exactly what I was going to say. Very good video.
@EuropeanWorldTraveler3 жыл бұрын
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.
@aliyaha.322215 күн бұрын
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.😊
@macky2green3 жыл бұрын
*_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._*
@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.
@annaprzychodzen57803 жыл бұрын
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 :)
@maryvescio7878 ай бұрын
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.
@user-jo3fw1gi8c8 ай бұрын
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.
@leadscapeadvisors77054 жыл бұрын
Excellent. So clearly explained. After grappling with this problem for so many days, I could do this in minutes. Thank you!
@susanbenzel39765 жыл бұрын
Perfect - exactly what I needed!
@walomac6 ай бұрын
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 :)
@daviethetaxlady11 ай бұрын
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
@variesxify4 жыл бұрын
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.
@alysha67704 жыл бұрын
THANK YOU! I had to do this for an assignment and was clueless before seeing your video.
@veronicagdowning8 ай бұрын
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.
@katyallen86807 ай бұрын
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!
@leemarattan97004 жыл бұрын
This demonstration was awesome! Thank you so much Kevin.
@Lights_Darks5 жыл бұрын
Straight to the point and easy to understand. Thanks very much!
@scohan4416 күн бұрын
Thank you very much, Kevin! I dreaded doing an email mail merge, and your careful instructions meant a successful outcome for me!
@ehabal-ani91023 жыл бұрын
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.
@RussellWalshAIMDirect3 жыл бұрын
Did you ever get an answer?
@ehabal-ani91023 жыл бұрын
@@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.
@TheRealPuruka2 жыл бұрын
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.
@suzycanton97303 жыл бұрын
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!
@chrisholben61802 жыл бұрын
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
@admiralkidd4 жыл бұрын
Kevin, Thanks so much! You answered all of my questios with ease.
@tonybrylski79094 жыл бұрын
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?
@dfents3 жыл бұрын
In Outlook go to File > Account Settings and then set as default the email account from which you want to send.
@sarvank6692 жыл бұрын
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.
@VivekSingh0629 күн бұрын
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.
@Raphael-zl5jb3 жыл бұрын
Great overview but is there any way of changing the 'from' email when you have access to multiple inboxes?
@onelifeonetransformation3 жыл бұрын
I have the same question. Also could we CC anyone in these mails?
@lorettaguerra15424 жыл бұрын
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?
@estelabalderas48924 жыл бұрын
I have the same question.
@samanwahedazez12042 жыл бұрын
ةة
@kavyanageshkandala5983 Жыл бұрын
I can’t thank you enough for uploading such simplified tutorials for non techie person like me ! Thank you soo much !!
@sharonkrone90213 жыл бұрын
super helpful and succinct. thanks. nice dual camera detail!
@comehenry80754 жыл бұрын
BRO YOU ARE THE BEST YOU EXPLAINED EVERYTHING I NEEDED TO KNOW THX
@jessicamayo81574 жыл бұрын
Thank you for this video! This is gonna make my life so much easier! I like the way you explain things.
@poerc9 ай бұрын
Thanks so much for making this! I used to do mail merges and it's been so long I've forgotten all of it.
@munibahmadxx2 жыл бұрын
Very helpful. I've watch few videos regarding this topic, but your explanation is comprehensive.
@tenc64915 жыл бұрын
Thank you. Explained beautifully! You've earned a subscriber!
@SaanjD4 жыл бұрын
This was so helpful and explained perfectly, thank you Kevin
@ashrei262 жыл бұрын
I think you just changed my life! I'm thinking of all the ways this is going to simplify our bulk mailings!
@margaretseibert560410 ай бұрын
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.
@feliciameredith82544 жыл бұрын
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?
@chrismorley25604 жыл бұрын
I think this is a setting on outlook you need to change.
@LauraaMichellle4 жыл бұрын
@@chrismorley2560 What setting is this?
@anesethemi50544 жыл бұрын
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.
@cybercruiser694 жыл бұрын
Is there a way to change the FROM: email different from the person that is sending the eMail merge??
@itguy51924 жыл бұрын
@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?
@karenobrien95266 ай бұрын
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
@user-pp1us4ld6t6 ай бұрын
Very helpful and nice and short - so much better than the others I watched. Thank you!
@user-zz6ge6tn3k4 жыл бұрын
Amazing! Quick, clear and spot on. Keep it going, Kevin.
@swee81813 жыл бұрын
Great Tut Kevin I wished you zoomed in so we can actually see what you're doing
@tashapalmer45193 жыл бұрын
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 :)
@sarahfraser89654 жыл бұрын
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.
@daniel200224 жыл бұрын
bruhhh you explained much clearer than my lecturer lol😂
@stefav1004 жыл бұрын
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!
@irissears9813 жыл бұрын
Did you ever find out how?????
@VictorAntunes72 Жыл бұрын
Same problem to me!
@cflmkingdomkids3417 Жыл бұрын
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.
@channahbridgemantorres56984 жыл бұрын
Thank you Kevin. You are an excellent trainer! Very professional, engaging tone, concise, clear instructions and examples.
@teabaggins35173 жыл бұрын
Best tutorial I could find. No bullshit and unnecessary explanations. Thank you!
@stephaniedouglas88453 жыл бұрын
Wow! That was a lot easier than I thought it would be. Thank you so much for sharing.
@wastedtime1012 жыл бұрын
Thank you so much. I love how you present these tutorials. So clear and helpful.
@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. :)
@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!
@justakiss153 жыл бұрын
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!
@niranjanself74533 жыл бұрын
NICE EXPLANATION WITH SIMPLE EXAMPLE WHICH IS VERY EFFECTIVE, THANKS KEVIN
@carmenjohnson97333 жыл бұрын
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 😊
@buzwefani69842 жыл бұрын
Was there a response @carmen?
@cristianecampese89487 ай бұрын
Straight to the point, thank you for your guidance Kevin!
@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.
@procurementhmpl4382 жыл бұрын
Hi Kevin, I am from India, I do watch your videos to learn. Keep Posting.. Your way is simple and good.
@MsMcGillivray2 жыл бұрын
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!
@stevenfairlie3407 Жыл бұрын
Brilliant, thanks Kevin. Easy to understand and you have a very amiable nature.
@caitlinmorehouse3576 Жыл бұрын
This helped me prepare for my job interview today! Thank you Kevin!!
@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!!!
@Captain_Mckeggor3 жыл бұрын
To the point and easy to follow. Took care of business and had extra time for coffee. Big like from me.
@MrRakeshkiran2 жыл бұрын
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.
@royyanapreston23772 жыл бұрын
Just totally used this to send out 116 emails that I was instructed to send manually! Saved me soo much time!
@qone23634 ай бұрын
Fantastic tutorial. I needed something quick and easy to learn and this fit the task very well!
@user-wy2kj5vb3j4 ай бұрын
Thank you so much we have 120 guests makes my life easier
@TRTPRODS2 жыл бұрын
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.
@tobydunnagan2 жыл бұрын
I have used this video multiple times. Thank you sir!
@magpie2232 жыл бұрын
You just made my life so much easier. THANK YOU.
@bobluikens31635 ай бұрын
Very helpful, concise and accurate. Thanks for doing this!
@ahjin054 ай бұрын
Super easy to understand. I wished I had found this video and not spending 20 minutes trying to figure out on my own.
@nature_photography_yukon2 жыл бұрын
Finally, I now understand how to do mail merge! Thank you so much!
@t.g20892 жыл бұрын
Thank you, Kevin. This is just what I need for my new job.
@iamajblove Жыл бұрын
Before this video, it was kinda difficult for me to do, and now i am master in it. Thank you so much ❤
@marlondaniels70233 жыл бұрын
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.
@ILoveBananaSmoothie Жыл бұрын
Thank you for the tutorial Kevin! Nice haircut, it looks good on you!!
@llawliet4889 Жыл бұрын
Thanks Kevin! You're videos have helped me so much! I really appreciate you!
@joasante16723 жыл бұрын
I used this video for work purposes, honestly I am so grateful for the short and direct instruction. Thanks sooo much
@nedaari13 жыл бұрын
This video is still helpful. Feel like I watch it once each year.
@nrmilford93162 жыл бұрын
Thanks Kevin, very helpful. Saved me from bothering a co-worker who always does this for me.
@michelleg96372 жыл бұрын
Thank youuu!! I was stuck until I found your video!!
@user-fu5hg8vs9o Жыл бұрын
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.
@jamesgraber37273 жыл бұрын
Brilliant! A colleague shared this video and what a great help. Thank you Kevin!