MS SQL

MS SQL RSS

How do i sendt Text and HTML with sp_send_dbmail?

Please support our MS SQL advertiser: Intel Parallel Studio Home

•

Join Date: Dec 2008

Posts: 22

Reputation: NextCom is an unknown quantity at this point

Solved Threads: 0

NextCom

Offline

Newbie Poster

How do i sendt Text and HTML with sp_send_dbmail?

Jul 5th, 2009

The issue isn't how to use sp_send_dbmail, because i use it everywhere, for both querys and system mails.

But i have one problem, and that is how do you send a mail with HTML and TEXT format?

You probably wonder why i need this because all the mail readers now support HTML, and you don't need both. But the problem is SPAM filters, you get +2 spam points for having diffrent HTML source than your TEXT source.

Just pasting in an example:

 Help with Code Tags 
 MS SQL Syntax (Toggle Plain Text) 
EXEC msdb.dbo.sp_send_dbmail
	@profile_name = 'SQLServerDatabaseMailProfile',
	@recipients = @TranslatorEmail,
	@body = @HTML, @subject = @subject, @importance='High', @body_format = 'HTML';
EXEC msdb.dbo.sp_send_dbmail
	@profile_name = 'SQLServerDatabaseMailProfile',
	@recipients = @TranslatorEmail,
	@body = @HTML, @subject = @subject, @importance='High', @body_format = 'HTML';