Sending Emails according to sheet name

[Todd Huttenstine]

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

 

[Tom Ogilvy]

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-us/odc_xl2003_ta/html/odc_xlmail.asp