I've tried the mail send as described here. Its working great except for the part where line breaks/carriage returns are removed from the body of the message. The way I've tried it so far is the p_SendEmail procedure is called via my procedure where the body of the message is concatenated(formatted with line breaks). The mail and attachments are recieved but the line breaks generated by my procedure gets removed.

This is how I have generated the linebreaks

SET @MSG ='Dear All,'

SET @MSG=@MSG+CHAR(13)+'Executive : ' +@EXECUTIVE

SET @MSG=@MSG+CHAR(13)

SET @MSG=@MSG+CHAR(13)+'Start Date : ' +CONVERT(VARCHAR(20),@START_DATE,106)

SET @MSG=@MSG+CHAR(13)

SET @MSG=@MSG+CHAR(13)+'End Date : ' +CONVERT(VARCHAR(20),@END_DATE,106)

Finally I pass @MSG as the body of the mail. When the mail is received all the line breaks/carriage returns are absent. Any idea on what's going wrong? The line breaks work properly when I use SQL Db mail.

--Replaced CHAR(13) with < /br>. Works fine