Page 1 of 2 12 LastLast
Results 1 to 15 of 20
  1. #1
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Cape Town, South Africa, South Africa
    Posts
    399
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Email Message in Excel (Excel 2003)

    One of my users whats to put a "hyperlink" in her workbook that if she clicks on it is should take her to the email. Are there any functionality already built in to do this.

    TIA

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Email Message in Excel (Excel 2003)

    If Excel is set to convert internet and network paths to hyperlinks in the AutoFormat As You Type tab of Tools | AutoCorrect Options (see screenshot), an e-mail address such as bill@microsoft.com will automatically be converted to a hyperlink that will create a new message to the e-mail address.
    Attached Images Attached Images
    • File Type: png x.PNG (6.6 KB, 1 views)

  3. #3
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Cape Town, South Africa, South Africa
    Posts
    399
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Email Message in Excel (Excel 2003)

    Thanks Hans for that info. My problem is I want to put a referance in excel to a message I've received. If I then press/select the cell it should open Outlook and show this "old" message.

    TIA

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Email Message in Excel (Excel 2003)

    I don't think that is possible, but perhaps someone else will come up with a bright idea.

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Email Message in Excel (Excel 2003)

    Aha! I didn't know that, so thanks!

  6. #6
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Email Message in Excel (Excel 2003)

    Hi Mario,
    Yes you can, with certain limitations. To link to a message with subject 'Vista: The Saga Continues' in my Inbox, I would choose Insert-Hyperlink from the menu and then enter in the address field:
    <code><Outlook:Inbox/~Vista: The Saga Continues></code>

    exactly as it appears here. You have to include the <code><</code>
    and <code>></code>
    symbols and you precede the item subject with <code>~</code>

    If you have more than one item with the same subject, you will get the first one. You can get round this if you can get the EntryID by using:
    <code><Outlook: entryID></code>

    HTH
    Regards,
    Rory

    Microsoft MVP - Excel

  7. #7
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Email Message in Excel (Excel 2003)

    I should print this out and frame it for posterity then! <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    I suspect that with Exchange Server you can probably use some complicated LDAP syntax but I may be wrong.
    Regards,
    Rory

    Microsoft MVP - Excel

  8. #8
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Cape Town, South Africa, South Africa
    Posts
    399
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Email Message in Excel (Excel 2003)

    Great, Magic

    Thanks

  9. #9
    3 Star Lounger
    Join Date
    Nov 2005
    Location
    Asia Pacific, Bangkok Metropolis
    Posts
    378
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Email Message in Excel (Excel 2003)

    Hi Rory,

    This doesn't seem to work for me. How do you find the Entry ID of the message?

    Error msg show : Unable to display selected folder or item.... (Don't know how to insert the error picture here)

    If I want to show msg that resides in sub folders, is it possible?

    Thanks
    Hope this is helpful

    francis, <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

    My Reading

    Pivot Table 101
    Pivot Table
    Array

  10. #10
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Email Message in Excel (Excel 2003)

    You can select an item in the Inbox (without opening it), press Alt+f11 to open the VBEditor, then Ctrl+G to goto the Immediate window, then type:
    <code>?activeexplorer.Selection.Item(1).entryid</code>
    and it should return something like:
    <code>000000002D7C90DFCF850D41826F36B496DBBEF80700 6774116D4FC45B4B97DFA8C81AE83108000000F686EC000067 74116D4FC45B4B97DFA8C81AE83108000001F9FF210000</code>

    If you want to do items in subfolders, just include the entire path in the link - e.g.:
    <code>Outlook:Inbox/Personal/~Message subject></code>

    HTH
    Regards,
    Rory

    Microsoft MVP - Excel

  11. #11
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Email Message in Excel (Excel 2003)

    Now redundant, but see <post#=481,271>post 481,271</post#>.
    -John ... I float in liquid gardens
    UTC -7ąDS

  12. #12
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Email Message in Excel (Excel 2003)

    Note that links to items in your personal PST will not be available to other users. For this reason it may be better to save the Outlook message to disk, then embed it into the spreadsheet as an object. (In cases where you are responding to some management request, and want to be able to show all users that you did something because the CFO told you to! <img src=/S/smile.gif border=0 alt=smile width=15 height=15>)
    -John ... I float in liquid gardens
    UTC -7ąDS

  13. #13
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Email Message in Excel (Excel 2003)

    No wonder I didn't see that - you were talking to yourself! <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Regards,
    Rory

    Microsoft MVP - Excel

  14. #14
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Email Message in Excel (Excel 2003)

    Hey, I was asking for review, but nobody paid any attention! My best work goes unrecognized, while my mistakes are found instantly. Grumble, mumble ... <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>
    -John ... I float in liquid gardens
    UTC -7ąDS

  15. #15
    3 Star Lounger
    Join Date
    Nov 2005
    Location
    Asia Pacific, Bangkok Metropolis
    Posts
    378
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Email Message in Excel (Excel 2003)

    Hi John

    Thanks for the link. Where do I put the codes of your? I have put it in the Outlook's ThisOutlookSession but when I try to run it, it show an error, Compile Error : User define type not defined and highlighted <font color=blue>Dim objData As DataObject</font color=blue>. How does the codes work.?

    Thanks
    Hope this is helpful

    francis, <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

    My Reading

    Pivot Table 101
    Pivot Table
    Array

Page 1 of 2 12 LastLast

Posting Permissions

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