This is a sample of my e-mail creattion. However, I have to add more information which I would like to have presented on another line so it looks nice and in a readable format when the email is sent. How do I format and e-mail with multiple lines and format it to position cetain data on certain lines? The bodyStr is just a varcahr of 4000 bytes so it will just wrap and not look presentable???
set @monthEnding = CONVERT(varchar,@ToDate,101)
Set @bodyStr = 'MOSS identified closed issues totaling $' + @eGRNDAmountTotal + ' for month ending ' + @monthEnding
-- @profile_name = 'Mail Test',
@profile_name = 'DBMAIL',
@recipients = 'email@example.com',
@body = @bodyStr,
@Subject = 'Report: MOSS Executive Monthly Report.'
My e-mail format I would like to have is as follows
Our Group identified and closed issues totaling $________ for the month of___________
· Regional Billing total invoices affected _________________ totaling to $__________
· ATT Render Billing total invoices affected_______________ totaling to $___________