VB Maro for Excel

[SPLRSPLR]

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)

Code	Amt	DZ	Customer Name	WPP CODE	UTR NO/CHQ NO	Payment Date	Invoices	Invoice date	INVOICE VALUE	Days	CD -1.5%	CD 1%	Total CD -1.5%	Total CD -1%	CN Amount	New Agg.N.	DA- 9042	PC- 9044	Code	Amt	DZ
	1184000	1400004124	Indian Watch Distributors	100088186	CH-928676	Thursday, March 28, 2019	UP0520003684	07-03-19	121367.43	21		1213.67	15635.38	1416.41	17051.79	775	10231.08	6820.72		2798824248	4197644372
						Thursday, March 28, 2019	UP0520003664	07-03-19	20273.62	21		202.74
						Thursday, March 28, 2019	UP0520003726	13-03-19	44001.68	15	660.03
						Thursday, March 28, 2019	UP0520003729	13-03-19	9733.16	15	146.00
						Thursday, March 28, 2019	UP0520003727	13-03-19	138463.9	15	2076.96
						Thursday, March 28, 2019	UP0520003728	13-03-19	236072.71	15	3541.09
						Thursday, March 28, 2019	UP0520003734	13-03-19	18315.96	15	274.74
						Thursday, March 28, 2019	UP0520003730	13-03-19	7409.19	15	111.14
						Thursday, March 28, 2019	UP0520003731	13-03-19	36263.76	15	543.96
						Thursday, March 28, 2019	UP0520003732	13-03-19	4939.46	15	74.09
						Thursday, March 28, 2019	UP0520003733	13-03-19	221976.88	15	3329.65
						Thursday, March 28, 2019	UP0520003735	13-03-19	221976.88	15	3329.65
						Thursday, March 28, 2019	UP0520003736	13-03-19	50736.7	15	761.05
						Thursday, March 28, 2019	UP0520003737	13-03-19	51739.12	15	776.09
						Thursday, March 28, 2019	UP0520003891	23-03-19	729.55	5	10.94
	382000	1400005676	Balaji Electronics	100088172	CH-000781	Monday, April 22, 2019	HR0120046941	26-03-19	59722.86	27		597.23		3820.00	3820.00	775	2292.00	1528.00		2799629352	4199253028
						Monday, April 22, 2019	HR0120046951	26-03-19	172026.97	27		1720.27
						Monday, April 22, 2019	HR0120046937	26-03-19	43546.66	27		435.47
						Monday, April 22, 2019	HR0120047509	28-03-19	91219.06	25		912.19
						Monday, April 22, 2019	HR0120048916	06-04-19	15484.45	16		154.84
	115000	1400005086	DOORS TECHNOLOGIES	100093753	CH-414778	Friday, April 12, 2019	HR0120040544	24-02-19	33537.93	47				401.65	401.65	775	240.99	160.66		2799895172	4199785258
						Friday, April 12, 2019	HR0120040545	24-02-19	15341.54	47
						Friday, April 12, 2019	HR0120041573	27-02-19	25955.1	44
						Friday, April 12, 2019	HR0120045061	15-03-19	11284.1	28		112.84
						Friday, April 12, 2019	HR0120045245	15-03-19	28881.33	28		288.81
	821000	1400005582	DOORS TECHNOLOGIES	100093753	CH-414777	Tuesday, April 16, 2019	HR0120045245	15-03-19	3562.53	32				7462.49	7462.49	775	4477.49	2985.00		2799190164	4198374746
						Tuesday, April 16, 2019	HR0120045065	15-03-19	15941.22	32
						Tuesday, April 16, 2019	HR0120045066	15-03-19	4933.34	32
						Tuesday, April 16, 2019	HR0120045062	15-03-19	6314.12	32
						Tuesday, April 16, 2019	HR0120045308	16-03-19	43999.66	31
						Tuesday, April 16, 2019	HR0120045631	19-03-19	144307.86	28		1443.08
						Tuesday, April 16, 2019	HR0120045632	19-03-19	13318.62	28		133.19
						Tuesday, April 16, 2019	HR0120045635	19-03-19	393110.96	28		3931.11
						Tuesday, April 16, 2019	HR0120045642	19-03-19	19733.38	28		197.33
						Tuesday, April 16, 2019	HR0120045645	19-03-19	34214.38	28		342.14
						Tuesday, April 16, 2019	HR0120045646	19-03-19	141563.93	28		1415.64
	272000	1400006410	DOORS TECHNOLOGIES	100093753	CH-414746	Tuesday, April 23, 2019	HR0120046889	26-03-19	56946.32	28		569.46		2720.00	2720.00	775	1632.00	1088.00		2799740820	4199475230
						Tuesday, April 23, 2019	HR0120046891	26-03-19	33252.19	28		332.52

<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>
</tbody>

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

 

[Paul Ked]

Ron de Bruin has a great website for emails from excel here: https://www.rondebruin.nl/win/s1/outlook/mail.htm

 

[Logit]

.
Preethi :

How many different customers will you be emailing each time ? Your example shows three ... will there usually be more ? How many ?

If there are usually more than say 12 different customers ... we need to determine how to include each customers' email address. Presently
the email addresses are not shown for each customer. If there will only be 12 or less each time you could easily enter the email address
manually. If you will be sending more than 12 emails ... being able to automate entering their addresses should be required.

 

[SPLRSPLR]

Yes

.
Preethi :

How many different customers will you be emailing each time ? Your example shows three ... will there usually be more ? How many ?

If there are usually more than say 12 different customers ... we need to determine how to include each customers' email address. Presently
the email addresses are not shown for each customer. If there will only be 12 or less each time you could easily enter the email address
manually. If you will be sending more than 12 emails ... being able to automate entering their addresses should be required.

 

[Paul Ked]

No rush for this then