Hi I am Preethi,
Please help me in VB Script
I have large excel file which I have to mail the particular line items to customers.
(for example)
[TABLE="width: 2587"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Code[/TD]
[TD] Amt [/TD]
[TD]DZ[/TD]
[TD]Customer Name[/TD]
[TD]WPP CODE[/TD]
[TD]UTR NO/CHQ NO[/TD]
[TD]Payment Date[/TD]
[TD]Invoices[/TD]
[TD]Invoice date[/TD]
[TD]INVOICE VALUE[/TD]
[TD]Days[/TD]
[TD]CD -1.5%[/TD]
[TD]CD 1%[/TD]
[TD]Total CD -1.5%[/TD]
[TD]Total CD -1%[/TD]
[TD]CN Amount[/TD]
[TD]New Agg.N.[/TD]
[TD]DA- 9042[/TD]
[TD]PC- 9044[/TD]
[TD]Code[/TD]
[TD] Amt [/TD]
[TD]DZ[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD="align: right"]1184000[/TD]
[TD="align: right"]1400004124[/TD]
[TD]Indian Watch Distributors[/TD]
[TD="align: right"]100088186[/TD]
[TD]CH-928676[/TD]
[TD="align: right"]Thursday, March 28, 2019[/TD]
[TD]UP0520003684[/TD]
[TD="align: right"]07-03-19 [/TD]
[TD="align: right"]121367.43[/TD]
[TD="align: right"]21[/TD]
[TD] [/TD]
[TD="align: right"]1213.67[/TD]
[TD="align: right"]15635.38[/TD]
[TD="align: right"]1416.41[/TD]
[TD="align: right"]17051.79[/TD]
[TD="align: right"]775[/TD]
[TD="align: right"]10231.08[/TD]
[TD="align: right"]6820.72[/TD]
[TD] [/TD]
[TD="align: right"]2798824248[/TD]
[TD="align: right"]4197644372[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Thursday, March 28, 2019[/TD]
[TD]UP0520003664[/TD]
[TD="align: right"]07-03-19 [/TD]
[TD="align: right"]20273.62[/TD]
[TD="align: right"]21[/TD]
[TD] [/TD]
[TD="align: right"]202.74[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Thursday, March 28, 2019[/TD]
[TD]UP0520003726[/TD]
[TD="align: right"]13-03-19[/TD]
[TD="align: right"]44001.68[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]660.03[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Thursday, March 28, 2019[/TD]
[TD]UP0520003729[/TD]
[TD="align: right"]13-03-19[/TD]
[TD="align: right"]9733.16[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]146.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Thursday, March 28, 2019[/TD]
[TD]UP0520003727[/TD]
[TD="align: right"]13-03-19[/TD]
[TD="align: right"]138463.9[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]2076.96[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Thursday, March 28, 2019[/TD]
[TD]UP0520003728[/TD]
[TD="align: right"]13-03-19[/TD]
[TD="align: right"]236072.71[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]3541.09[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Thursday, March 28, 2019[/TD]
[TD]UP0520003734[/TD]
[TD="align: right"]13-03-19[/TD]
[TD="align: right"]18315.96[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]274.74[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Thursday, March 28, 2019[/TD]
[TD]UP0520003730[/TD]
[TD="align: right"]13-03-19[/TD]
[TD="align: right"]7409.19[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]111.14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Thursday, March 28, 2019[/TD]
[TD]UP0520003731[/TD]
[TD="align: right"]13-03-19[/TD]
[TD="align: right"]36263.76[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]543.96[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Thursday, March 28, 2019[/TD]
[TD]UP0520003732[/TD]
[TD="align: right"]13-03-19[/TD]
[TD="align: right"]4939.46[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]74.09[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Thursday, March 28, 2019[/TD]
[TD]UP0520003733[/TD]
[TD="align: right"]13-03-19[/TD]
[TD="align: right"]221976.88[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]3329.65[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Thursday, March 28, 2019[/TD]
[TD]UP0520003735[/TD]
[TD="align: right"]13-03-19[/TD]
[TD="align: right"]221976.88[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]3329.65[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Thursday, March 28, 2019[/TD]
[TD]UP0520003736[/TD]
[TD="align: right"]13-03-19[/TD]
[TD="align: right"]50736.7[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]761.05[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Thursday, March 28, 2019[/TD]
[TD]UP0520003737[/TD]
[TD="align: right"]13-03-19[/TD]
[TD="align: right"]51739.12[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]776.09[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Thursday, March 28, 2019[/TD]
[TD]UP0520003891[/TD]
[TD="align: right"]23-03-19[/TD]
[TD="align: right"]729.55[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]10.94[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[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] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD="align: right"]382000[/TD]
[TD="align: right"]1400005676[/TD]
[TD]Balaji Electronics[/TD]
[TD="align: right"]100088172[/TD]
[TD]CH-000781[/TD]
[TD="align: right"]Monday, April 22, 2019[/TD]
[TD]HR0120046941[/TD]
[TD="align: right"]26-03-19[/TD]
[TD="align: right"]59722.86[/TD]
[TD="align: right"]27[/TD]
[TD] [/TD]
[TD="align: right"]597.23[/TD]
[TD] [/TD]
[TD="align: right"]3820.00[/TD]
[TD="align: right"]3820.00[/TD]
[TD="align: right"]775[/TD]
[TD="align: right"]2292.00[/TD]
[TD="align: right"]1528.00[/TD]
[TD] [/TD]
[TD="align: right"]2799629352[/TD]
[TD="align: right"]4199253028[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Monday, April 22, 2019[/TD]
[TD]HR0120046951[/TD]
[TD="align: right"]26-03-19[/TD]
[TD="align: right"]172026.97[/TD]
[TD="align: right"]27[/TD]
[TD] [/TD]
[TD="align: right"]1720.27[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Monday, April 22, 2019[/TD]
[TD]HR0120046937[/TD]
[TD="align: right"]26-03-19[/TD]
[TD="align: right"]43546.66[/TD]
[TD="align: right"]27[/TD]
[TD] [/TD]
[TD="align: right"]435.47[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Monday, April 22, 2019[/TD]
[TD]HR0120047509[/TD]
[TD="align: right"]28-03-19[/TD]
[TD="align: right"]91219.06[/TD]
[TD="align: right"]25[/TD]
[TD] [/TD]
[TD="align: right"]912.19[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Monday, April 22, 2019[/TD]
[TD]HR0120048916[/TD]
[TD="align: right"]06-04-19 [/TD]
[TD="align: right"]15484.45[/TD]
[TD="align: right"]16[/TD]
[TD] [/TD]
[TD="align: right"]154.84[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[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] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD="align: right"]115000[/TD]
[TD="align: right"]1400005086[/TD]
[TD]DOORS TECHNOLOGIES[/TD]
[TD="align: right"]100093753[/TD]
[TD]CH-414778[/TD]
[TD="align: right"]Friday, April 12, 2019[/TD]
[TD]HR0120040544[/TD]
[TD="align: right"]24-02-19[/TD]
[TD="align: right"]33537.93[/TD]
[TD="align: right"]47[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]401.65[/TD]
[TD="align: right"]401.65[/TD]
[TD="align: right"]775[/TD]
[TD="align: right"]240.99[/TD]
[TD="align: right"]160.66[/TD]
[TD] [/TD]
[TD="align: right"]2799895172[/TD]
[TD="align: right"]4199785258[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Friday, April 12, 2019[/TD]
[TD]HR0120040545[/TD]
[TD="align: right"]24-02-19[/TD]
[TD="align: right"]15341.54[/TD]
[TD="align: right"]47[/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] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Friday, April 12, 2019[/TD]
[TD]HR0120041573[/TD]
[TD="align: right"]27-02-19[/TD]
[TD="align: right"]25955.1[/TD]
[TD="align: right"]44[/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] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Friday, April 12, 2019[/TD]
[TD]HR0120045061[/TD]
[TD="align: right"]15-03-19[/TD]
[TD="align: right"]11284.1[/TD]
[TD="align: right"]28[/TD]
[TD] [/TD]
[TD="align: right"]112.84[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Friday, April 12, 2019[/TD]
[TD]HR0120045245[/TD]
[TD="align: right"]15-03-19[/TD]
[TD="align: right"]28881.33[/TD]
[TD="align: right"]28[/TD]
[TD] [/TD]
[TD="align: right"]288.81[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[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] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD="align: right"]821000[/TD]
[TD="align: right"]1400005582[/TD]
[TD]DOORS TECHNOLOGIES[/TD]
[TD="align: right"]100093753[/TD]
[TD]CH-414777[/TD]
[TD="align: right"]Tuesday, April 16, 2019[/TD]
[TD]HR0120045245[/TD]
[TD="align: right"]15-03-19[/TD]
[TD="align: right"]3562.53[/TD]
[TD="align: right"]32[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]7462.49[/TD]
[TD="align: right"]7462.49[/TD]
[TD="align: right"]775[/TD]
[TD="align: right"]4477.49[/TD]
[TD="align: right"]2985.00[/TD]
[TD] [/TD]
[TD="align: right"]2799190164[/TD]
[TD="align: right"]4198374746[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Tuesday, April 16, 2019[/TD]
[TD]HR0120045065[/TD]
[TD="align: right"]15-03-19[/TD]
[TD="align: right"]15941.22[/TD]
[TD="align: right"]32[/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] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Tuesday, April 16, 2019[/TD]
[TD]HR0120045066[/TD]
[TD="align: right"]15-03-19[/TD]
[TD="align: right"]4933.34[/TD]
[TD="align: right"]32[/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] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Tuesday, April 16, 2019[/TD]
[TD]HR0120045062[/TD]
[TD="align: right"]15-03-19[/TD]
[TD="align: right"]6314.12[/TD]
[TD="align: right"]32[/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] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Tuesday, April 16, 2019[/TD]
[TD]HR0120045308[/TD]
[TD="align: right"]16-03-19[/TD]
[TD="align: right"]43999.66[/TD]
[TD="align: right"]31[/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] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Tuesday, April 16, 2019[/TD]
[TD]HR0120045631[/TD]
[TD="align: right"]19-03-19[/TD]
[TD="align: right"]144307.86[/TD]
[TD="align: right"]28[/TD]
[TD] [/TD]
[TD="align: right"]1443.08[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Tuesday, April 16, 2019[/TD]
[TD]HR0120045632[/TD]
[TD="align: right"]19-03-19[/TD]
[TD="align: right"]13318.62[/TD]
[TD="align: right"]28[/TD]
[TD] [/TD]
[TD="align: right"]133.19[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Tuesday, April 16, 2019[/TD]
[TD]HR0120045635[/TD]
[TD="align: right"]19-03-19[/TD]
[TD="align: right"]393110.96[/TD]
[TD="align: right"]28[/TD]
[TD] [/TD]
[TD="align: right"]3931.11[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Tuesday, April 16, 2019[/TD]
[TD]HR0120045642[/TD]
[TD="align: right"]19-03-19[/TD]
[TD="align: right"]19733.38[/TD]
[TD="align: right"]28[/TD]
[TD] [/TD]
[TD="align: right"]197.33[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Tuesday, April 16, 2019[/TD]
[TD]HR0120045645[/TD]
[TD="align: right"]19-03-19[/TD]
[TD="align: right"]34214.38[/TD]
[TD="align: right"]28[/TD]
[TD] [/TD]
[TD="align: right"]342.14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Tuesday, April 16, 2019[/TD]
[TD]HR0120045646[/TD]
[TD="align: right"]19-03-19[/TD]
[TD="align: right"]141563.93[/TD]
[TD="align: right"]28[/TD]
[TD] [/TD]
[TD="align: right"]1415.64[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[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] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD="align: right"]272000[/TD]
[TD="align: right"]1400006410[/TD]
[TD]DOORS TECHNOLOGIES[/TD]
[TD="align: right"]100093753[/TD]
[TD]CH-414746[/TD]
[TD="align: right"]Tuesday, April 23, 2019[/TD]
[TD]HR0120046889[/TD]
[TD="align: right"]26-03-19[/TD]
[TD="align: right"]56946.32[/TD]
[TD="align: right"]28[/TD]
[TD] [/TD]
[TD="align: right"]569.46[/TD]
[TD] [/TD]
[TD="align: right"]2720.00[/TD]
[TD="align: right"]2720.00[/TD]
[TD="align: right"]775[/TD]
[TD="align: right"]1632.00[/TD]
[TD="align: right"]1088.00[/TD]
[TD] [/TD]
[TD="align: right"]2799740820[/TD]
[TD="align: right"]4199475230[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Tuesday, April 23, 2019[/TD]
[TD]HR0120046891[/TD]
[TD="align: right"]26-03-19[/TD]
[TD="align: right"]33252.19[/TD]
[TD="align: right"]28[/TD]
[TD] [/TD]
[TD="align: right"]332.52[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
Above data I need to send it for different respective customers from this file directly
Can you please help into this which will be more helpful me.
Thanks and Regards,
R Preethi
Please help me in VB Script
I have large excel file which I have to mail the particular line items to customers.
(for example)
[TABLE="width: 2587"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Code[/TD]
[TD] Amt [/TD]
[TD]DZ[/TD]
[TD]Customer Name[/TD]
[TD]WPP CODE[/TD]
[TD]UTR NO/CHQ NO[/TD]
[TD]Payment Date[/TD]
[TD]Invoices[/TD]
[TD]Invoice date[/TD]
[TD]INVOICE VALUE[/TD]
[TD]Days[/TD]
[TD]CD -1.5%[/TD]
[TD]CD 1%[/TD]
[TD]Total CD -1.5%[/TD]
[TD]Total CD -1%[/TD]
[TD]CN Amount[/TD]
[TD]New Agg.N.[/TD]
[TD]DA- 9042[/TD]
[TD]PC- 9044[/TD]
[TD]Code[/TD]
[TD] Amt [/TD]
[TD]DZ[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD="align: right"]1184000[/TD]
[TD="align: right"]1400004124[/TD]
[TD]Indian Watch Distributors[/TD]
[TD="align: right"]100088186[/TD]
[TD]CH-928676[/TD]
[TD="align: right"]Thursday, March 28, 2019[/TD]
[TD]UP0520003684[/TD]
[TD="align: right"]07-03-19 [/TD]
[TD="align: right"]121367.43[/TD]
[TD="align: right"]21[/TD]
[TD] [/TD]
[TD="align: right"]1213.67[/TD]
[TD="align: right"]15635.38[/TD]
[TD="align: right"]1416.41[/TD]
[TD="align: right"]17051.79[/TD]
[TD="align: right"]775[/TD]
[TD="align: right"]10231.08[/TD]
[TD="align: right"]6820.72[/TD]
[TD] [/TD]
[TD="align: right"]2798824248[/TD]
[TD="align: right"]4197644372[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Thursday, March 28, 2019[/TD]
[TD]UP0520003664[/TD]
[TD="align: right"]07-03-19 [/TD]
[TD="align: right"]20273.62[/TD]
[TD="align: right"]21[/TD]
[TD] [/TD]
[TD="align: right"]202.74[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Thursday, March 28, 2019[/TD]
[TD]UP0520003726[/TD]
[TD="align: right"]13-03-19[/TD]
[TD="align: right"]44001.68[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]660.03[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Thursday, March 28, 2019[/TD]
[TD]UP0520003729[/TD]
[TD="align: right"]13-03-19[/TD]
[TD="align: right"]9733.16[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]146.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Thursday, March 28, 2019[/TD]
[TD]UP0520003727[/TD]
[TD="align: right"]13-03-19[/TD]
[TD="align: right"]138463.9[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]2076.96[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Thursday, March 28, 2019[/TD]
[TD]UP0520003728[/TD]
[TD="align: right"]13-03-19[/TD]
[TD="align: right"]236072.71[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]3541.09[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Thursday, March 28, 2019[/TD]
[TD]UP0520003734[/TD]
[TD="align: right"]13-03-19[/TD]
[TD="align: right"]18315.96[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]274.74[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Thursday, March 28, 2019[/TD]
[TD]UP0520003730[/TD]
[TD="align: right"]13-03-19[/TD]
[TD="align: right"]7409.19[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]111.14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Thursday, March 28, 2019[/TD]
[TD]UP0520003731[/TD]
[TD="align: right"]13-03-19[/TD]
[TD="align: right"]36263.76[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]543.96[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Thursday, March 28, 2019[/TD]
[TD]UP0520003732[/TD]
[TD="align: right"]13-03-19[/TD]
[TD="align: right"]4939.46[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]74.09[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Thursday, March 28, 2019[/TD]
[TD]UP0520003733[/TD]
[TD="align: right"]13-03-19[/TD]
[TD="align: right"]221976.88[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]3329.65[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Thursday, March 28, 2019[/TD]
[TD]UP0520003735[/TD]
[TD="align: right"]13-03-19[/TD]
[TD="align: right"]221976.88[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]3329.65[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Thursday, March 28, 2019[/TD]
[TD]UP0520003736[/TD]
[TD="align: right"]13-03-19[/TD]
[TD="align: right"]50736.7[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]761.05[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Thursday, March 28, 2019[/TD]
[TD]UP0520003737[/TD]
[TD="align: right"]13-03-19[/TD]
[TD="align: right"]51739.12[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]776.09[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Thursday, March 28, 2019[/TD]
[TD]UP0520003891[/TD]
[TD="align: right"]23-03-19[/TD]
[TD="align: right"]729.55[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]10.94[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[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] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD="align: right"]382000[/TD]
[TD="align: right"]1400005676[/TD]
[TD]Balaji Electronics[/TD]
[TD="align: right"]100088172[/TD]
[TD]CH-000781[/TD]
[TD="align: right"]Monday, April 22, 2019[/TD]
[TD]HR0120046941[/TD]
[TD="align: right"]26-03-19[/TD]
[TD="align: right"]59722.86[/TD]
[TD="align: right"]27[/TD]
[TD] [/TD]
[TD="align: right"]597.23[/TD]
[TD] [/TD]
[TD="align: right"]3820.00[/TD]
[TD="align: right"]3820.00[/TD]
[TD="align: right"]775[/TD]
[TD="align: right"]2292.00[/TD]
[TD="align: right"]1528.00[/TD]
[TD] [/TD]
[TD="align: right"]2799629352[/TD]
[TD="align: right"]4199253028[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Monday, April 22, 2019[/TD]
[TD]HR0120046951[/TD]
[TD="align: right"]26-03-19[/TD]
[TD="align: right"]172026.97[/TD]
[TD="align: right"]27[/TD]
[TD] [/TD]
[TD="align: right"]1720.27[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Monday, April 22, 2019[/TD]
[TD]HR0120046937[/TD]
[TD="align: right"]26-03-19[/TD]
[TD="align: right"]43546.66[/TD]
[TD="align: right"]27[/TD]
[TD] [/TD]
[TD="align: right"]435.47[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Monday, April 22, 2019[/TD]
[TD]HR0120047509[/TD]
[TD="align: right"]28-03-19[/TD]
[TD="align: right"]91219.06[/TD]
[TD="align: right"]25[/TD]
[TD] [/TD]
[TD="align: right"]912.19[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Monday, April 22, 2019[/TD]
[TD]HR0120048916[/TD]
[TD="align: right"]06-04-19 [/TD]
[TD="align: right"]15484.45[/TD]
[TD="align: right"]16[/TD]
[TD] [/TD]
[TD="align: right"]154.84[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[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] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD="align: right"]115000[/TD]
[TD="align: right"]1400005086[/TD]
[TD]DOORS TECHNOLOGIES[/TD]
[TD="align: right"]100093753[/TD]
[TD]CH-414778[/TD]
[TD="align: right"]Friday, April 12, 2019[/TD]
[TD]HR0120040544[/TD]
[TD="align: right"]24-02-19[/TD]
[TD="align: right"]33537.93[/TD]
[TD="align: right"]47[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]401.65[/TD]
[TD="align: right"]401.65[/TD]
[TD="align: right"]775[/TD]
[TD="align: right"]240.99[/TD]
[TD="align: right"]160.66[/TD]
[TD] [/TD]
[TD="align: right"]2799895172[/TD]
[TD="align: right"]4199785258[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Friday, April 12, 2019[/TD]
[TD]HR0120040545[/TD]
[TD="align: right"]24-02-19[/TD]
[TD="align: right"]15341.54[/TD]
[TD="align: right"]47[/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] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Friday, April 12, 2019[/TD]
[TD]HR0120041573[/TD]
[TD="align: right"]27-02-19[/TD]
[TD="align: right"]25955.1[/TD]
[TD="align: right"]44[/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] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Friday, April 12, 2019[/TD]
[TD]HR0120045061[/TD]
[TD="align: right"]15-03-19[/TD]
[TD="align: right"]11284.1[/TD]
[TD="align: right"]28[/TD]
[TD] [/TD]
[TD="align: right"]112.84[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Friday, April 12, 2019[/TD]
[TD]HR0120045245[/TD]
[TD="align: right"]15-03-19[/TD]
[TD="align: right"]28881.33[/TD]
[TD="align: right"]28[/TD]
[TD] [/TD]
[TD="align: right"]288.81[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[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] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD="align: right"]821000[/TD]
[TD="align: right"]1400005582[/TD]
[TD]DOORS TECHNOLOGIES[/TD]
[TD="align: right"]100093753[/TD]
[TD]CH-414777[/TD]
[TD="align: right"]Tuesday, April 16, 2019[/TD]
[TD]HR0120045245[/TD]
[TD="align: right"]15-03-19[/TD]
[TD="align: right"]3562.53[/TD]
[TD="align: right"]32[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]7462.49[/TD]
[TD="align: right"]7462.49[/TD]
[TD="align: right"]775[/TD]
[TD="align: right"]4477.49[/TD]
[TD="align: right"]2985.00[/TD]
[TD] [/TD]
[TD="align: right"]2799190164[/TD]
[TD="align: right"]4198374746[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Tuesday, April 16, 2019[/TD]
[TD]HR0120045065[/TD]
[TD="align: right"]15-03-19[/TD]
[TD="align: right"]15941.22[/TD]
[TD="align: right"]32[/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] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Tuesday, April 16, 2019[/TD]
[TD]HR0120045066[/TD]
[TD="align: right"]15-03-19[/TD]
[TD="align: right"]4933.34[/TD]
[TD="align: right"]32[/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] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Tuesday, April 16, 2019[/TD]
[TD]HR0120045062[/TD]
[TD="align: right"]15-03-19[/TD]
[TD="align: right"]6314.12[/TD]
[TD="align: right"]32[/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] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Tuesday, April 16, 2019[/TD]
[TD]HR0120045308[/TD]
[TD="align: right"]16-03-19[/TD]
[TD="align: right"]43999.66[/TD]
[TD="align: right"]31[/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] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Tuesday, April 16, 2019[/TD]
[TD]HR0120045631[/TD]
[TD="align: right"]19-03-19[/TD]
[TD="align: right"]144307.86[/TD]
[TD="align: right"]28[/TD]
[TD] [/TD]
[TD="align: right"]1443.08[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Tuesday, April 16, 2019[/TD]
[TD]HR0120045632[/TD]
[TD="align: right"]19-03-19[/TD]
[TD="align: right"]13318.62[/TD]
[TD="align: right"]28[/TD]
[TD] [/TD]
[TD="align: right"]133.19[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Tuesday, April 16, 2019[/TD]
[TD]HR0120045635[/TD]
[TD="align: right"]19-03-19[/TD]
[TD="align: right"]393110.96[/TD]
[TD="align: right"]28[/TD]
[TD] [/TD]
[TD="align: right"]3931.11[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Tuesday, April 16, 2019[/TD]
[TD]HR0120045642[/TD]
[TD="align: right"]19-03-19[/TD]
[TD="align: right"]19733.38[/TD]
[TD="align: right"]28[/TD]
[TD] [/TD]
[TD="align: right"]197.33[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Tuesday, April 16, 2019[/TD]
[TD]HR0120045645[/TD]
[TD="align: right"]19-03-19[/TD]
[TD="align: right"]34214.38[/TD]
[TD="align: right"]28[/TD]
[TD] [/TD]
[TD="align: right"]342.14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Tuesday, April 16, 2019[/TD]
[TD]HR0120045646[/TD]
[TD="align: right"]19-03-19[/TD]
[TD="align: right"]141563.93[/TD]
[TD="align: right"]28[/TD]
[TD] [/TD]
[TD="align: right"]1415.64[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[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] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD="align: right"]272000[/TD]
[TD="align: right"]1400006410[/TD]
[TD]DOORS TECHNOLOGIES[/TD]
[TD="align: right"]100093753[/TD]
[TD]CH-414746[/TD]
[TD="align: right"]Tuesday, April 23, 2019[/TD]
[TD]HR0120046889[/TD]
[TD="align: right"]26-03-19[/TD]
[TD="align: right"]56946.32[/TD]
[TD="align: right"]28[/TD]
[TD] [/TD]
[TD="align: right"]569.46[/TD]
[TD] [/TD]
[TD="align: right"]2720.00[/TD]
[TD="align: right"]2720.00[/TD]
[TD="align: right"]775[/TD]
[TD="align: right"]1632.00[/TD]
[TD="align: right"]1088.00[/TD]
[TD] [/TD]
[TD="align: right"]2799740820[/TD]
[TD="align: right"]4199475230[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]Tuesday, April 23, 2019[/TD]
[TD]HR0120046891[/TD]
[TD="align: right"]26-03-19[/TD]
[TD="align: right"]33252.19[/TD]
[TD="align: right"]28[/TD]
[TD] [/TD]
[TD="align: right"]332.52[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
Above data I need to send it for different respective customers from this file directly
Can you please help into this which will be more helpful me.
Thanks and Regards,
R Preethi