What i'm trying to do is check all cells in a column for a value and send an email based on the value.

Compare again 3 different values.

So I based on the value I want to sent a mail to some departments(so diferent emailsaddress).

As you can see in my trial and error this doesn't work at the time.

So some help will be much appreciated.

Kind regards