Using Mail Merge in Microsoft Office Word

Anyone wanted to print same letter with different receiver name, or to send a single letter with different name to different email ids saved in Excel Sheet then Mail Merge is your solution.

Step 1:

Select the Mailings tab in Microsoft Word.

Step 2:

Click on the Start Mail Merge and Select Letters from the drop down list.

Step 3:

After that Click on the Select Recipients and select Use an Existing List, as you already have the Excel Sheet of the Recipients.

Step 4:

Find the Excel Sheet in your pc and double click the file.

Step 5:

A dialog box will open where the appropriate sheet containing data will be selected.

Step 6:

After that all the top buttons will become enabled, Select Insert Merge Field and Select the proper column number, your cursor on file should be placed where you want to print the names.

Step 7:

Now Click on Finish & Merge, and select print documents.

Step 8:

Select Range of the excel file, in this case All is selected to print letters for all names.

Step 9:

Select the printer that in this case is Foxit Phantom for pdf creation.

Step 10:

Select Save button and wait for some time, pdf file will be created and opened.

Now, in this procedure you had the excel file and created a single page in Word, After all this procedure you obtained number of pages equivalent to number of names in excel file.