email addresses

  • Thread starter Thread starter allan
  • Start date Start date
A

allan

I am putting together a database for contacts. The form I
created for data input has a command button that opens
Outlook to email the contact. The question I have is how
do I get the email address to be populated from the email
field for that specific record instead of having to cut
and paste the data?
 
I am putting together a database for contacts. The form I
created for data input has a command button that opens
Outlook to email the contact. The question I have is how
do I get the email address to be populated from the email
field for that specific record instead of having to cut
and paste the data?
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