NextCom 8 Light Poster

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:

EXEC msdb.dbo.sp_send_dbmail
	@profile_name = 'SQLServerDatabaseMailProfile',
	@recipients = @TranslatorEmail,
	@body = @HTML, @subject = @subject, @importance='High', @body_format = 'HTML';