Email form data

[DaveyJ]

Hi Guys ,

hope some of the Guru's can help me out.

I have a Access form in which I would like to be able to email using some of the form data for the recipient of the email. I am also trying to find out is there any way to populate the body of emails text with information from the form.

i have used the sendobj macros but this emails he full form as an attachment. Hoping someone can point me in the right direction.

thanks in advance.

[pbaldy]

I don't use macros, but you can certainly use form values in VBA code. You'd build a string variable:

strBody = "Dear " & Me.FirstNameField

then use the variable in SendObject.

[DaveyJ]

thanks for the quick reply.

below is what i've been able to do, how would i incorporate your suggestion to what i've got? or am i going about it the wrong way?

Private Sub sendEmail_Click()
DoCmd.SendObject acSendForm, "Frm_details", , _
"me.field", "me.field2", , _
"Subject:" & Me.subjectr, "Here the message text"
End Sub

[pbaldy]

See if this works (I assume you don't actually want to send the form):

DoCmd.SendObject , , , _
me.field, me.field2, , _
"Subject:" & Me.subjectr, "Here the message text"

[DaveyJ]

thanks

this brings up the email with no attachment but doesn't populate the to: fields with the form data

am i doing something wrong?

apologies , i am very new to VB

[pbaldy]

Regarding me.field, is "Field" the name of the control on the form with the email address in it? Can you post the db here?