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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-09-17 : 10:25:11
|
| April writes "Hello,I've created a tool that will be used to auto send e-mails to mailing lists using SQL Mail (SQL Server 2000). The user enters the text in an <iframe> on the web site that gives the user options to bold, italic or underline the text. I then save the email to a SQL table that I later send through a job. This seems to be working well, except that in the database I'm storing the message formatting as html tags and so my message has html tags in it, rather than pretty text. Using the stored procedure xp_sendmail, is there a way to format the text so that the e-mail is properly formatted? If not, do you have any other ideas? I have been able to use char(10) to create line breaks, but the , etc. eludes me. I haven't been doing this long, so there may be a fairly straight forward solution, but I haven't found anything that addresses it.Thanks in advance for your speedy response!" |
|
|
|
|
|
Formatting Text in the @message Portion of xp_sendmail