Link to open an Outlook object from an Excel spreadsheet

[bryan.powell2]

Hello,

I generating a report from task items hosted on an exchange server
using Excel VBA. I would like to be able to have what appears to the
user as a hyper link on the spreadsheet that, when clicked, would open
the task item. Is this possible?

Thanks in advance,
Bryan

 

[Sue Mosher [MVP-Outlook]]

You could use the outlook:// protocol. See http://www.slipstick.com/outlook/links.htm

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/article.aspx?id=54

 

[bryan.powell2]

You could use the outlook:// protocol. Seehttp://www.slipstick.com/outlook/links.htm

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/article.aspx?id=54

That's perfect. Thanks.