| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I generate an email list from my worksheet? | Excel Discussion (Misc queries) | |||
| Automatically Name Tabs from List on Worksheet Named Team | Excel Discussion (Misc queries) | |||
| Email worksheet from a list of names and email | Excel Discussion (Misc queries) | |||
| Send an email to a list of emails in a worksheet | New Users to Excel | |||
| Using a data validation list to look up a defined named range in another worksheet | Charts and Charting in Excel | |||
Linear Mode
