Solved

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

Posted on 2007-03-19
7
755 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

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

MS Outlook is a world-class email client application that is mainly used for e-communication globally.  In this article, we will discuss the basic idea about MS Outlook, its advanced features, and types of MS Outlook File formats.
Mailbox Overload?
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
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 …

696 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