Using Mail Merge Feature of MS Word and convert by Mail merge from excel to word:
How to use Mail Merge tool in MS Word with Excel Data or the way to insert addresses, names, phone number and other fields to MS Word automatically? This is a powerful feature to generate hundreds of thousands of letters from word template using data in Excel Sheet. This comes as handy because it frees us from the hassle of manually typing data in word files.
Illustration of Mail Merge:
Given the below template, we are advised to generate 10,000/- letters using data from an excel sheet with the columns as show in picture-1
Word Document Template for Mail Merge:
Respected Mr. (Insert Customer Name from MS Excel)
(Insert Customer Address and phone from Excel)
SUB: BILLING NOTICE FOR OVER USAGE OF TELEPHONE
This is to request you for an early payment your postpaid connection because you have overused the allowed limit for Rs. (Insert from MS Excel Sheet) and you might face data shortage which might cause inconvenience to you. You are once again requested for an early payment.
Thanks & best regards,
Finance & Recovery Division,
Let us find the easiest way for Step by step Mail Merge in MS word and MS Excel:
Step 1 Mail Merge:
Open the word file and paste the drafted text in it. (Picture show below)
Step 2 Mail Merge:
On Menu bar of MS Word, click Mailings:
Step 3 Mail Merge
: Within the tab of Mailings, Click “Start Mail Merge”.
Step 4: Mail Merge
Click on the last option: Step by Step Mail Merge Wizard as below highlighted:
Step 5: Mail Merge
On the right side bottom of your word document click on
Step 6:Mail Merge
Click on the link as show below:
Step 7: Mail Merge
After clicking the above link( as in the picture), you will be given the following list:
We should choose “Brose…” since we need to insert data from MS excel. However, the first option allows you to use and existing list for mail merge while the second one gives the option to “Select from Outlook contacts” and we may also write the specific names in “Type a new list”.
Select the file (in this case Excel file “MailMerge.xlsx”):
Step 8: Mail Merge
Select the excel sheet where your data is stored: in our case Sheet1$ is selected. And click ok.
Step 9: Mail Merge
within the “Mailings Tab”, click Insert field list.
Step 10: Mail Merge
Select customer Name from the given the list.
Mail Merge Step 11:
Once we have selected the field, it will be shown in the word document:
The grey area is our field inserted from excels data.
Mail Merge Step 12:
Select and insert all the fields from the drop down list.
Mail Merge Step 13:
Use the extreme right button “Finish & Merge” to finalize your document for Mail Merge.
This completes the document for mail merge.
Feel free to ask questions in the comment box below.