How to create hyperlink/bookmark to email messages in outlook?

How to create hyperlink/bookmark to email messages in outlook? (e.g.:- I need to store links to email messages in excel so that I can click on them and open the email from excel.)
LVL 7
Jignesh TharSenior ManagerAsked:
Who is Participating?
 
David LeeCommented:
See this page for details on all the different hypelinks to Outlook items:

http://www.slipstick.com/outlook/links.htm
0
 
Jignesh TharSenior ManagerAuthor Commented:
BlueDevilFan- http://www.slipstick.com/outlook/links.htm has many tricks around hyperlinks but in I could not find one to have shortcut/hyperlink in excel so that I click and it would open specific item in outlook. How do I create that hyperlink to email message? (I am running Outlook 2003.)
0
 
David LeeCommented:
A hyperlink in Excel is no different than a hyperlink anywhere else.  The fifth example

Item in a folder (note the tilde ~ in front of the specific item name)  <Outlook:Contacts/~Anglo-American School>

is the one you want.  The only difference being that you may not want an item out of your Contacts folder.  Simply substitute the folder you do want in place of Contacts.  For example, let's say I have a message in my Inbox title "Stock Report".  The link to it would be

    outlook:inbox/~Stock Report
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

 
Jignesh TharSenior ManagerAuthor Commented:
It works!! Still it is not exactly what I want. This fails when I have multiple items with same subject in my Inbox and I have multiple local Inbox(Multiple local PST files.) This link just opens first item found!!

I heard there is someting called ItemId, which is unique id for outlook item and I can write "outlook:ItemId" to open that item but there does not seem to be any way to get this ItemId without macro/program :-(
0
 
David LeeCommented:
Yes, you can use EntryID (what you referred to as ItemId) in place of the subject.  But, as you've already discovered, that piece of information isn't available without some code.  If the issue is multiple PST files with the same name, then you might be able to solve the problem by renaming them to unique names.  As an alternative, I can provide code that will create a link using the EntryID, and copy it to the clipboard.
0
 
Jignesh TharSenior ManagerAuthor Commented:
BlueDevilFan - Even if I rename PSTs to unique names, do you think I can have unique subject within same PST!!
I have got the code to get ItemId. I have continued with this work around at this point. Thanks a lot for helping me
0
 
David LeeCommented:
>  Even if I rename PSTs to unique names, do you think I can have unique subject within same PST!!
No, I guess that'd be a problem.

> Thanks a lot for helping me
You're welcome.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.