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)
 Send HTML encoded emails via SQLMail

Author  Topic 

vvuong
Starting Member

1 Post

Posted - 2003-06-05 : 14:40:45
I need to be able to send emails that are HTML encoded via SQLMail. The body of the email will be created in a script and is not a resultset from a query or anything like that. I will simply be creating the message body and sending it out via SQLMail.

What can I do to tell SQLMail that the content type is 'text/html'?

Thanks,

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-06-05 : 14:46:05
You can't use SQLMail to send e-mails that are HTML encoded. You will need to look at a different e-mail solution for this.

Tara
Go to Top of Page

jasper_smith
SQL Server MVP & SQLTeam MVY

846 Posts

Posted - 2003-06-05 : 15:34:39
You might want to look at this as an alternative [url]http://sqldev.net/xp/xpsmtp.htm[/url]


HTH
Jasper Smith

0x73656c6563742027546f6f206d7563682074696d65206f6e20796f75722068616e6473203f27
Go to Top of Page

efelito
Constraint Violating Yak Guru

478 Posts

Posted - 2003-06-09 : 11:14:52
Another way around this is to create the HTML file and attach it to the email. It doesn't sho up in the body, but opening the attachment was an acceptable sacrafice in my case.

Jeff Banschbach, MCDBA
Go to Top of Page
   

- Advertisement -