How to Mail Merge in Word, Excel & Outlook

Поділитися
Вставка
  • Опубліковано 3 гру 2024

КОМЕНТАРІ • 1,4 тис.

  • @KevinStratvert
    @KevinStratvert  5 років тому +24

    🏫 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: ua-cam.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html
    ✉ Mail Merge with Attachments, Custom Subjects, CC / BCC others, or set the default email address: ua-cam.com/video/yj_s3cdfVDY/v-deo.html
    🆓 Don't have Microsoft Office? Mail Merge for free using WPS Office: ua-cam.com/video/-kXofb4ISYw/v-deo.html

    • @ra8784
      @ra8784 2 роки тому

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

    • @KRSportsVideo
      @KRSportsVideo Рік тому

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

    • @stormsentertainment5270
      @stormsentertainment5270 Рік тому

      Apple recipe reference. 🎉

    • @marisolkiffen8634
      @marisolkiffen8634 6 місяців тому

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

  • @TengBermudez
    @TengBermudez Рік тому +30

    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
      @HolyMoly919 6 місяців тому

      are you still doing good at work?

    • @gavomoore
      @gavomoore 12 днів тому

      how's work going

  • @peggymunoz
    @peggymunoz Рік тому +78

    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
      @Trending_songo9838 11 місяців тому

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

    • @glendadalton7525
      @glendadalton7525 9 місяців тому +2

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

    • @ActuallyDoubleGuitars
      @ActuallyDoubleGuitars 7 місяців тому +2

      Thank you! this is the exact question I had.

    • @rachaelmay0
      @rachaelmay0 7 місяців тому +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
      @nicholasdoliszny7231 5 місяців тому

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

  • @jorgeoteo
    @jorgeoteo 4 роки тому +5

    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!

  • @estelabalderas4892
    @estelabalderas4892 4 роки тому +7

    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.

  • @beamurray6044
    @beamurray6044 5 років тому +76

    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!

  • @andrichvitug9462
    @andrichvitug9462 4 роки тому +51

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

  • @josephwilk2159
    @josephwilk2159 4 роки тому +31

    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!

  • @Schillerm82
    @Schillerm82 3 роки тому +3

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

  • @daviethetaxlady
    @daviethetaxlady Рік тому +1

    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

  • @donincognito9006
    @donincognito9006 4 роки тому +12

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

  • @andrewmcallister-f6v
    @andrewmcallister-f6v Рік тому +1

    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.

  • @theresevanwyk9211
    @theresevanwyk9211 5 років тому +22

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

  • @youngkim6720
    @youngkim6720 2 роки тому +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!

  • @macky2green
    @macky2green 4 роки тому +4

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

  • @elsa6724
    @elsa6724 2 роки тому

    Thanks! A lot! Very helpful! Question, is there a way to add an additional email in cc?

  • @EuropeanWorldTraveler
    @EuropeanWorldTraveler 4 роки тому +11

    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.

  • @walomac
    @walomac 9 місяців тому +1

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

  • @suefranklin968
    @suefranklin968 4 роки тому +16

    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
      @GlorifiedTruth 2 роки тому

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

  • @maryvescio787
    @maryvescio787 11 місяців тому

    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.

  • @annaprzychodzen5780
    @annaprzychodzen5780 3 роки тому +5

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

  • @suzycanton9730
    @suzycanton9730 4 роки тому

    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!

  • @wongelinor4717
    @wongelinor4717 Рік тому +5

    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.

  • @katyallen8680
    @katyallen8680 10 місяців тому

    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!

  • @leadscapeadvisors7705
    @leadscapeadvisors7705 4 роки тому +3

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

  • @kavyanageshkandala5983
    @kavyanageshkandala5983 Рік тому

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

  • @alysha6770
    @alysha6770 4 роки тому +12

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

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

  • @leemarattan9700
    @leemarattan9700 5 років тому +7

    This demonstration was awesome! Thank you so much Kevin.

  • @Faithspective
    @Faithspective 11 місяців тому

    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.

  • @TheRealPuruka
    @TheRealPuruka 2 роки тому +5

    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.

  • @PMA-so4wt
    @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

  • @susanbenzel3976
    @susanbenzel3976 5 років тому +46

    Perfect - exactly what I needed!

  • @tashapalmer4519
    @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 UA-cam. You've saved me so much time :)

  • @ehabal-ani9102
    @ehabal-ani9102 3 роки тому +6

    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
      @RussellWalshAIMDirect 3 роки тому

      Did you ever get an answer?

    • @ehabal-ani9102
      @ehabal-ani9102 3 роки тому +1

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

  • @teabaggins3517
    @teabaggins3517 3 роки тому

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

  • @tonybrylski7909
    @tonybrylski7909 4 роки тому +11

    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
      @dfents 4 роки тому

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

  • @chrisholben6180
    @chrisholben6180 2 роки тому

    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

  • @admiralkidd
    @admiralkidd 4 роки тому +4

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

  • @neginkord5057
    @neginkord5057 2 роки тому

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

  • @lorettaguerra1542
    @lorettaguerra1542 4 роки тому +6

    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?

  • @ashrei26
    @ashrei26 2 роки тому

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

  • @comehenry8075
    @comehenry8075 4 роки тому +4

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

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

  • @Raphael-zl5jb
    @Raphael-zl5jb 3 роки тому +4

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

  • @sarena_ela6255
    @sarena_ela6255 День тому

    Always appreciate your videos when I need to learn a MS schkills in a pinch. Thank you!

  • @tenc6491
    @tenc6491 5 років тому +4

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

  • @royyanapreston2377
    @royyanapreston2377 2 роки тому

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

  • @feliciameredith8254
    @feliciameredith8254 4 роки тому +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
      @chrismorley2560 4 роки тому

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

    • @LauraaMichellle
      @LauraaMichellle 4 роки тому

      @@chrismorley2560 What setting is this?

    • @anesethemi5054
      @anesethemi5054 4 роки тому +1

      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.

  • @sarahfraser8965
    @sarahfraser8965 4 роки тому

    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.

  • @SaanjD
    @SaanjD 4 роки тому +6

    This was so helpful and explained perfectly, thank you Kevin

  • @channahbridgemantorres5698
    @channahbridgemantorres5698 4 роки тому +2

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

  • @cybercruiser69
    @cybercruiser69 4 роки тому +4

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

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

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

  • @swee8181
    @swee8181 3 роки тому +3

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

  • @Captain_Mckeggor
    @Captain_Mckeggor 3 роки тому

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

  • @aliyaha.3222
    @aliyaha.3222 3 місяці тому

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

  • @karenobrien9526
    @karenobrien9526 10 місяців тому

    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

  • @carolynhill6306
    @carolynhill6306 3 місяці тому

    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 UA-cam folder for all the handy videos you create. Thanks a bunch. You're a life saver.

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

  • @mikeaiken7424
    @mikeaiken7424 3 дні тому

    Awesome video Kevin i learned a lot for my first email merge! thanks for posting! i am a small business and trying to improve my marketing skills this really helped a lot. I was able to send out 174 emails to all of my prospects. I'll keep you informed about the results, thanks again.

  • @nnedland
    @nnedland 3 роки тому

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

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

  • @VivekSingh06
    @VivekSingh06 4 місяці тому

    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.

  • @arnauita1
    @arnauita1 3 роки тому

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

  • @jamesgraber3727
    @jamesgraber3727 3 роки тому

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

  • @TheStoudtLife
    @TheStoudtLife 4 роки тому +2

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

  • @scohan44
    @scohan44 3 місяці тому

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

  • @justakiss15
    @justakiss15 3 роки тому

    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!

  • @vailaward7004
    @vailaward7004 2 роки тому

    THANK YOU FOR THIS!!! I'm doing a program by Pearson offered through school, and it's the worst!! Your video is so helpful! You made it all come together :) (I shared the link with my classmates)

  • @anram
    @anram 3 роки тому +1

    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

  • @charleshepburn794
    @charleshepburn794 3 роки тому

    Finally a decent explanation on how to use this function. Thanks Kevin.

  • @nature_photography_yukon
    @nature_photography_yukon 3 роки тому

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

  • @kewartoscar8913
    @kewartoscar8913 3 роки тому +2

    Thanks a million, Kelvin. You're an Angel living among humans.

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

  • @joasante1672
    @joasante1672 3 роки тому

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

  • @MrRakeshkiran
    @MrRakeshkiran 3 роки тому

    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.

  • @nedaari1
    @nedaari1 3 роки тому

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

  • @stephaniedouglas8845
    @stephaniedouglas8845 4 роки тому +1

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

  • @nrmilford9316
    @nrmilford9316 2 роки тому

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

  • @marlondaniels7023
    @marlondaniels7023 4 роки тому

    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.

  • @munibahmadxx
    @munibahmadxx 2 роки тому

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

  • @TRTPRODS
    @TRTPRODS 2 роки тому

    Thanks!

    • @KevinStratvert
      @KevinStratvert  2 роки тому

      Wow, thanks so much, TRTPRODS NYC! Much appreciated 🙌

  • @Danabreion
    @Danabreion 3 роки тому

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

  • @AdrienneLaVonn-Miller
    @AdrienneLaVonn-Miller Рік тому

    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.

  • @arrowinquire
    @arrowinquire 4 роки тому +1

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

  • @procurementhmpl438
    @procurementhmpl438 2 роки тому

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

  • @gideoknight
    @gideoknight Рік тому +1

    Thank you Sir, this is very helpful ❤❤❤❤

  • @ryanwheeler8188
    @ryanwheeler8188 2 роки тому

    this is so helpful, thank you! (also, over a million views on mail merge blows my mind, clearly this is content people want!) Great work Kevin!

  • @amanjitgill3396
    @amanjitgill3396 3 роки тому

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

  • @HD-ol1mc
    @HD-ol1mc 3 роки тому

    Great video, I just emailed 320 people all at once with no problems (giving them good news of an academic achievement). So easy to follow 😊.

  • @713theresa
    @713theresa Рік тому

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

  • @SharonJackson-d7z
    @SharonJackson-d7z 2 місяці тому

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

  • @wastedtime101
    @wastedtime101 3 роки тому +1

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

  • @tobydunnagan
    @tobydunnagan 2 роки тому

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

  • @caitlinmorehouse3576
    @caitlinmorehouse3576 2 роки тому

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

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

  • @vermabalraj
    @vermabalraj 3 роки тому +2

    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.

  • @shacareedixon7195
    @shacareedixon7195 3 роки тому

    Thank You so much. When it comes to Microsoft any applications Im using you are my go to guy! Thank You I just massed emailed over 50,000 customer leads. Just started my business and it was getting stressful sending out email one by one. Hopefully I get some business after this.