Send emails to group leaders about fund used by their members:

[JojoGurkha]

Greetings Everyone,

This is a sample worksheet, where there are group leaders, their email address and funds used by group members, I want to update each group leaders about stats of funds by group member each day via outlook.
We can have any number of group leader and any number of group member with a group. I have attached sample copy of worksheet and email that i want to send to group leaders.

I would be very much grateful if anyone can help me with this

Thankyou

SampleSheet.xlsx
	A	B	C	D
1	Group Leader	Email Address	Group Members	Amount
2	Group Leader 1	sample1@email.com	Member 1	500
3			Member 2	300
4			Member 3	250
5			Member 4	450
6			Member 5	650
7			Member 6	600
8			Member 7	523
9			Member 9	456
10			Total	3729
11	Group Leader 2	sample2@email.com	Member 1	500
12			Member 2	300
13			Member 3	250
14			Member 4	450
15			Member 5	650
16			Total	2150
17	Group Leader 3	sample3@email.com	Member 1	500
18			Member 2	300
19			Member 3	250
20			Member 4	450
21			Member 6	150
22			Member 7	200
23			Member 8	225
24			Member 9	650
25			Total	2725
Sheet1

Cell Formulas
Range	Formula
D10,D25	D10	=SUM(D2:D9)
D16	D16	=SUM(D11:D15)