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

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
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,236
Messages
6,170,912
Members
452,366
Latest member
TePunaBloke

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