microsoft access help database programing developer
Back to Access Experts About Access Experts Access Experts Websites Access Experts Team Access Experts Services Access Experts Case Studies Access Expert Tips Contact Access Experts OUR BLOG
 
 
Launch Email Window from Form
by Juan Soto
06/17/2010

If your database contains an email field, here's how to setup a single click email

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:

    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.


If you like this tip you will be delighted with our service! Call or write us today for a free quote regarding your computer needs.

Publish this article in your own corporate newsletter or publication! Contact us to obtain a free license.


Home | About Us Why PCExperts | Team | Services | Newsletter | Contact Us
Copyright © 2004