Insert form information into an email

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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

Back
Top