help with VBA conditional notification emails

What is this clock for? This clock only shows the time, it is not used for anything. The change in P28 is not used to alarm that it is 11:00, 12:00 etc. because this change does not trigger Worksheet_Change

The time formula is so excel could match the current time with the time in the shift change schedule so that my lookup formula would work. using the now() formula excel was reading them as two different things, without that in cell P28 the formula in R26 does not work.

Who is telling you to change the UpdateClock sub? I wrote that you need to correct the send_mail sub because I do not know what you are sending and to which address. But at the end of the send_mail sub there must be UpdateClock

no one told me to use it. I was using it so that P28 would update on it's own (as the formula in that cell keeps the current time but ONLY when there has been a change in the worksheet) and I started using that BEFORE I started this thread for help with the email notifications. I did try the send_mail w/ update clock that you gave me but the email only sent after I hit run and after that it kept telling me that the macro was unavailable or nothing happened at all.

Originally Posted by Coltara

The time formula is so excel could match the current time with the time in the shift change schedule so that my lookup formula would work. using the now() formula excel was reading them as two different things, without that in cell P28 the formula in R26 does not work.
no one told me to use it. I was using it so that P28 would update on it's own (as the formula in that cell keeps the current time but ONLY when there has been a change in the worksheet) and I started using that BEFORE I started this thread for help with the email notifications. I did try the send_mail w/ update clock that you gave me but the email only sent after I hit run and after that it kept telling me that the macro was unavailable or nothing happened at all.

I wish you good luck.