Excel to word autofill and auto populate???

srinivasan1129

New Member
Joined
Apr 20, 2011
Messages
13
Sir,

I got a excel data as follows:

Loan Acc no
Nameaddress 1address 2address 3address 4
Loan Type
Sanction dateSanction limitOSOD_AMTOUTOFORDSAN_LMTMOBILE
831210110004524srinivasan.s3, VOC colonyEllai thottam roadPeelameduCoimbatoreShop10/01/201045000-442956.0069402.0030/09/2014294000+919943092680
831210110004524Rameshinnugurnadu roadPeelameduCoimbatoreShop10/01/201045000-442956.0069402.0030/09/2014294000+919943092680
831210110004524KandasamykovakulampakkamaPeelameduCoimbatoreShop10/01/201045000-442956.0069402.0030/09/2014294000+919943092680
831210110004524LathasteppieponaPeelameduCoimbatoreShop10/01/201045000-442956.0069402.0030/09/2014294000+919943092680
831210110004524Jollygrowthidhu dhanPeelameduCoimbatoreShop10/01/201045000-442956.0069402.0030/09/2014294000+919943092680
831210110004524Samyloose streetseri illaPeelameduCoimbatoreShop10/01/201045000-442956.0069402.0030/09/2014294000+919943092680
831210110004524PettaidrunkandmunknadakadhuPeelameduCoimbatoreShop10/01/201045000-442956.0069402.0030/09/2014294000+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>
 

Forum statistics

Threads
1,082,585
Messages
5,366,466
Members
400,892
Latest member
lamarh755

Some videos you may like

This Week's Hot Topics

Top