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