email field

[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.

 

[Bruce M. Thompson]

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.

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.