Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    London, Ontario, Canada
    Posts
    437
    Thanks
    0
    Thanked 0 Times in 0 Posts

    mailto: from table field (Access XP)

    Probably simple but it's eluding me. I have a field in a table defined as a hyperlink. The field contains email addresses imported from Outlook using an addin. When displayed on a form, clicking the text box attempts a normal http:// connection, understandable I suppose. How can I force mailto: I don't see any way to change the field property in the table <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>. I've tried changing the control source i.e. ="mailto:"&[eMailAddress] but that doesn't work. Any ideas? Thanks.

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

    Re: mailto: from table field (Access XP)

    The problem is that if you enter name@domain.tld into a hyperlink field, it is converted internally to http://name@domain.tld (in fact, probably to "name@domain.com#http://name@domain.com#"; a hyperlink field consists of up to three parts, separated by # characters: the displayed text, the address and the sub-address). If you enter mailto:name@domain.com, it's left that way (actually, "#mailto:name@domain.com#")
    You can repopulate the hyperlink field with mailto: followed by the e-mail address, or you can use a normal text field that stores just the e-mail address, and use
    Application.FollowHyperlink "mailto:" & [eMailAdress]
    in an event handler to start the e-mail.

  3. #3
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    London, Ontario, Canada
    Posts
    437
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: mailto: from table field (Access XP)

    Thanks again Hans <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15> application.followhyperlink did the trick. When I get a chance I'll change the import.

Posting Permissions

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