Go to Top

Launch Email Window from Form

If your database contains an email field, you can easily modify your form so that users can single click to create an email in their default email program.

First, modify the control’s Display as Hyperlink property to Always, second, modify the control’s on click event with the following code:

ADVERTISING
ACCESS SAFETY AND TRAINING DATABASE

    If Not IsNull(Me.EMail) Then  
        Application.FollowHyperlink “mailto:” & Me.EMail
    End If

Note: Change EMail to the name of your email control on your form

That’s it! Users will see the familiar web hand when they hover over the email address, and when they click access will launch a new email window for them to further edit before sending off.

About Juan Soto

Juan Soto is a Senior Access Developer at IT Impact Inc. and a Microsoft Access MVP. He specializes in Access with SQL Server databases. His passion for Access has led him to helping a wide range of businesses in helping them establish a secure, stable and efficient environment with SQL Server. He's a frequent speaker at Access user groups nationwide and recently spoke at the Orange County SQL Saturday # 73. If you wish to have Juan speak at your next group meeting you can contact him here.

One Response to "Launch Email Window from Form"

  • Thomas
    September 3, 2014 - 1:20 pm Reply

    Can I use this in MS Access 2003? How would the complete Code Snippet look?

    Thanks!

Leave a Reply

Your email address will not be published. Required fields are marked *

 

Contact Us
[gravityform id="16" title="false" description="false"]