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.
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.