Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Posts
    29

    Unanswered: How do I insert CR/LF - CHAR(13) does not work

    I need to send some long emails, problem is when I send a long body text CDO breaks up the message with spaces in the middle of words. I read on this forum the solution would be to insert CR/LF into the message so that CDO would not have to break it up at every 1k of text. I have tried using CHAR(13) as BOL suggests, but this is not doing as intended, it inserts a space and not the CR/LF I need.

    Any suggestions how to insert CR/LF or why my installation is not responding to CHAR(13) is there some other escape code I could use?

  2. #2
    Join Date
    Feb 2004
    Posts
    492
    Char(10) ?

  3. #3
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    An ASCII cr/lf is hexidecimal 0D0A. You could declare a char(2) variable and set it to 0x0D0A, then concatinate it to the string at your desired break points.

    <code>
    declare @crlf char(2)
    select @crlf = 0x0D0A

    </code>

    HTH

    Tom

  4. #4
    Join Date
    Nov 2003
    Posts
    29
    Hmmm, seems to work, my bad - I guess the results in QA are not accurate, but in the email the CR/LF exists.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •