Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Jan 2005
    Posts
    48
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Changing multiple hyperlinks to e-mail addresses (Access 2003)

    Hello,

    Can anyone tell me how to set a field to e-mail hyperlink format rather than just hyperlink. At the moment i'm amending each e-mail address to an e-mail hyperlink as i input it which is pretty time consuming - surely there is a way to change these on mass or set the field to e-mail address format.

    Thanks.

  2. #2
    4 Star Lounger
    Join Date
    Sep 2004
    Location
    Sacramento, California, USA
    Posts
    432
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Changing multiple hyperlinks to e-mail addresses (Access 2003)

    Hi Cathy,

    You might try using a mailto: I can't remember if the colon is the correct syntex

    Carla

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

    Re: Changing multiple hyperlinks to e-mail addresses (Access 2003)

    To enter new mail addresses, enter them in the form <code>mailto:billgates@microsoft.com</code>

    To change existing items to mail hyperlinks:

    Create a query based on your table.
    Add the hyperlink field.
    Select Query | Update Query.
    In the Update to line, enter

    <code>Replace([NameOfField], "http://", "mailto:")</code>

    where NameOfField is the name of the hyperlink field.

Posting Permissions

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