Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vinurvk
Starting Member
8 Posts |
 Posted - 2010-12-15 : 05:16:19
|
| How to Send Result in a Table Format via sp_send_dbmail..I want to populate a table result - say Select * from User_List within the email which gets triggered via sp_send_dbmail.The above statement will retrieve 5 rows and 3 columns.I tried so many forums and everyone is suggested xml querying which am aware of. |
|
|
vinurvk
Starting Member
8 Posts |
Posted - 2010-12-15 : 05:24:35
|
| EXEC sp_send_dbmail @profile_name='Mailer',@recipients = 'vin@abc.com',@subject='User Details',@from_address ='Reporting@abc.com',@body_format = 'HTML', @query='select * from users_list'-When i do this am getting the result inside the mail without any alignment.Is there a possible to populate the data into a HTML Table format.. |
 |
|
|
|
|
|
How to Send Result in a Table Format