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

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


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

--
Regards,
Tom Ogilvy



Steve wrote in message
...
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