Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Leesburg, Virginia, USA
    Posts
    618
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Hot links (Excel 2003)

    I have pasted email addresses in to cells in a spread sheet, however they are not "hot". For example, I would like to be able to click on an email address an have Outlook launch a new message window. How do I do this?

  2. #2
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hot links (Excel 2003)

    Try highlighting the cell and pressing Ctrl + K. HTH
    Gre

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

    Re: Hot links (Excel 2003)

    Assuming that Excel 2003 works more or less like 2002: if "Internet and network paths" is ticked in the AutoFormat As You Type tab of Tools | AutoCorrect Options..., you will have to edit each cell and confirm without changing (F2 followed by Enter), or select the cells and run the following macro:

    Sub SetMailLinks()
    Dim oCell As Range
    For Each oCell In Selection
    oCell.Hyperlinks.Add oCell, "mailto:" & oCell
    Next oCell
    Set oCell = Nothing
    End Sub

  4. #4
    3 Star Lounger
    Join Date
    Mar 2003
    Location
    Beddau, Mid Glamorgan, Wales
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hot links (Excel 2003)

    Jim:

    I think the problem is the 'pasting'. I find that typing in the email address creates a live link automatically (I have XL 2002).

    One workaround is, after pasting the address, right-click the cell and select Hyperlink, select Email address and paste again into the Email address box.

    A bit of a faff, but probably quicker (and more accurate!) than typing the address into the cell.

    Tony
    Regards,

    Tony
    [s] [/s]
    www.SylviArtist.com

  5. #5
    3 Star Lounger
    Join Date
    Mar 2003
    Location
    Beddau, Mid Glamorgan, Wales
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hot links (Excel 2003)

    Hans:

    Once again, I wish I stayed my hand - your solution is so much easier.

    Tony.
    Regards,

    Tony
    [s] [/s]
    www.SylviArtist.com

Posting Permissions

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