I have a SQL Server 2008 procedure that sends email via sp_send_dbmail.
I'm using the following 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' ;
My myProfile is set to use the local smtp server, which results in a .EML file in c:\inetpub\mailroot\queue
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
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?
BTW, I can't actually send the email to test it with real email clients - corp. network is locked down.