#Merge data from excel to word how to#

And open a new spreadsheet.Ĭreate a new row for each recipient in your mail merge. The next step is to prepare your mail merge data. Use placeholders such as whenever you want to personalize your email. And then select Email messages.Ĭompose your email in your Microsoft Word document. The easiest way to create one is to open a new Microsoft Word document on your computer.

To create a mail merge, you need 2 things. Sounds good? Then let’s see how you can use a Microsoft Excel spreadsheet to set up your mail merge data. Which will in turn lead to higher response rates. Your recipients will feel like your email was written specifically for them. Because you can use Excel’s mail merge feature to send customized messages. And use it to personalize your template email in Word. Microsoft will then fetch your data in Excel (first names, email addresses, company names…). Instead of writing a different email for each recipient (which would be way too long), you can create a template email in Word. Mail merge is a powerful Microsoft Excel feature that lets you send personalized emails.

#Merge data from excel to word how to#

Unless you learn how to mail merge in Excel. And send them manually.īut what if you want to invite 50, 500 or even 5,000 people? This is going to take an absurd amount of time. If you want to invite 5 people, this shouldn’t be a problem. Making sure to address each of your recipients by their first name. So you decide to personalize your message. And you know that a generic email won’t cut it. You want to send out an email to invite multiple recipients to an upcoming event.

In this quick guide, we’ll show you how to mail merge in Excel. Mail merge is a built-in Excel feature that lets you send customized emails to hundreds or even thousands of recipients.