Create Hyperlink in Excel to open Task imported from Outlook

[robfoster2000]

Hi All.

I have some code to import all non-completed tasks from Outlook into a spreadsheet. My plan is to then put these into some kind of Eisenhower matrix to allow better organising of important vs urgent tasks etc.
I want each task to be a hyperlink which will then open the task in Outlook. I have read that this is possible by using the GUID of the Task object and the simply creating a hyperlink with "Outlook:[GUID]".
However, when looping through the items in the task list, the objects do not have a GUID reference as they are TaskItem objects and not Task objects.
According to Microsoft references, the Task object has a property "GUID", but the TaskItem object does not. Hence I can't create the hyperlink to directly open the task. The TaskItem does have a "Display" method, but I don't want to have to write additional code to find the task and call this when it is clicked on.

I retrieve the task items with the following:

Set olNS = olApp.GetNamespace("MAPI")
Set myTaskItems = olNS.GetDefaultFolder(olFolderTasks).Items

Any help to find a way to programatically add a hyperlink which will open the task in outlook would be much appreciated!

Cheers all!
Rob.

 

[Sandervd]

Hello,

I'm trying to do the same thing, did you ever find a solution for this?

Kr,

Sander