Hi guys, I need help with designing a task notification system in Excel.
*Some background:* I do project management in Excel and I've automated the entire process with VBA to great extent. The only remaining problem is the task notification system. When I assign a project task to a specific user email notification is required. Currently I'm using an external system which means additional manual work. (and Outlook doesn't work because it doesn't support chain-like ordered mails) *Desired result:* In my project file I'd like to trigger the task assignment to one (or all) project memeber(s) which would in turn copy task details to their specific spreadsheets for workload and task monitoring. In their spreadsheets there needs to be a status column (in my project file as well, of course) and when they change the status of the task it also changes in other respective places and if possible some sort of notification appears (in form of msg box or something). *Challenges:* 1. The two files I've mentioned are behind restricted access and can only be viewed by a user with proper access rights. Users can't access the project file.I guess to bypass this I need to setup a third file to be used for communication. 2. In most cases there are several users doing tasks in a specific workflow. So the notification system hast to handle multiple assignments in desired order. * My questions to you:* 1. Is this feasible in Excel or has anyone tried to do something like this? 2. Are my assumtions correct or should I try something different? In Excel that is. I know some might say I need to transfer this to proper application as it is too complex, but I ran out of time for 2014:( Thank you for your help. Any ideas are most welcome. Kind regards, seba -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
