Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: link e-mail address

  1. #1
    Guest

    Default

    Is there a way to make e-mail address link to outlook express without having to go to hyperlinks and typing mailto:test@mymail.com ? in word it will automatically link when you type the address

  2. #2
    Guest

    Default


  3. #3
    Guest

    Default

    there must be a way!

  4. #4
    Legend NateO's Avatar
    Join Date
    Feb 2002
    Location
    Minneapolis, Mn, USA
    Posts
    9,700
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    In Excel 2000, if you type:

    test@mymail.com

    It should convert to a hyperlink. In fact, it will try to launch Outlook (which is no good or me personally). Are you in 97?

    Nate

    [ This Message was edited by: NateO on 2002-03-11 18:41 ]

  5. #5
    Guest

    Default

    yes I am using '97

  6. #6
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hmmm.... I don't recall. I suppose you cannot choose Format-Cells and choose hyperlink, sooo...do this:

    Copy those cells right into Word. It should create a column in Word that looks virtually the same.

    Select the entire column. Hit Format-Style, make sure it says *all styles* at the bottom of the list. Choose Hyperlink. I'm almost certain 97 has that option. You can check before you move it to Word. If you get the hyperlink on there, go ahead and copy. Go back to Excel, click on first *bad* hyperlink cell and hit paste.
    ~Anne Troy

  7. #7
    Guest

    Default

    When I right clicked to copy had to go to hyperlink copy hyperlink then pasted to excel, Thanks Looking forward to your news letter

Some videos you may like

User Tag List

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
  •