Grouping data, save to a file and send via email HELP

Hi to everyone,

I’m writing because I would like to automate a process but I was not able to find anything similar on the internet.

I have an excel file with the following data:

R\C	A	B	C	D

1	qqq	www	aaa	aaa@b.com
2	sss	fff	aaa	aaa@b.com
3	rrr	kkk	aaa	aaa@b.com
4	ttt	jjj	bbb	bbb@c.com
5	zzz	hhh	bbb	bbb@c.com
6	mmm	vvv	ccc	ccc@d.com
7	...	...	...	...

What I need to do is create a sheet in which I copy the content of the file reported above, and executing a macro it:

1. groups data by column D (or C it is the same) (data are already ordered),
2. extracts each group and put it into an already existing file in a specific position,
3. saves the file with the name reported in column C,
4. and finally sends it via email to the column D address.

Example: extract rows from 1 to 3, open the file “test.xls”, copy the extracted content starting from cell A3, save the file as “test-aaa.xls” and send it via email (using outlook) to aaa@b.com with a defined subject and the standard text. Following do the same with rest of the data.

I’m using Office XP English version.

I know is not an easy thing, but I really don’t know from where I should start.
If you have any suggestion, ideas of you already done something similar please let me know.

Thank you in advance for your time and availability,

dk


EDIT:

Using the example: http://www.rondebruin.nl/copy5.htm I was able to create a new file for each unique name in column, which is great! I have a new sheet with unique names and path of relative file.. still missing the email part...