How to send email through IBM Lotus Notes 8.5 using excel 2007

[gpansari]

Hi,

I have a worksheet, which I need to send to different areas of the business, where there are 2 businesses being handled by each area.
So for Area 1 the ranges A1:B6 and H1:H6 need to be send to the email id against Area1, i.e. cell B10 (Area1@xyz.com)

Mail subject: cell C10
Mail Body: Ranges A1:B6 and H1:H6
Mail to: cell B10
Mail CC: cell $B$16 (same for all mails)

Similiarly, for Area 2:
Mail subject: cell C11
Mail Body: Ranges A1:A6 and C1:C6 and J1:J6 (would be helpful if this can be sent as one table of 3 columns)
Mail to: cell B11
Mail CC: cell $B$16

Please help me with a macro for this (or recommend an available add in).

	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Division	Business 1	Business 1	Business 1	Business 1	Business 1	Business 1	Business 2	Business 2	Business 2	Business 2	Business 2	Business 2
2	Region	Area 1	Area 2	Area 3	Area 4	Area 5	Total	Area 1	Area 2	Area 3	Area 4	Area 5	Total
3		$	$	$	$	$	$	$	$	$	$	$	$	$
4	Month Budget	12	18	18	35	14	97	0.39	0.76	1.97	2.11	1.70	6.94
5	Spend	5	7	13	15	7	49	0.05	1.11	0.36	1.19	0.76	3.47
6	Total Sale Value	229	582	351	577	266	2,006	2.51	11.68	39.68	28.74	11.49	94.10
7
8	Mailing List
9	Area	email id	Mail Subject
10	Area 1	Area1@xyz.com	Sale update for the month - Area 1
11	Area 2	Area2@xyz.com	Sale update for the month - Area 2
12	Area 3	Area3@xyz.com	Sale update for the month - Area 3
13	Area 4	Area4@xyz.com	Sale update for the month - Area 4
14	Area 5	Area5@xyz.com	Sale update for the month - Area 5
15
16	CC:	Total@xyz.com

<colgroup><col><col><col><col><col span="4"><col><col><col span="4"><col></colgroup><tbody>
</tbody>