copying Report / Form data into body of Email

[stu_C]

Hi all
I currently have a form with the below fields (example names)
FRMFormName001
Field001
Field002
Field003
Field004

RPTReportName001

Once the info is filled out we click a button that converts it into a report and once the information is confirmed correct you have to click another button Email it off, this is currently done by a macro creating the report as a attachment PDF File.

The system has now changed and they now want the details in the body of an Email, is it possible to make the details be copied straight into an Email body by a simple macro button click or similar?

I presume I have to create a Email template etc some guidance would be great!

[pbaldy]

You can build a string variable mixing fixed text and references to a form or recordset.

VariableName = "This is fixed text " & Me.TextboxName & " some more fixed text. " & vbCrLf

The vbCrLf adds a return.

[stu_C]

thats confused me even more :|

[pbaldy]

Sorry. If have a specific question, I'll try to answer it.