Email Database Object Macro

[Tcurtis]

I have a tracking database with I use to put notes in and track different problems. Occasionally I would like to email directly from this database asking quesitons or delivering reports. I have the following in my message text section --- =("Due: " & [Due Date] & [Email Notes])
I would like to add a space or a line between the Due Date and teh Email Notes in the body of the email but cannot seem to find a solution for this. I have tried " " and "" but neither work. I would rather have a line break so the email would have the Due Date at the top and below it the Notes. How can I make this happen?

Thanks

 

[Micron]

If you are passing a string to the body of an email object, you will have to use html to force line wraps or new paragraphs. Email programs will not recognize vba code such as vbCrLf (carriage return/line feed). I will try to write an example here using ASCII character codes which hopefully you will see as the desired result, because this site removes html even if I use code tags. In case it does not save properly, I am trying to write this without the red square brackets:
svBody = "Due: " & [Due Date] & "[<]P[>]" & [Email Notes]

You can look up html character codes to see which other ones you will need. You may have to construct the ENTIRE email body as html to be 100% successful.

svBody = "Due: " & [Due Date] & "<P>" & [Email Notes]