crazydragon84
Board Regular
- Joined
- Feb 19, 2015
- Messages
- 195
Hi All,
I created a userform on excel to manage and track deliverable/tasks. Currently, tool assigns the task to a certain e-mail distribution but we wanted to take one step further and assign the tasks to an individual (after it gets assigned to the group). Easy enough, I can create a form that someone can go into and assign them to an individual, which will then spit out an e-mail to the individual stating that they have been assigned the task. On the e-mail that gets sent to the individuals, we want to add and "Acknowledgement of Receipt" function to make sure that the person acknowledges that they were assigned this task. Here is where it gets a little more complicated. We want to track who and when acknowledge this on the original excel that has the userform (instead of just using the receipt acknowledgement function on excel).
In order to achieve this, I thought about having a link in excel that would open a file and run a macro through workbook.open function, but I am not sure how I can pass the parameter to the macro to indicate which task they are acknowledging the receipt to.
To give an example, let's say there is task #237 , and #237 has subtasks A, B, and C. Subtasks A and B are assigned to Jon and Subtask C is assigned to Dan. Jon will receive an e-mail saying you've been assigned#237 A and #237 B. On that e-mail, I want a hyperlink that if jon clicks on, it would log on the initial excel that houses list of all tasks that Jon has acknowledged the receipt of the e-mail for task #237 A and 237B. Is this possible without having to go into everyone's outlook and putting in a vba code on their outlook?
I'm open to any other alternative, if there are better solutions. Thank you for your help in advance!
I created a userform on excel to manage and track deliverable/tasks. Currently, tool assigns the task to a certain e-mail distribution but we wanted to take one step further and assign the tasks to an individual (after it gets assigned to the group). Easy enough, I can create a form that someone can go into and assign them to an individual, which will then spit out an e-mail to the individual stating that they have been assigned the task. On the e-mail that gets sent to the individuals, we want to add and "Acknowledgement of Receipt" function to make sure that the person acknowledges that they were assigned this task. Here is where it gets a little more complicated. We want to track who and when acknowledge this on the original excel that has the userform (instead of just using the receipt acknowledgement function on excel).
In order to achieve this, I thought about having a link in excel that would open a file and run a macro through workbook.open function, but I am not sure how I can pass the parameter to the macro to indicate which task they are acknowledging the receipt to.
To give an example, let's say there is task #237 , and #237 has subtasks A, B, and C. Subtasks A and B are assigned to Jon and Subtask C is assigned to Dan. Jon will receive an e-mail saying you've been assigned#237 A and #237 B. On that e-mail, I want a hyperlink that if jon clicks on, it would log on the initial excel that houses list of all tasks that Jon has acknowledged the receipt of the e-mail for task #237 A and 237B. Is this possible without having to go into everyone's outlook and putting in a vba code on their outlook?
I'm open to any other alternative, if there are better solutions. Thank you for your help in advance!