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 - 2003-03-27 : 07:46:19
|
| Sam Finch writes "Windows 2000 Server, SQLServer 7.0 and Exchange 5.5Using XP_SENDMAIL to send emails and need the @message to be a Rich Text Format. The RTF string is stored in a table as a Varchar field. When email is sent, the message does not show the RTF format, but the full string e.g. {\rtf1\ansi\ansicpg1252\deff0{\fonttbl{\f0\froman\fprq2\fcharset0 Times New Roman;}{\f1\fnil\fcharset0 MS Sans Serif;}}{\colortbl ;\red255\green0\blue0;\red0\green0\blue255;\red0\green255\blue0;}\viewkind4\uc1\pard\lang2057\b\f0\fs24 This \cf1 is\cf0 \cf2 a\cf0 \cf3 test\cf0\b0\f1\fs17 \par }Is it possible to make is display the correct message?" |
|
|
|
|
|
xp_sendmail