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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 HTML message in SQLMail

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-10-26 : 20:27:06
Ray writes "I have a stored procedure that queries a database and formats an email of the results in HTML. I use xp_sendmail to send the email, but all I get is the HTML text, not formatted in the recipient postbox. What do I have to do to get xp_sendmail to correctly format an HTML message. I am using HTML in order to format the data for display. I can get the email to work in text only, but then the output columns don't line up. Is there a switch or keyword or setting that tells xp_sendmail to obey HTML formatting? Thanks. SQL Server 7.0 with all service packs, Outlook 2000, etc. Followed your paper on installing SQLMail."
   

- Advertisement -