Exporting E-mail text with Returns

[usaaluk]

I want to send text to an Email from Access with Carraige Returns but it totally ignores vbCR. How can I coax it to oblige?

 

[Jon.N]

Try using ANSII character codes in the subject text:

DoCmd.SendObject acSendReport, "ReportName", acFormatRTF, "email@mailprovider.com", , , "This email sends a form as an RTF doc", "Try putting some text in like this." & (Chr(13)) & "This text should be on a new line."

Lists of character codes are freely available on the web. Its also good for including special characters or international characters like ½ and é in your text.

 

[Jon.N]

I've just noticed jwindon posted a topic on 5/16/02. There is a good example of how to use vbCR demonstrated.