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 |
|
edearlove
Starting Member
1 Post |
 Posted - 2003-01-22 : 08:25:05
|
| Hi,I am trying to send a large HTML formatted Email from SQL, I have investigated the SQL Mail route, I can send plain text without a problem, but I have found no way to send HTML in the Message Body.I have also investigated using CDOSYS and creating the std sp_send_cdosysmail, which works fine, although there seems to be a limit to the length of the body (varchar(4000)). I have tried converting this variable type to varchar(8000) and a text type, but to no joy :-(Any help would be much appreciated using either method - or a new one?!?!Many thanks in advance |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2003-01-22 : 14:52:20
|
| Have a look at xp_smtp_sendmail[url]http://sqldev.net/xp/xpsmtp.htm[/url]HTHJasper Smith |
 |
|
|
|
|
|
Sending HTML Mail From SQL