email field

  • Thread starter Thread starter Alan Fisher
  • Start date Start date
A

Alan Fisher

Is there a way to create an email field that would allow
the user to click in the field and have outlook pop up
with a new message already addressed to the addressee in
the field.
 
Is there a way to create an email field that would allow
the user to click in the field and have outlook pop up
with a new message already addressed to the addressee in
the field.
Click to expand...

My preference is to store the email address in a text field and generate the new
message, with a command button or double-click of the text box, using:

'***
'Make sure "Email" contains minimum length for a valid address
If Len(Trim(Me.Email.Value) & vbNullString) > 5 Then
Application.FollowHyperlink "mailto:" & Me.Email.Value
End If
'***

Where "Email" is the name of the text box bound to the "Email" field.
 
Back
Top