Mail Merge - Send Bulk Mails easily

How to use mail merge to create e-mail messages in Word?

How to send bulk mails, addressing individuals but sending thru’ automation, without manual work?

Step1:

Start -> All Programs -> Microsoft Office -> Microsoft Excel 2010

Enter the data as below and save as “email.xlsx” file

Step2:

Start -> All Programs -> Microsoft Office -> Microsoft Word 2010

Under Mailings -> Start Mail Merge -> Click “Letters”

  

Write the message that you want to send as below

Now, to add the Names in the above message, do the below steps

Click Select Recipients -> Use Existing List… as shown below

Now, Select the file email.xlsx file from the desktop you have stored, as below

Click Open

Select the Worksheet “Sheet1” in the excel.xlsx as shown below:

Click OK
Now,  Place your cursor near the comma symbol in the text (Dear ,) and then, click Insert Merge Field -> Name as shown below

You will see below screen,

Now, Click Finish & Merge -> Send Email – Messages

(Note: you must have outlook configured in your machine)

In the below screen, select “emailed” in To section.  Enter Subject Line as below.

We would like the mail merge for 1^st two records from the excel sheet. (we have only 2 records in excel file email.xlsx). Hence enter from = 1, To = 2 under Send records

Click OK.

Message will be sent to all emails automatically.

You can see that, mails are sent and it is showing under sent items in your outlook box as below

And

Regards

Prem @ Sundaram