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
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.
Can I use this in MS Access 2003? How would the complete Code Snippet look?