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? |
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? |
All times are GMT +1. The time now is 05:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com