email link in a form 1

[RexS]

From within a form in Access 2000, is there a way to click on an email address that has been entered that will automatically bring up a mail window to send an email to the selected person without typing in the email address?

 

[wemeier]

If you add a DblClick event to the field containing the email address, you can put the following coding in the event procedure:

Private Sub EmailAddress_DblClick()
DoCmd.SendObject acSendNoObject, , acFormatHTML, Me.EmailAddress
End Sub

This will automatically bring up your email client with the email address already filled in.