Insert form information into an email

S

scubadiver

I hope posting it here will provide a response.

I'm already able to open an email using a command button.

What I would like to do is be able to press a button, open an email and
insert information from fields from the form into the body of the email.

cheers!!
 
S

scubadiver

just so you know what I can do, this is it:

Dim strToWhom As String
Dim strMsgBody As String
Dim strSubject As String

strSubject = "Your Subject"
strToWhom = Me.Email
strMsgBody = "Hello!"

DoCmd.SendObject , , , strToWhom, , , strSubject, strMsgBody, True

What I would like

strSubject is a word like "reference" and the field to come after it
strToWhom is blank
strMsgBody to consist of all the fields I need from the form (does VBA
recognise carriage returns?)
 
Top