open excel with macro via outlook and pass on a parameter to the macro

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!
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
bump! my last resort is to send an excel attachment with the e-mail where if the person opens the workbook the workbook will have the task# in the attachment and macro will run on workbook open event, but I am hoping for a better solution. Thank you.
 
Upvote 0

Forum statistics

Threads
1,223,908
Messages
6,175,306
Members
452,633
Latest member
DougMo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top