| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Email worksheet from a list of names and email
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.misc
|
|||
|
|||
|
Email worksheet from a list of names and email
Please post in one group
See answer in your other thread -- 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 | |||
| Drop-Down List Choice Affects Multiple Cells? | Excel Worksheet Functions | |||
| add email address to a list of names | Excel Discussion (Misc queries) | |||
| LOOP - Adddress List -to email | Excel Discussion (Misc queries) | |||
| Loop through email address list to send e-mails | Excel Discussion (Misc queries) | |||
| Using CONCATENATE function to create email addresses from a list | Excel Worksheet Functions | |||
Linear Mode
