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 ~
At 00:00 hours, you search through that list and see if any last_completed_timestamp values are > 24 hours. If not, skip over it. If yes, you construct an email message with the task name & last completed time.
Now the tricky part is forcing a human to click a button or run an app that marks he last_completed_timestamp field for every task name as it is accomplished. A task being completed is subjective and there are way too many corner cases to think of automating such things. So you're going to have to create some checklist code.
Outlook does have a todo list, and one can write code to query and modify the list, and even script creating emails, but this would probably require a few hours worth of contract programming for somebody to crank it out for you.