How do I load a new email to send to a record's email address

[jordi20]

I've got a pretty standard form with email address as one of the fields.

I want to be able to send an email to that client.

I want therefore to create a button that say "Send Client Email" and loads an email with that record's email address in the To: line in Outlook Express.

Can someone please tell me how to do that?

Thank you.

 

[pbaldy]

If you use SendObject in VBA, you can just specify the form control in the To argument. More info in VBA help.

 

[bobsyeruncle]

Create an empty report and use sendobject.

Private Sub butEmail_Click()

Dim stDocName As String
stDocName = "EmptyReport"
' DoCmd.SendObject acReport, stDocName
DoCmd.SendObject acSendNoObject, stDocName, acFormatXLS, Me.Email
Exit_Command26_Click:
Exit Sub
Err_Command26_Click:
MsgBox Err.Description
Resume Exit_Command26_Click

End Sub

 

[ted.martin]

This will also work for a button cmdeMail and a text control called eMail

cmdeMail.HyperlinkAddress = "mailto:" + eMail.value