Need Help with Excel email reminder

First of all allow me to apologize for the inconvenience. I have been trying to find the solution to my questions for weeks now through google but till now to no avail.

I have managed to create a notification system that can send the email reminder by itself when it's open and close by itself after a period of time from google-ing. However now, I'm facing some difficulty to further personalize this system
as below:-


1. Send the email right after the list is updated (not based on dates like in my file.Struggling with it to register today's date for today's list and tomorrows date for tomorrow's list). So email will be sent immediately when the first time the account number is park into the file. ( Everyday I would have to update the list of customers. Keep on adding the list every day in the same file )


2. Auto resend email reminder again when the account number appears 5 times in a row ( 5 days consecutively)
( the idea is to give the customer some time to make the payment before resending the reminder again after 5 working days if it still appear in the list ). If less then 5 days consecutively the VBA won't send the reminder.


3. Counting the 5 days consecutively only during workdays


4. However, the VBA will Resend the email again after more than 10 days gap. if the account number appears again after 10 working days then the process will loop starting from number 2 all over again. Meaning that after 10 days if the Account number appears again it will resend the email and count again up to 5 working days before again resending.


Would it be possible to create a VBA code that could count the duplicate entry of account number and sync with the date, that could satisfy the above?