I want to send emails by using SQL Mail. I have configure
my sql server 2000, and the mail is working by using both
xp_sendmail and xp_sqlagent_notify extended stored
procedure.

However, it seems I cann't specify to send html content
for the bodyformat.

does anyone know how to do it? or where I can find
detailed documentation on xp_sqlagent_notify?

Thanks,

Peter

As far as I know you can't send HTML based email from SQLMail

You would need to use something like XPSMTP to send HTML based emails
For more information: http://sqldev.net/xp/xpsmtp.htm

--
Keith

"peter" <peter.zhang (AT) noetix (DOT) com> wrote