
Open a new Excel document and add the required fields. Configuring your data in Excelįollow these steps to set up your Excel sheet: The entire process involves mainly two steps:Ĭonfiguring your email in Word and sending the emails. So assuming you have a small list, follow these steps to send personalized emails via mail merge in Outlook. This is not ideal for users who have a list of tens of thousands of recipients and need advanced personalization features. This is a suitable solution for users with a small list. You can send only 30 messages per minute.ĭue to these limitations, this method of sending emails may not be ideal for you. You can send emails to 10,000 recipients per day. Microsoft 365 subscribers’ sending limits sending limitsįor non-subscribers of Microsoft 365 subscriptions, the limits vary depending on the account’s credibility in the system.įor Microsoft 365 subscribers, you can send emails to a maximum of 5,000 recipients a day, and each message can be sent to a maximum of 500 recipients. Microsoft does impose a sending limit for these cases, as shown below. Outlook itself doesn’t have any sending limits but not in Outlook(dot)com and for Microsoft 365 subscribers. When should you use mail merge in Outlook? So let’s look at when you should and should not use mail merge in Outlook. However, you will find a few limitations while using this method, so it may not suit every scenario. In Outlook, you can use mail merge to send emails like greetings, offers, invoices, work attachments, holiday emails, etc. So make sure to install all three and set up your accounts before proceeding with the next steps. This method requires three tools from Microsoft: Word, Excel, and Outlook. Mail merge in Outlook is a method of sending personalized emails in Outlook. Perform mail merge in Outlook with attachments How to send personalized emails via mail merge in Outlook? Microsoft 365 subscribers’ sending limits. Let’s uncover the details of mail merge in Outlook and the method of sending personalized emails using it. All you need are three Microsoft apps: Word, Excel, and Outlook.
But you need not need to worry as you can use mail merge in Outlook to send personalized emails without using an ESP. However, you may require an all-in-one ESP to send personalized emails to a huge audience, and not everyone can afford one or have time to learn new ESP softwares. So the generic “Dear Customer” emails won’t make a good impression anymore. A study conducted by McKinsey & Company revealed that 71 percent of consumers expect to get personalized experiences in their commercial emails.