Send Email from Excel - but only to people in range

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

hi all,

am new to coding, any help appreciated. have tried google etc to no avail.

List of names in A1:A100
List of either Yes or No in B1:B100 respectively

I would like to send an email to everyone in Range A1:A100 that has a 'No'
next to their name in column B

eg Create a text string of names that meet the 'No' criteria of column B and
pass it to Outlook.

Any help/code greatly appreciated
tia

Steve
 
Can you do a sort by column B? Then eliminate the No's and send the rest to Outlook

I'm a rookie so perhaps I don't know what I'm talking about
 
Back
Top