Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Oct 2008
    Location
    Southampton, Hampshire, United Kingdom
    Posts
    39
    Thanks
    7
    Thanked 0 Times in 0 Posts

    Email Field... (Access 2003 (sp3))

    How do I make the Email address appear in the TO: box of my Outlook programme, when I click the email on my formin Access it starts up Outlook fine, but always inserts the word [Emailaddress] rather than the persons actual address from the field...

    any help out there would be very much appreciated...ta Steve in Southampton UK

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

    Re: Email Field... (Access 2003 (sp3))

    Welcome to Woody's Lounge!

    You write "when I click the email on my form". Could you explain what you click? A command button, or a text box, or...? And what type of field contains the e-mail address - a text field, or a hyperlink field?

  3. #3
    Lounger
    Join Date
    Oct 2008
    Location
    Southampton, Hampshire, United Kingdom
    Posts
    39
    Thanks
    7
    Thanked 0 Times in 0 Posts

    Re: Email Field... (Access 2003 (sp3))

    My goodness what a swift response!!
    Okay I have a label on my form called label247, when I click this label it starts up an [eventprocedure] as follows:
    Private Sub Label247_Click()
    Application.FollowHyperlink "mailto: [Emailaddress]"
    End Sub

    The email address is in another field named : Emailaddress....
    After this my brain begins to hurt... thanks Steve

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

    Re: Email Field... (Access 2003 (sp3))

    Thanks for the clarification. Try this:

    Private Sub Label247_Click()
    Application.FollowHyperlink "mailto:" & [Emailaddress]
    End Sub

    The [Emailaddress] field is placed outside the quotes, so the code now uses the value of the field instead of the literal text.

  5. #5
    Lounger
    Join Date
    Oct 2008
    Location
    Southampton, Hampshire, United Kingdom
    Posts
    39
    Thanks
    7
    Thanked 0 Times in 0 Posts

    Re: Email Field... (Access 2003 (sp3))

    Worked at treat!!
    Thank you very much indeed HanV for you help.....

    Hare Krysna...Steve - Southampton UK

Posting Permissions

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