+ Reply to Thread
Results 1 to 9 of 9

excel link to Contacts in Outlook

  1. #1
    Registered User
    Join Date
    01-29-2007
    Posts
    46

    excel link to Contacts in Outlook

    Hello
    How can I set up a hyperlink from an excel cell to an micro soft office outlook contact? Both are 2003.
    OS is Vista if that makes a difference.
    Thanks
    Dave

  2. #2
    Registered User
    Join Date
    01-29-2007
    Posts
    46

    Excel link to Contacts in Outlook

    I may have posted somewhere else but I can't find it.....

    Can I create a hyper link from Excel to an Outlook contact?
    Vista / Office Pro / Excel and Outlook 2003 .... (ish)

    Thanks
    Dave

  3. #3
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,099
    If you click in a cell then click the hyperlink icon, go to Linkto: Email address and type it in the email address box
    oldchippy
    -------------


    Blessed are those who can give without remembering and take without forgetting

    If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.

    Click here >>> Top Excel links for beginners to Experts

    Forum Rules >>>Please don't forget to read these

  4. #4
    Registered User
    Join Date
    01-29-2007
    Posts
    46

    Excel link question revised:

    Thanks Old Chippy, but not quite what I was getting at. I'd like to have in my spreadsheet a reference to the contact and then hyperlink it to the information within Outlook / Contacts for this person.

    Thanks
    Dave

  5. #5
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,099
    I don't think it's possible to link to an actual Contact within Outlook, but you can hyperlink to Outlook by put something like this in the hyperlink address

    C:\Program Files\Microsoft Office\OFFICE11\OUTLOOK.EXE

    This will open Outlook, that's the best I can come up with, sorry

  6. #6
    Registered User
    Join Date
    01-29-2007
    Posts
    46

    Thanks anyways

    Thanks OC
    I guess another alternative would be to just copy every contact onto a spreadsheet so I have hyperlink access to it from later work. This is one of them irritating nonsensical MicroSoft issues.

    Regards
    Dave

  7. #7
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,099
    Hey, just found this link, does this help? See "Subscribers' Exclusive Tip"


    http://www.personal-computer-tutor.c...5/newabc15.htm

    For it to work properly the name must be in the same format as listed in Outlook, for example if the names in Outlook are Surname, First Name, then this should be typed in the address
    Last edited by oldchippy; 06-16-2007 at 02:41 PM.

  8. #8
    Registered User
    Join Date
    01-29-2007
    Posts
    46

    Thanks Old Chippy!

    You rock!

    It works well except I get the "are-you-really-sure-you-want-to-do-this-the-world-may-end" pop up

    Thanks
    Dave

  9. #9
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,099
    Hi Dave,

    You can disable the Warning, but only do this if you are confident you know what you are doing with the registry, else "the-world-may-end"

    http://support.microsoft.com/kb/829072

    Warning Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall your operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1