email from text in a form

  • Thread starter Thread starter fishqqq
  • Start date Start date
F

fishqqq

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?

tks
 
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.email, , , Me.[Childs Name], , , True
Exit_Command57_Click:
Exit Sub

Err_Command57_Click:
MsgBox Err.Description
Resume Exit_Command57_Click

Submitted via EggHeadCafe
Win a 2 Year Personal Class Hosting Account From Arvixe.com
http://www.eggheadcafe.com/tutorial...nal-class-hosting-account-from-arvixecom.aspx
 
Back
Top