Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Jan 2005
    Location
    Wichita, Kansas, USA
    Posts
    209
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Email (2000-SR1)

    On a form for demographics, with text box "EMail1", can I set that email address on the form so that it is a hyperlink to click on to send an email to the address that is in that text box? Or some other method to click on the email address itself and open Outlook with that address already specified?

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

    Re: Email (2000-SR1)

    If you want a text box to start an e-mail, you must use a hyperlink field and start it with mailto: - for example mailto:bgates@microsoft.com. Without the mailto: it would be interpreted as a web address. This is not very convenient. Alternatively, you could use a standard text field and place a command button cmdMail next to the text box bound to this field. The On Click event procedure for the command button could look like this:

    Private Sub cmdMail_Click()
    If Not IsNull(Me.EMail1) Then
    Application.FollowHyperlink "mailto:" & Me.EMail1
    End If
    End Sub

  3. #3
    2 Star Lounger
    Join Date
    Jan 2005
    Location
    Wichita, Kansas, USA
    Posts
    209
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Email (2000-SR1)

    Thanks, Hans! Works like a charm. Is there something similar that would work on a report in Print Preview that has acolumn of names and a column of corresponding email addresses? (In this case, a text box "EMail" bound to the EMail field in a "qryShortList")

    Thanks

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

    Re: Email (2000-SR1)

    Reports aren't interactive. Controls on a report don't react to clicks or other events.

  5. #5
    2 Star Lounger
    Join Date
    Jan 2005
    Location
    Wichita, Kansas, USA
    Posts
    209
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Email (2000-SR1)

    Too bad! But, thanks anyway, and thanks again!
    Warren

Posting Permissions

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