Email based on conditions

  • 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

Participate now!

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