Excel to word autofill and auto populate???

[srinivasan1129]

Sir,

I got a excel data as follows:

Loan Acc no Name address 1 address 2 address 3 address 4 Loan Type Sanction date Sanction limit OS OD_AMT OUTOFORD SAN_LMT MOBILE 831210110004524 srinivasan.s 3, VOC colony Ellai thottam road Peelamedu Coimbatore Shop 10/01/2010 45000 -442956.00 69402.00 30/09/2014 294000 +919943092680 831210110004524 Ramesh innugur nadu road Peelamedu Coimbatore Shop 10/01/2010 45000 -442956.00 69402.00 30/09/2014 294000 +919943092680 831210110004524 Kandasamy kovakulam pakkama Peelamedu Coimbatore Shop 10/01/2010 45000 -442956.00 69402.00 30/09/2014 294000 +919943092680 831210110004524 Latha steppie pona Peelamedu Coimbatore Shop 10/01/2010 45000 -442956.00 69402.00 30/09/2014 294000 +919943092680 831210110004524 Jolly growth idhu dhan Peelamedu Coimbatore Shop 10/01/2010 45000 -442956.00 69402.00 30/09/2014 294000 +919943092680 831210110004524 Samy loose street seri illa Peelamedu Coimbatore Shop 10/01/2010 45000 -442956.00 69402.00 30/09/2014 294000 +919943092680 831210110004524 Pettai drunkandmunk nadakadhu Peelamedu Coimbatore Shop 10/01/2010 45000 -442956.00 69402.00 30/09/2014 294000 +919943092680 <colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody> </tbody>

I got a word document as follows: Mr. (NAME) Residing at ( address 1,), (Address 2,) ( address 3),( address 4 ) Availed (LOAN ACC. NO.) for the purpose of (LOAN TYPE) with us on (SANCTION DATE) of Rs. (SACTION LIMIT) with Rs. (OS) As you have not paid the dues on time the given loan is on due for (OD _DAYS) and amount of Rs. (OD_ AMOUNT)on (OUTOFORD) has to be paid in order to make the loan account normal. Please pay the dues with in (DATE GIVEN) in order to service you best. If already Paid ignore this letter. For further quires please contact us Address on cover Mr. (NAME) (Address1) (Address 2) (Address 3) (Address 4) (Mobile) What i need is to paste the data of excel in to respective paranthesis of word and generate a remainder letter. Could it be done using VB.macro in excel? if so pls give me VB script to try it

<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>