I am calling sp_send_dbmail from within a stored procedure. I am getting the content of @body from a field in a database. I would like the body of the message to be formatted with as though the email had been typed. I need to have the proper line feeds, bolding etc. Does anyone know how to do this?
@profile_name = 'SQLServerDatabaseMailProfile',
@recipients = @recipients,
@body = @mymsg,
@subject = 'my subject'