Solved

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

Posted on 2007-03-19
7
738 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
ID: 18751128
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
ID: 18754612
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
ID: 18754723
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
Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

 
LVL 7

Author Comment

by:Jignesh Thar
ID: 18758097
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
ID: 18761001
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
ID: 18761604
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
ID: 18762415
>  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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Outlook Archiving 8 34
exchange 19 41
Outlook and Hotmail mail blocking limits if any 14 47
Format Meeting Request through VBA 5 22
Following basic email etiquette rules will help you write a professional email and achieve a good, lasting impression with your contacts.
This article lists the top 5 free OST to PST Converter Tools. These tools save a lot of time for users when they want to convert OST to PST after their exchange server is no longer available or some other critical issue with exchange server or impor…
Many of my clients call in with monstrous Gmail overloading issues with Outlook. A quick tip is to turn off the All Mail and Important folders from synching. Here is a quick video I made to show you how to turn off these and other folders in Gmail s…
CodeTwo Sync for iCloud (http://www.codetwo.com/sync-for-icloud?sts=6554) automatically synchronizes your Outlook 2016, 2013, 2010 or 2007 folders with iCloud folders available via iCloud Control Panel. This lets you automatically sync them with…

867 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

18 Experts available now in Live!

Get 1:1 Help Now