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!!

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?)


"scubadiver" wrote:

>
> 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!!