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)
 mail

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-06-28 : 09:47:48
harshal writes "I need to send bulk mails using the sql server mails
can i send mails in html format using xp_sendmail?
if yes how?
please help.
thnx.
harsh."

jasper_smith
SQL Server MVP & SQLTeam MVY

846 Posts

Posted - 2002-06-28 : 11:32:43
You can't. With xp_sendmail the only option is to attach the HTML
However have a look at[url]http://sqldev.net/xp/xpsmtp.htm[/url]
It will allow sending of mail with HTML body. Or you can do this using sp_OA* procedures and CDONTS

HTH
Jasper Smith

Go to Top of Page
   

- Advertisement -