Send an email when task is NOT completed.
Posted on 2014-01-14
Is there a way that I can have an automatic email sent to a distribution list if a person does not complete a task by the end of the day? This person is a single-point of failure for updates so if something happens and he does not complete the task we want to be aware of it. My thought was to have something in place where he would go to mark the task as complete. If that does not happen then an email is sent to others so we know that the data has not been updated.
This would occur on a workday basis. I looked at VBA, Outlook and Exchange, but wasn't sure how to proceed. In Outlook, I could do the opposite and have it send an email every time it is completed, but that would flood the inbox of the users on the dist list.
I am not cemented to doing this from Outlook. It could be Access, SharePoint, etc. If there is another route, I am willing to give it a try.
Thanks for any pointers.
~ M ~