Annoying Problem with exporting text fields

[MaliciousMike]

Hello,

I have some code which creates an email and inputs data from a form.
One of the text boxes has carriage returns in it like below:

"Hello World

World Hello"

When it gets put in the email it displays as:

"Hello World World Hello"

I really need to keep the vbCrLf.

I've tried the below and spent ages on google groups before posting this, but no luck!

myNotes = Replace(txtNotes, vbCrLf, Chr(10))

Help!

Thanks.

~Mike

 

[ted.martin]

This may be a bit long-winded but I have something similar where I output the underlying form data (table or a query) as a .txt file from a Report using the :

DoCmd.OutputTo acReport, "R-eMailbodytext", "MS-DOSText(*.txt)", "c:\temp\emailbody.txt", False, "", 0

This way the formatting remains.

 

[MaliciousMike]

This may be a bit long-winded but I have something similar where I output the underlying form data (table or a query) as a .txt file from a Report using the :

DoCmd.OutputTo acReport, "R-eMailbodytext", "MS-DOSText(*.txt)", "c:\temp\emailbody.txt", False, "", 0

This way the formatting remains.

The difficlty is that i'm only having trouble with one text field, not the whole form (which has quite a few).

What does outlook use to determine a carriage return?

 

[MaliciousMike]

Nevermind... i'm a complete idiot!!

I was writing a html email and typed "<br>" then my heart sunk and my mind walked off saying "like fuck i wanna be associated with this guy".

Sorry to be a pain!!