Anyone have a solution for this: I have a SP that returns some text formatted across the top of the page (basically report header info). running the SP in Query Analyzer no problem, but outputing to SQLMail the formatting is lost. Tried using PRINT and have tried RAISEERROR, but the same results with both.

Any suggestions appreciated - Thanks