email from text in a form



Is there a way to set the value in a text field to open a blank email
and insert the email that is associated with that field in the "send
to" field of the email

eg: access form field is BOB SMITH
when the user double clicks this field an email opens up and inserts
(e-mail address removed) in the send to field of the email?


DK Riese

Put this on a button, icon or image (on click) on your form, where you see Me.[Childs Name], or add your own tect between the brackets, or can be any field on your form which will be placed on the subject line.

Private Sub Command57_Click()
On Error GoTo Err_Command57_Click

Dim stDocName As String

stDocName = "Empty_Report"
' DoCmd.SendObject acReport, stDocName
DoCmd.SendObject acSendNoObject, stDocName, acFormatXLS,, , , Me.[Childs Name], , , True
Exit Sub

MsgBox Err.Description
Resume Exit_Command57_Click

Submitted via EggHeadCafe
Win a 2 Year Personal Class Hosting Account From

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question