Hi,

I have a task I need to complete on a daily basis and can use your
help.

I am going to have a report with a list of users names in one column.
The length of the column, names and frequenct of names is variable
every day.
I need to email each user their part of the report.

Essentially what I need to do is
Sort the chart (which I can do)
Copy the sheet for each name in the column
Name the sheet the persons name (if it helps)
Delete all other rows with other peoples names
Send the sheet to that person

Any help you can offer is appreciated as always

Here is a link that can help:
http://www.rondebruin.nl/sendmail.htm

Mike F
"gmunro" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi,
>
> I have a task I need to complete on a daily basis and can use your
> help.
>
> I am going to have a report with a list of users names in one column.
> The length of the column, names and frequenct of names is variable
> every day.
> I need to email each user their part of the report.
>
> Essentially what I need to do is
> Sort the chart (which I can do)
> Copy the sheet for each name in the column
> Name the sheet the persons name (if it helps)
> Delete all other rows with other peoples names
> Send the sheet to that person
>
> Any help you can offer is appreciated as always
>