Im trying create an automated mail with my query results, but the formatting is messed up and it's barely understandable. The query returns 10 columns with aproximately 10 lines. Is there any good way to easily format it better? It doesn't matter if it's an attached file or in the mail body(maybe a .txt file?).
EXEC msdb.dbo.sp_send_dbmail
@profile_name='Notification',
@recipients='test@test.com',
@subject='Updated',
@body = 'Hi this is an automated mail',
@query = 'SELECT * FROM [TestDB].[dbo].[TestTable]',
@attach_query_result_as_file = 0
Thank you!
Br Andreas