So as of right now the spreadsheet should populate an email if the number of occurrences reaches 4 and above and then it returns a "notified" label. The notified label sets the code so that if another person reaches 4 or above then those already notified will not get another email. I would also like to set it up to send another email to those that reach 6 and have already been notified. I can make the macro for the second email it is the code that I cannot figure out.
Please Login or Register to view this content.
Last edited by AlphaFrog; 12-25-2021 at 01:44 PM.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Originally Posted by AlphaFrog
Please Login or Register to view this content.
I am getting a Object Variable or With Block Variable Not Set message
It works for me without error.
On the error dialog, click the Debug button. What line is highlighted?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks