Excel to word autofill and auto populate???

[srinivasan1129]

Sir,

I got a excel data as follows:

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