Email based on conditions

Important Notice

Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

  • The current spreadsheet looks for the Total to be greater than 3 and send an email to that specific individual and then marks the individual as notified in order not to notify them again if someone else hits 4 or more. I would like to adjust the code to send out the current macro email to anyone that has 4 or 5 in the total column and send a separate email when the individual hits 6 or above. I think I can make a separate email macro with ease by just copying the current macro and changing the name and the body of the email. But I am stumped with the code.

  • I’ll be honest I’m not really sure what that is or how to go about that. Any help you could provide would be greatly appreciated!

  • Something like this

  • Pleased to help.

    Post back if you need further help.

    Visit my web site,, for more examples and some helpful articles.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!