Mail merge is a powerful tool that allows you to send personalized emails to a large number of recipients based on a database. In this article, we will discuss the step-by-step process of how to do mailmerge from Excel to Word.

Step 1: Prepare Email Content in Microsoft Word

The first step in performing a mail merge is to write the email content in Microsoft Word. Open Microsoft Word and create a new document by clicking on the 'File' tab and selecting 'Blank Document'. This will open a new Word file where you can write your email content.

Step 2: Set Up Mail Merge Data in Microsoft Excel

Next, open your Excel file and set up three columns - Name, Date, and Email. The Name column is needed for the mail body, the Date column is used to format the date, and the Email column is used for sending the email.

'How to do Mailmerge'

Step 3: Link Mailing Information with Email

Now that you have set up your Excel file, it's time to link the Word file with the Excel file. Go to the 'Select Reception' group and choose 'Use an Existing List'. The Word file will format the mail based on the information from the Excel file.

Sending the Mail Merge

Once you have linked the Word file with the Excel file, you can send your email by clicking on the 'Send' button. You can also preview your email before sending it to ensure that everything is correct.

In conclusion, performing a mail merge from Excel to Word is a simple process that requires some basic steps. By following these steps, you can send personalized emails to a large number of recipients based on a database.

How to do mailmerge