Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sending Emails according to sheet name
On Sheet2 I have a table. There is a list of Names in
Range B3:B52, however there may be only 12, 20, 35, or however many names in that range up to 50 names. In Range C3:C52 there are email address. These email address are corresponding to the names. Starting with Sheet4(there can be up to 53 sheets including Sheet4), the sheets are going to be named with names that match names located in Range B3:B52 on Sheet2. I need a code that will look at each sheet name starting with Sheet4 and then look at Range B3:B52 on Sheet2 and when it finds the name match, it will look at the corresponding email address and send that sheet to that email address using Outloook 2000. It dont matter how the sheet is emailed. Thanks I was previously refered to dicks-clicks but I did not quite understand. Can anyone please help? Thanks again. Todd Huttenstine |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sending Emails according to sheet name
Try ron's site instead. I think it will have code closer to what you want:
You might to invest a little time matching it to your specific range. Ron de Bruin's site http://www.rondebruin.nl/sendmail.htm http://www.rondebruin.nl/index.html an Article by Ron on MSDN: http://msdn.microsoft.com/library/en...odc_xlmail.asp -- Regards, Tom Ogilvy Todd Huttenstine wrote in message ... On Sheet2 I have a table. There is a list of Names in Range B3:B52, however there may be only 12, 20, 35, or however many names in that range up to 50 names. In Range C3:C52 there are email address. These email address are corresponding to the names. Starting with Sheet4(there can be up to 53 sheets including Sheet4), the sheets are going to be named with names that match names located in Range B3:B52 on Sheet2. I need a code that will look at each sheet name starting with Sheet4 and then look at Range B3:B52 on Sheet2 and when it finds the name match, it will look at the corresponding email address and send that sheet to that email address using Outloook 2000. It dont matter how the sheet is emailed. Thanks I was previously refered to dicks-clicks but I did not quite understand. Can anyone please help? Thanks again. Todd Huttenstine |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sending emails from worksheet | Excel Discussion (Misc queries) | |||
Help Sending Emails From Excel | Excel Discussion (Misc queries) | |||
Sending Emails according to sheet name | Excel Programming | |||
Sending emails from Excel | Excel Programming |