I have a procedure in one of my modules in which I Dim strBodyText As String and assign it long string values generated in a query. Those strings are acting mighty funny. First of all, they have embedded CRLF's that seem to be fine in the query output. Cutting and pasting one of the query fields into Notepad leaves all the paragraphs as expected. But assigning the same field's value to a string var in VBA and passing that string var's value to a FN that pastes the string into the BodyText section of an Outlook eMail - well, the paragraphs run together as if no CRLF's are being recognized. Secondly, the strings seem to consist of about 255 recognizable chars at the beginning, then terminate in a bunch of hieroglyphics & Japanese Kanji characters. Not good. Solutions anyone?
Thx.