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>
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Forum statistics

Threads
1,214,965
Messages
6,122,500
Members
449,090
Latest member
RandomExceller01

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top