View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Todd Huttenstine[_2_] Todd Huttenstine[_2_] is offline
external usenet poster
 
Posts: 237
Default 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 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.

Can anyone please help?

Thank you.