How to Mail Merge using Word, Excel, & Outlook – Office 365



Learn how to Mail Merge with Office 365, 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.

Looking to Mail Merge with Attachments, Custom Subjects, CC / BCC others, or set the default email address? Check out this more advanced Mail Merge tutorial:

Don’t have Microsoft Office? Mail Merge for free using WPS Office:

Thinking about subscribing to Office 365? You get the Word, Excel, and PowerPoint desktop apps and up to 6 TB cloud storage. Check the latest pricing on Amazon: (as a disclaimer, purchasing through this link gives me a small commission to support videos on this channel — the price to you is the same).

As full disclosure, I work at Microsoft.

Nguồn: https://akihito-shigeno.com

Xem thêm bài viết khác: https://akihito-shigeno.com/cong-nghe/

  • Thanks a million for this mail merge function, thanks to Doug Robbins for merge tool, will thank him personally

    Vinay Nagaonkar May 21, 2020 2:54 pm Reply
  • I use the exact steps, but every time I send emails some emails are not sent. If I send 30 emails, 2 of the emails are not sent. Does anybody have any idea what's wrong?

    Safar rahimi May 21, 2020 2:54 pm Reply
  • Can't find where they are in Outlook. See no outbox or send/receive. Our Email is godaddy, but use Outlook and can't find "where they went"..

    Lynn Roberts May 21, 2020 2:54 pm Reply
  • This worked but my emails did not go into the outbox but were sent automatically. I would like to check them in my outbox first before sending them all. Anyone know if this can be rectified?

    Douglas May 21, 2020 2:54 pm Reply
  • This was exactly what I needed and you were so clear and succinct. I logged in my YouTube just to thank you! Thanks!

    iigrevanii May 21, 2020 2:54 pm Reply
  • its great but it send out without going to outlook and with the wrong email 🙁 !! If it has happened to you tlel me what you did so you change the ''from'' email account.

    ANAIVI TV May 21, 2020 2:54 pm Reply
  • Fantastic! Thanks so much!

    Robert Miller May 21, 2020 2:54 pm Reply
  • How do I get a custom picture into the merge? Excel has data including the file name of the jpeg I want to merge.

    Jay Wenstrup May 21, 2020 2:54 pm Reply
  • Thank you! You just saved me hours of work.

    Cheryl Batch May 21, 2020 2:54 pm Reply
  • Thanks a lot, I could create 4840 personalised emails within 25 minutes of applying the technique learnt in this video

    Vinay Nagaonkar May 21, 2020 2:54 pm Reply
  • Exactly what I am looking for, thanks.

    Joseph Kukula May 21, 2020 2:54 pm Reply
  • This video is really great, thank you. I have a question, when I hit send the emails list, it gets sent directly, without having to go to outlook and click send. Why does it do that?

    Anes Ethemi May 21, 2020 2:54 pm Reply
  • Thank you Kevin, this was a very informative video that helped me a lot!

    Ive Boogaerts May 21, 2020 2:54 pm Reply
  • This is good, however, I would like to know how we can do the same using Outlook directly. Reason being that I use a mailing DB for official use and the data file is on the server. So invariably when I do mail merge, word selects my personal 'sender's' address to send out an email. appreciate if you can help here …

    mscoolswati May 21, 2020 2:54 pm Reply
  • 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

    J M May 21, 2020 2:54 pm Reply
  • I get to the last step and the "merge to email" dropdown is shaded and I cannot click it. What am I doing wrong?

    Steven T May 21, 2020 2:54 pm Reply
  • mail merge option not showing our word file

    jijau lohar May 21, 2020 2:54 pm Reply
  • Hi, Kelvin
    Thank you so much for this video sharing, it was really helpful.

    However, I would like to know that is there any limit on the number of recipients to be sent?

    Zi Kang Yeoh May 21, 2020 2:54 pm Reply
  • This was a huge help!!!! Exactly was I was needing!

    Megan Cumbee May 21, 2020 2:54 pm Reply
  • Awesome content.

    Ric Mistri May 21, 2020 2:54 pm Reply
  • I don't have the mailings tab.. is that only on the only if you are a premium member.. cause It's nowhere on word for me but everything else is

    GooberVlogs May 21, 2020 2:54 pm Reply
  • What if you have an attachment (certificates) for each individual.

    Alzira Lopes May 21, 2020 2:54 pm Reply
  • How can send emails to over 5k emails with this, please?

    victor bosah May 21, 2020 2:54 pm Reply
  • How does this work with outlook web access ??? thanks!!

    C Robson May 21, 2020 2:54 pm Reply
  • The only problem is. Sometime I dont want to use my default email account but a company email account which is set up in Outlook but i dont see the option to choose it.

    SOULREAVER May 21, 2020 2:54 pm Reply
  • Do I have an option to choose sending from email address, such as Helpdesk@…,instead of send out from my personal email at work?

    Tracy Fan May 21, 2020 2:54 pm Reply
  • THANK YOU! I had to do this for an assignment and was clueless before seeing your video.

    Alysha May 21, 2020 2:54 pm Reply
  • This was a good refresher. Thanks for sharing.

    Ivan Williams May 21, 2020 2:54 pm Reply
  • Thank you so much , You dont know how much you helped me, Thanks alot.

    Mu7ammadi1000 May 21, 2020 2:54 pm Reply
  • Hi I do everything as you say but my emails do not appear in my outbox. How can I fix this please

    Wanda Barnard May 21, 2020 2:54 pm Reply
  • Nice job, but you just went a little too fast and you never tell us how to choose from what email you want this to go. That is a big problem because it used my personal email address!

    Don Woodring May 21, 2020 2:54 pm Reply
  • How did he make it go to his outbox first then send it to the recipients? I need look over each individual email before I send it out?

    Latesha Dukes May 21, 2020 2:54 pm Reply
  • Thanks @kevin stratvert
    can we use mail merge to send up to 3000 emails per day ?

    Waleed Hamza May 21, 2020 2:54 pm Reply
  • Ok, this mail merge screwed me over big time. I triple checked my mail by sending copies to myself and my friend, worked fine. Today however, I send it out and it posts four duplicate names of all my contacts to some senior bankers showing: "Dear BlakeBlakeBlakeBlakeBlake," stuff like that. Why did this happen?? I sent this to over 100 people and it was very important so I'm kind of frustrated right now.

    Eric Jin May 21, 2020 2:54 pm Reply
  • This is exactly what I needed to learn in creating our virtual court during this pandemic, thank you so much!

    mugsy201 May 21, 2020 2:54 pm Reply
  • This was so helpful and explained perfectly, thank you Kevin

    SaanjD May 21, 2020 2:54 pm Reply
  • apparently you cannot do this with the "free" version of Office 365 because when you open word, blank document, mail merge is not an option listed.

    Judi Mott May 21, 2020 2:54 pm Reply
  • Hi how can send email, using a different outlook account?

    Shirlei C Hernandez May 21, 2020 2:54 pm Reply
  • Thank you so much! Very easy to follow and not long-winded.

    Corey Drennon May 21, 2020 2:54 pm Reply
  • This was a very big help. Thank you.

    Mary Anne Palleiko May 21, 2020 2:54 pm Reply
  • Perfect! Thank you so so much!!!!!

    Karina Rodriguez May 21, 2020 2:54 pm Reply
  • Just what I needed, and really simple too – thanks a lot!

    valerie Arnold May 21, 2020 2:54 pm Reply

Leave a Reply

Your email address will not be published. Required fields are marked *