I am looking to develop a short-term tracking solution centered around Public Folders in Microsoft Outlook. I want e-mails to act as triggers and an Excel spreadsheet to be created that can date/time stamp requests so that average processing time can be tracked. I am looking to increase visibility into the process, so the folders will act as "queues". Additionally, alerts will be sent out using Outlook when a group has a To-DO. I have an excel spreadsheet with more information.
The goal is to develop something relatively quickly (6-8) weeks.
I have a spreadsheet that can be sent for more details, but the kinds of thing i am looking for include:
--Home for the Workflow (Microsoft Outlook Public Folder)
--Home for the Components of the Workflo (sub folders underneath the public folder)
--A way to identify incoming mail and to forward it to the appropriate folder
--Display a pop-up alert that indicates you have a to-do
--Periodic checking of queues for any non-processed To-Dos
--Moving the workflow along should automatically clear the queue
--An excel spreadsheet that can track results such as date/time stamp
--Ability to output average time
--A required way to notify owner of process for any change in the queue
Ideally everything would be centered around Outlook and excel. But if someone has a better way of framing it, i am flexible.