Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Hyperlinked field to email (without writing "mailto:" in address)

Discussion in 'Information Technology' started by alioops, Jul 28, 2006.

  1. alioops

    alioops
    Expand Collapse
    Guest

    We have a hyperlinked field which we use to click on to send an email to the
    record's address. At the moment the only way we appear to be able to do this
    is by typing "mailto:" before the actual address. Is there some other way of
    doing this? Thankyou
    PS: We're no experts here!
     
  2. Loading...


  3. freakazeud

    freakazeud
    Expand Collapse
    Guest

    Hi,
    check this earlier discussion:
    http://www.microsoft.com/office/com...ffice-access&lang=en&cr=US&sloc=en-us&m=1&p=1
    HTH
    Good luck
    --
    Oliver
    Admin Specialist & Computer Science Major @ UMD - Go Terps - :)
    http://www.oli-s.de


    "alioops" wrote:

    > We have a hyperlinked field which we use to click on to send an email to the
    > record's address. At the moment the only way we appear to be able to do this
    > is by typing "mailto:" before the actual address. Is there some other way of
    > doing this? Thankyou
    > PS: We're no experts here!
     
  4. fredg

    fredg
    Expand Collapse
    Guest

    On Mon, 8 May 2006 17:12:01 -0700, alioops wrote:

    > We have a hyperlinked field which we use to click on to send an email to the
    > record's address. At the moment the only way we appear to be able to do this
    > is by typing "mailto:" before the actual address. Is there some other way of
    > doing this? Thankyou
    > PS: We're no experts here!


    Sure. Don't use a hyperlink field.
    Use a regular text field instead.

    Enter the email address as text, i.e.
    joeblow@aplace.net

    On your form, code the Text Control's Double-click event:
    Application.FollowHyperlink = "MailTo:" & Me![ControlName]

    Editing the field is much easier (and inadvertently clicking in it
    doesn't send the mail).
    --
    Fred
    Please respond only to this newsgroup.
    I do not reply to personal e-mail
     
  5. sprur2

    sprur2
    Expand Collapse
    Guest

    ÎʵĺÃѽ,ÎÒÒ²Ïë·¢´ËÒ»ÎÊ
    "alioops" <alioops@discussions.microsoft.com> дÈëÏûÏ¢ÐÂÎÅ
    :93D7DFF2-D8C5-4E44-9FE6-EBEF99EDBB58@microsoft.com...
    > We have a hyperlinked field which we use to click on to send an email to

    the
    > record's address. At the moment the only way we appear to be able to do

    this
    > is by typing "mailto:" before the actual address. Is there some other way

    of
    > doing this? Thankyou
    > PS: We're no experts here!
     

Share This Page