What's the best way to track the progress of requests sent to our company's parts department? They get the requests via Outlook emails that are generated from an Excel workbook. I'd like my users to be able to click a button in that same workbook which would show all the requests that are in progress and who is handling each request. The "who" can be the "To:" address from the email that generated the request. I also need the recipients of the emails to be able to update the status of the requests"
Some things to point out
- All users do not have access. I can work with it since I'm friends with the IT department.
- I want all users to be able to see requests sent by other users and have the functionality to change the status of the request.
- All users have access to the network drive and database that is being used. There are no restrictions there.