The following is part of a function to send an email from a form:
.Importance = olImportanceHigh 'High importance
.To = [Forms]![DataEntry]![EmailAddress]
.Subject = [Forms]![DataEntry]![Type]
.Body = ??????
In the body of the email I want to include the contents of various controls in the same way that the subject of the email contains the value of [Forms]![DataEntry]![Type], but I would also like the body to contain free text and new lines.
You can use the & to concantenate a string and the carriage return funtion vbCrLf to input a new line. The space is provided by concatenating a space using " " . If you play about with the above it should do what you need.
NB I have not placed any string line breaks in the above so you will need to ensure the string is all on one line.