Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2011
    Posts
    18

    Unanswered: Creating Link to Outlook Email from Button

    Hello i want to create a button, and when a user clicks it, an email template from outlook will pop open with default list of people to send to and a filled in subject line. id appreciate any help thanks!

  2. #2
    Join Date
    Nov 2011
    Posts
    413

    Email Button to send mail

    On one of my form I use this on a command button.It opens whatever email software you set as your default. Choose whoever you want to send to after it opens.

    Private Sub Command209_Click()
    DoCmd.SendObject acSendNoObject, "FormTyp", acFormatHTML, [E Mail], , , , "DrDos Computer Consultant", True, ""
    End Sub

  3. #3
    Join Date
    Sep 2012
    Posts
    5
    Hi Burrina this is what I am looking for a contact form but is there an easy way to add the email address of the contact as well.
    Thanks
    Last edited by Bursal; 09-11-12 at 00:56. Reason: Spelling mistake

  4. #4
    Join Date
    Nov 2011
    Posts
    413
    Yes. I created a filed in my table called E Mail and put this on my form. Then create a command button and use the onclick event and enter this code.Of course substitute your custom message instead.

    Private Sub Command209_Click()
    DoCmd.SendObject acSendNoObject, "FormTyp", acFormatHTML, [E Mail], , , , "From Gulf Coast Electric", True, ""
    End Sub

Posting Permissions

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