Use Mail Merge to Send Bulk Emails Messages from Outlook
Вставка
- Опубліковано 9 лют 2025
- Learn how to use mail merge to send bulk email message from Outlook. This is ideal for anyone that needs to send the same email message to multiple contacts. In this step-by-step video tutorial, I will show you how to set up your mail merge using an Excel contact lists to personalise your email message, helping the customer to feel valued when the email is addressed to them.
🎵 Music and Sound FX from Epidemic Sound:
share.epidemic...
WATCH ME NEXT
✅️ Stop using VLOOKUP in Excel there is an EASIER way...
• Stop using VLOOKUP in ...
✅️ How to EASILY convert a Word document into PowerPoint slides
• How to EASILY convert ...
✅️ How to embed an Excel file into Word
• How to embed an Excel ...
🚨 MASTERCLASSES
👉 Master the basics of Microsoft Excel in less than time you think!
readysteadyexc...
🏃♂️ DON'T GET LEFT BEHIND
www.readystead...
📧 LET'S CONNECT
Email: AskTony@ReadySteadyXL.com
☕️ FUELLED BY COFFEE
www.buymeacoff...
Disclaimer: Some of the links in this description are affiliate links, where I earn a small commission on any of your purchases at no additional cost to you. This helps to support the content I provide on the Ready Steady Excel Channel. Thank you for your support.
#ReadySteadyExcel
📌 Was this useful? What do you want to learn next?
sir i did everything in the video and no errors but nothing happened no emails sent and didn't even appear in the sent ithems
Hey, I send the emails but I can't see them. And when I checked they weren't actually sent.
it is useful and thank you for the sharing! just one questions, what if we need to do the attachment before send out the email, how should we do?
same with me happened@@eduardpascu396
not for me... I do not have a mailings tab
I dont normally comment but this was actually useful for my job thanks :)
Amazing! Thank you for commenting, glad you found this video useful.
Useful refresher - thanks!
@@Vlowman Thanks for the feedback and for watching 😊😊
This was the BEST tutorial I've ever watched on this subject. Thanks so much for making mail merging easy.
Thank you very much for the great feedback. Much appreciated. Glad you found my video 😊😊😊
I had zero knowledge of mail merge before this and now it makes so much sense.
@@roughryder5 Great to hear this. Thanks for the feedback 😊😊😊
Thank you for a very simple easy to understand tutorial!
@@lynntjerne3826 Great to hear thank you 😊😊😊
Huge help! Thank you!
Great to hear. Thank you 😊😊😊
@ReadySteadyExcel I'm using it for commercial prospecting and this has been huge. I truly appreciate this video.
3 mins video just saved me a world of stress of sending over 600 emails individually. This is highly valuable.
Thank you so much.
Amazing! Thank you for the great feedback. Happy to hear that I saved you a lot of time 😊😊😊
very informative. Thank you for saving lots of time.
Thank you very much. Happy to hear it save you time 😊😊😊
Thank you so so so much! This was so easy to follow and my emails went with ease!
So glad to hear this. Thanks for the feedback 😊😊😊
Thank you SO much for making my day 10000% easier
So helpful and easy to follow
And it worked 🎉🎉
@captivatedinspired2035 thanks for the amazing feedback. Glad worked for you 😊😊😊
This is so useful tutorial, thank you so much!
Glad it was helpful!
Extremely useful! Thank you
Thank you Jeremy 😊
Thank you, this was really helpful. Could you pleae let us know if we can add a CC email address
Thanks for the feedback 😊...you can't add CC email without third party software
Thank you for your effort, this works great!
Thank you 😊😊😊
Super useful
Thank you 😊😊😊
Thanks useful.
Thank you 😊😊😊
Thanks!! Awesome video that helped a ton!
Thank you. Glad you found it helpful 😊😊😊
Thank you. What about when you have multiple email addresses in outlook? How does it choose?
Hi Very Helpful video. Please could you show if you also have to attach documents to the email for eg for sales video.Thank you
Thank you for the great feedback and question. The best way is to include a OneDrive link to the attachment. I will look to do a video on this
This works, great idea. It will be helpful if you can help with tips to adding CC member to each mail.
@shubhammurkute4981 not sure you can easily. Will take a look
Thank you, very helpful!
Thank you for the feedback 😊😊😊
Very useful, thank you! Where do you set the email account it should be sent from pls? Mine was set to default but it used another account.
Thank you 😊😊😊...it will send from the default email in Outlook.
@@ReadySteadyExcel Is there any way to change the email? I have a few different emails in outlook that I would like to send it from. Is that possible? Thank you!
Thank you for your clear tutorial. I've followed your instruction to the letter. I was logged into my Outlook, but the emails did not send. I tried sending it again but still not successful. I also noticed that after sending the email from Word, Word hangs. It happened the 1st time I tried sending the email and after I tried the 2nd time, I noticed Word has frozen again. What could be wrong here? thanks.
Thanks for the feedback 😊....how many emails are your sending? Try with fewer emails
Thank you for the video, I've followed all the procedures to detail but my message was not sent. What might be the possible cause pls?
Not sure. Some people have reported that you need to be using the same account in Outlook and Word. But this also depends what version of Microsoft Office you're using
@@ReadySteadyExcel Ok, thank you. I use the same Word and Outlook account and my Microsoft office app is up to date.
Hello - First of all, thank you very much for this message. this is very helpful.
I want to ask, is there a way to have multiple recipients in one email because when I tried this, there is only one recipient per email.
Also, I also need to copy another email, is there a way to also include CC field?
Lastly, can we have an attachment when using this mailmerge?
Thanks for the feedback and questions. You need 3rd Party add-in to do the things you've asked for. Sadly these are not available in Microsoft
Great video, thank you! How can I add a BCC field to this so I can send a copy to a third email address each time?
Ah, I just found out, it seems it's not possible to add cc/bcc, oh well.
@S4l4m4nder36 yeah sadly it's not available without using a 3rd party software.
This was super helpful thank you. Within Outlook I have a number of Email Accounts. How do I specify which email account the mails shoud be sent from?
Thanks for the feedback 😊....it will send from the default account in Outlook.
The last step merge to email is blurred out and can't be clicked on, any idea why?
Can I track open rates and click-through rates for bulk emails sent using a free tool in Outlook?
Viva Insights can do this in the new Outlook
@@ReadySteadyExcel Thank you
Is it possible to automate the names into the subject line as well?
Hey, can you CC the same email address in this? Amazing video btw!
Thank you 😊😊😊....Sadly you can't without using 3rd party software
Wonderful. I’d love to insert a PDF to the email, the same PDF to every recipients. Is that possible ?
@rynairi great question. You can't add an attachment without using a third party add-in. I will have a look into this to see if there is a secure option
Nice video and explanations but what about attachments ?
@rajupatel-js1qd Thanks for the feedback and question. Currently you can't do this without using a third party software. I wouldn't risk using one of these without checking the data security.
Hey, I just followed all the steps, did not receive any error, the e-mails are not in Outbox or Sent folders, any idea? Thank you.
Some have reported that you need to be logged into the same account in Word and Outlook.
What if you have two email addresses you work from - how do you choose the right one for it to be sent from?
It will use your default one
I did this and it worked perfect. I sent out a little over 100 emails.
But I want to point out, make sure you’re signed into WORD with the same outlook email you want to use.
While it worked, it went out of my personal inbox because my word was not signed in to my work email.
@mcgusto82 Oh good tip! Thanks for this! Maybe this is why it's not working for everyone
A little more clumbsy than the paid email services but free and worked great. Does anyone know if you can add a merge field on the subject line?
Is there a way to do this where you'd like a single email to go to more than one email address?
@@AubrieTalarico that's what this one does. Did you mean something else?
شكرا
Do we need Outlook 365 or it can be done by outlook new as well.
@@SUYASHDEWANGAN-ly4dk It's been around for a while. It will use use your default mail application
@@ReadySteadyExcel actually my question is related to the outlook new mail app. It's not working for me. Any suggestions for that?
@@SUYASHDEWANGAN-ly4dk Just make sure you're logged in with the same account on Word and the New Outlook. I used the new Outlook in this video
is there a limit per day
No limits 😊
It did not go through. I did everything you instructed.
me too
Questions - I want to attach a document to the email and I also want the subject to be different
Good questions. You will need a third party software to add the attachments and if you want to include a merge field in the subject line.
i have a Office 2007, all the options i am getting which you shown on your video, but How to ADD email on Word microsoft office 2007???
please help
Hi, why is not showing my sent items in outlook? what could be the possible reasons? please help...Thanks.
Someone said you need to make sure you're logged in with the same email in Word and Outlook.
Can you please share how to add an unsubscribe option for customers within the bulk e-mails? Also, would it be possible to do this without the customers having to be redirected to our website to unsubscribe? Is there a way they can just click unsubscribe and it automatically removes them from the mailing list?
Great question - It's not possible without redirecting the users to another page. I use Mailerlite, which is free up to 1,000 contacts.
How to put in CC ?
@ElvisMultani-t2u Sadly you can't with this method. You would need to use a 3rd party software.
I have three email accounts in Outlook: company, educational, and personal. I want to connect them to a Word file. How can this be done?
F
How to stop such campaign after launching?
@Dina-zu7zk Once the emails have sent you can't stop it. However, you can stop the process of sending, by goinf offline then delete the emails from the outbox. This is what I did in this video to stop from sending
I wonder which email will it come from? since we did not put email from? I tried this method but its not working. I dont see any sent email from my outlook.
@HoneyRoseLopez it's through your Outlook windows version. So which ever email address is set up there. Someone commented recently that you need to make sure your log into Word with the same email address as your Outlook
@@ReadySteadyExcel Thanks for the reply! Can I just say that it didnt go through if its nowhere to be found in any of my sent items then?
@HoneyRoseLopez If it's not in your sent items it hasn't been sent. Are the emails in your Outbox?
@@ReadySteadyExcel yes, maybe good to know that I am trying to do this on shared mailbox.
Is it also possible to mark the mail as "IMPORTANT" before sending them?
Great question! Not with this method but I will look into another way
what about on word online? there is no mailings button
@nazsolomon8164 oh good question. I haven't tried from there. I will take a look
I did all the steps, the excel sheet has 2 recipients (as a test) but it doesn't work, why do u think that happened? i cant figure out the problem, can u help me plz?
Thanks for the feedback. A couple of people have reported this. Not sure why it's not sending. What version of Excel and Outlook are you using?
Make sure that you're logged into the correct Microsoft account (look in the top right next to the minimize button) in your Word and Excel. I was logged into another account and i clicked on that and changed it to the correct account and then it sent the emails.
Just a warning, it sent them twice/sent the ones i had tried yo send before once it connected correctly.
Hey, I send the emails but I can't see them. They are not actually send.
same happened to me
I cant see any email
Sent. Not working for me. Can you please guide me
same here
same
@@eduardpascu396
Hello, I have the same issue did you manage to solve it please?
How to attach doc
you need 3rd party add-in to do this
How to attach a pdf file with email....
You can't in this way without using 3rd party software
3rd party software like? Plz help@@ReadySteadyExcel
How do I get bulk emails?
Sorry not sure what you're asking
How to setup "TO" ?
Sorry not sure what you mean
You said that you were going to tell us more about the headers in a moment... there was no moment. Can you help?
I talked about the headers when got to Word, when I talked about the merge fields.
How to add attachments to Word/Outlook mail merge campaigns?
Great question. You can do this using a third party add-in or save the files to OneDrive, then add the links to files in your data source and then insert this as merge field.
dont you think its still long process ?
@@ReadySteadyExcel
Rhetorical question. What I don't understand is why we need Word. Why can't we do this from Outlook?
@CarlosGreenos I haven't tried it for a while but you could do it from your Outlook Contacts. However, from what I can remember, you couldn't insert fields into the body of the email like you can from word.
my word failed to open to excel
Was it already open? Make sure its closed
you are going too fast have to restart often
Thank you for the feedback - I will slow down
Its a great video, his pace is refreshing. Its hard to find high content per minute these days.
For those who find it hard to follow, turn the videospeed down.
@Rookie2Hero Amazing feedback! Thank you so much...this means a lot! I created a video on how to slow a video down ua-cam.com/video/T6e_4yXzCuc/v-deo.html 😉
This is not very useful
@ankursharma7812 thanks for the feedback. Why not?
Can I track open rates and click-through rates for bulk emails sent using a free tool in Outlook?
Viva Insights does this in the new Outlook. I've done it for up to 300 recipients. There is a limit but can't remember the number. Viva Insights will tell you if there are too many recipients to track.