Good morning,
I am trying to send an auto e-mail only when cell e9 + Yes, no e-mail if e9 - no. I have tried ActiveWorkbook.SendMail Recipients:="[email protected]", Subject:="Form No.1" but this sends e-mail no matter what e9 has in it. I have tried if e9 =Yes, but again this does not work. Any suggestions please.

many thanks

Robbosan