Email worksheet from named list on another worksheet
 

I have 60 worksheets. Each worksheet is a name of a person. I also have a
worksheet named source; it has the name in column A and email address in
column B. I would like to write a program to email each worksheet. It would
read the name of the worksheet, lookup the name, get the email address and
mail it. If needed I could keep the source stuff in another workbook, that
may be easier. Any idea's?

Email worksheet from named list on another worksheet
 

Hi Rookie_User

Look at my mail templates
http://www.rondebruin.nl/mail/templates.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl



"Rookie_User" wrote in message
...
I have 60 worksheets. Each worksheet is a name of a person. I also have a
worksheet named source; it has the name in column A and email address in
column B. I would like to write a program to email each worksheet. It
would
read the name of the worksheet, lookup the name, get the email address and
mail it. If needed I could keep the source stuff in another workbook,
that
may be easier. Any idea's?