Results 1 to 4 of 4

Link to Outlook Email from excel

This is a discussion on Link to Outlook Email from excel within the Excel Questions forums, part of the Question Forums category; Hi friends- I would like to drag a message from Outlook into Excel and have it create a link to ...

  1. #1
    New Member
    Join Date
    Jan 2012
    Posts
    2

    Default Link to Outlook Email from excel

    Hi friends-

    I would like to drag a message from Outlook into Excel and have it create a link to that message. Currently, it only creates a text entry with information about the email (From, To, Subject...). Is there a simple and quick way to create an actual Link to the email?

    I have been able to attach the email to a task, which creates a link to the email in the task, and then pull that over, but that's a more cumbersome process.

    (Is there a VBA code that can look at the selected mail item in outlook, for example, and then create a link to it? I'm just not smart enough in excel for this.)

    Appreciate any help! (I'm currently running Outlook and Excel 2010 on Windows 7).

  2. #2
    Board Regular
    Join Date
    Dec 2005
    Location
    Basingstoke (UK)
    Posts
    2,012

    Default Re: Link to Outlook Email from excel

    Hello and welcome to The Board.
    Are yoiu using VBA to do what you described?
    I would save (save as message) the email in a folder on disk using a unique name (perhaps including date & time etc.) and then putting that name as a hyperlink in the cell in Excel.
    Never give way to anger - otherwise in one day you could burn up the wood that you collected in many bitter weeks.

  3. #3
    New Member
    Join Date
    Jan 2012
    Posts
    2

    Default Re: Link to Outlook Email from excel

    Thanks Derek-
    I am trying to create a one-step process by which I drag an email from outlook into my excel spreadsheet and it creates a link in excel back to the outlook email. Currently, when one drags an email into a worksheet, it creates a little table showing a few of the email's outlook fields (from, subject, and date/time received), but does not create a link to the email.

    In my research it looks like I may be able to do this by identifying the Globally Unique Identifier of the email (GUID), but I don't know how to tell excel to do this.

  4. #4
    Board Regular
    Join Date
    Dec 2005
    Location
    Basingstoke (UK)
    Posts
    2,012

    Default Re: Link to Outlook Email from excel

    I manipulate Outlook tasks and emails quite a bit using Office (VBA) automation but have never considered using GUIDs.
    A quick investigation seems to confirm my initial concern - that the GUID will change if the email is later moved, making any link useless.
    Have a look at the 'gotcha' in the first answer at:
    http://superuser.com/questions/71786...age-in-outlook
    You may also be interested in:
    http://stackoverflow.com/questions/8...-a-email-reply
    Never give way to anger - otherwise in one day you could burn up the wood that you collected in many bitter weeks.

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com