VBA email from outlook - Excel pivot

[Miratshah]

Hi,

I went through http://www.rondebruin.nl/sendmail.htm however it did not help since I am not much familiar with writing VBA code.

Can anyone help me with VBA to send email based on values in Excel pivot? I have embedded a sample excel file below:-

I need separate email where column A value changes which should have body of email from column B to G. Emails in To and CC can be picked up from column H and I respectively. Rest of the body like "Hi, please find below details" can be static for all emails.

	A	B	C	D	E	F	G	H	I
1	Join	Party	AffiliateParty	Code	Invoice Date	Invoice No.	Total	To	CC
2	IN1000AU1000	IN1000	AU1000	Hello	09/01/2019	856166785	-2,10,696	123@gmail.com,456@gmail.com	789@gmail.com
3	IN1000AU1000	IN1000	AU1000	Hello Total			-2,10,696	123@gmail.com,456@gmail.com	789@gmail.com
4	IN1000AU2000	IN1000	AU2000	Hello	09/01/2019	856166786	-7,37,437	123@gmail.com,456@gmail.com	789@gmail.com
5	IN1000AU2000	IN1000	AU2000	Hello Total			-7,37,437	123@gmail.com,456@gmail.com	789@gmail.com
6	IN1000CH1000	IN1000	CH1000	Hello	18/01/2019	856166913	-1,07,928	123@gmail.com,456@gmail.com	789@gmail.com
7	IN1000CH1000	IN1000	CH1000	Hello Total			-1,07,928	123@gmail.com,456@gmail.com	789@gmail.com
8	IN1000GB1000	IN1000	GB1000	Hello	22/01/2019	856166937	-4,32,250	123@gmail.com,456@gmail.com	789@gmail.com
9	IN1000GB1000	IN1000	GB1000	Hello	19/02/2019	856167320	-1,64,273	123@gmail.com,456@gmail.com	789@gmail.com
10	IN1000GB1000	IN1000	GB1000	Hello Total			-5,96,522	123@gmail.com,456@gmail.com	789@gmail.com

<tbody>
</tbody>

Sheet1​

<tbody>
</tbody>