Reminder Emails

Hello!

I have created an application to track employees leaving the company.  I currently have a reminder email being sent out 3 days before the employee's last day at the company.  The problem is sometimes the when the entry into the QB table is completed, it's already less than 3 days away, which won't trigger the reminder email.  

Is there a way to set up a reminder email that will capture those that were entered with only 2, 1, or 0 days remaining, without sending multiple emails for the same entry? 

I had thought about creating 4 different reminder emails to capture 3, 2, 1, and 0 days away, but I don't want to end up having 4 emails regarding the same employee.  The only other thing I can think of is if I do a report instead, but again I'd have to send that out daily to capture any possible date an employee is leaving the company.

Thank you!

------------------------------
V W
------------------------------