1. Set the structure of your data in ms excel like defining the column heading such as Name, Address and so on… as your database fields (later this will be used for making the mail merge in ms word)
2. Open a new word document or used your own ms word template to extract the data from ms excel.
3. In your word template or new document, go to Tools-> Letters and Mailings ->Mail Merge.
4. In the Mail Merge dialogue, select the type of document you are working on then click Next, then click Select Recipients, then click Browse, in the select data source dialogue, browse for the source data (excel file). Select the file and click Open then click Ok until you exit the source data dialogue.
5. Use the Mail Merge toolbar (for me this is easier to use than the mail merge dialogue). Go to View->Toolbar->Mail Merge.
6. Put the cursor on the document you want to insert data from the excel file and from the mail merge toolbar click Insert Merge Fields, from then you can see all the available database fields (column heading) you've created in excel.
7. To view merge data, from the Mail Merge toolbar, click View Merge Data. From the toolbar click Next record or First record to navigate through the data.
If you want to print the entire document with the merge data, you can do so by clicking the Merge to Printer button from the Mail Merge Toolbar.
I have attached a sample for your reference. Source data (xl file) & target (word document)
the above are my own opinion of using mail merge, apologies for any incorrect information)
Bookmarks