title: How can I send plain text email (with line breaks) using sp_send_dbmail?
body: <p>I have a SQL Server 2008 procedure that sends email via sp_send_dbmail.</p>
  
  <p>I'm using the following code:</p>
  
  <pre><code>  set @bodyText = ( select 
                        N'Here is one line of text ' +
                        N'It would be nice to have this on a 2nd line ' +
                        N'Below is some data: ' +
                        N' ' +
                        N' ' +
                        field1 +
                        N' ' +
                        field2 +
                        N' ' +
                        N'This is the last line'
                      from myTable )
  
      EXEC msdb.dbo.sp_send_dbmail
          @profile_name = 'myProfile',
          @recipients = @to,
          @body = @bodyText,
          @body_format = 'TEXT',
          @subject = 'Testing Email' ;
  </code></pre>
  
  <p>My myProfile is set to use the local smtp server, which results in a .EML file in c:\inetpub\mailroot\queue</p>
  
  <p>When I open one of those .eml files (ug - the only thing that can open them is outlook express, looking at them in anything else just shows the body as a base64 encoded blob.) it looks like it's rendering the result as HTML - so I'm not sure if the problem is in the client, or </p>
  
  <p>I've tried putting \n into the message, but that didn't work.  How can I send plain text with line breaks, and verify that the end result looks correct?</p>
  
  <p>BTW, I can't actually send the email to test it with real email clients - corp. network is locked down.</p>