Send Email from Excel - but only to people in range

[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

 

[Tom Ogilvy]

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

Dick Kusileka's site
http://www.dicks-clicks.com


You should be able to find most of what you need.

 

[Guest]

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

 

[Steve]

http://www.rondebruin.nl/sendmail.htm#message
Perfect Tom...much appreciated

thanks
steve