Hi
I'm using msdb.dbo.sp_send_dbmail to send emails .
I've tried to format the body text using
DECLARE @CRLF char(2)
set @CRLF=CHAR(13)+CHAR(10)
SET @p_body = 'Dear Membership Secretary '
@CRLF+@CRLF+ N'Please find attached a list of re-instated members who have been assigned to your group since '+LEFT(CONVERT(VARCHAR, @startdate, 120), 10)
+@CRLF+@CRLF+ N'If you have any queries regarding the information provided in this email please the Membership Services team on xxxxxxxxxxx or email on xxxxxxxxxxxxxxxxxx.'
+@CRLF+@CRLF+ N'Kind regards'
+@CRLF+ N'The Membership Services Team '
but this is not displaying with line feeds when the email in received in my outlook. All the text is on one line
body format is set to 'HTML'
any ideas on what I need to do to reformat this email
Thanks
Update
I've changed it to
<br>
and that works