Solved

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

Posted on 2007-03-19
7
736 Views
Last Modified: 2010-08-05
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.)
0
Comment
Question by:Jignesh Thar
  • 4
  • 3
7 Comments
 
LVL 76

Accepted Solution

by:
David Lee earned 500 total points
Comment Utility
See this page for details on all the different hypelinks to Outlook items:

http://www.slipstick.com/outlook/links.htm
0
 
LVL 7

Author Comment

by:Jignesh Thar
Comment Utility
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
 
LVL 76

Assisted Solution

by:David Lee
David Lee earned 500 total points
Comment Utility
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
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

 
LVL 7

Author Comment

by:Jignesh Thar
Comment Utility
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
 
LVL 76

Assisted Solution

by:David Lee
David Lee earned 500 total points
Comment Utility
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
 
LVL 7

Author Comment

by:Jignesh Thar
Comment Utility
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
 
LVL 76

Expert Comment

by:David Lee
Comment Utility
>  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

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Resolve DNS query failed errors for Exchange
Follow this checklist to learn more about the 15 things you should never include in an email signature from personal quotes, animated gifs and out-of-date marketing content.
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now