Solved

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

Posted on 2007-03-19
7
748 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
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Find out what you should include to make the best professional email signature for your organization.
Finding original email is quite difficult due to their duplicates. From this article, you will come to know why multiple duplicates of same emails appear and how to delete duplicate emails from Outlook securely and instantly while vital emails remai…
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…
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…

730 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