I have a word document (summary.doc)with a certain template and information on the top (mainly summary) about a certain region.
When the summary part ends, I want to add some details of information to the word file for that region eg. Name, Address, Age, Contact etc. from another excel file which has all these datas (Employee code will be the primary key to get all these datas to be imported into the word file). The excel file is called data.xls. If the region has 5 employees, then all 5 employee detail should come in 5 lines (or table), one line for each employee with the above details.

The Summary part has all the required texts already entered and it occupies around 15 lines in the word sheet (summary.doc). After the summary, I would like to write a macro which would add all the required information to the word sheet from the excel sheet.

Any help on how to go about this with a macro would be appreciated.