<div>
use the following example code 
 
DECLARE @tableHTML &nbsp;NVARCHAR(MAX) ; 
 
SET @tableHTML = 
&nbsp; &nbsp; N'
<h2>Work Order Report</h2>
' + 
&nbsp; &nbsp; N'' + 
&nbsp; &nbsp; N'Work Order IDProduct ID' + 
&nbsp; &nbsp; N'NameOrder QtyDue Date' + 
&nbsp; &nbsp; N'Expected Revenue' + 
&nbsp; &nbsp; CAST ( ( SELECT td = wo.WorkOrderID, &nbsp; &nbsp; &nbsp; '', 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; td = p.ProductID, '', 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; td = p.Name, '', 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; td = wo.OrderQty, '', 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; td = wo.DueDate, '', 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; td = (p.ListPrice - p.StandardCost) * wo.OrderQty 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FROM AdventureWorks.Production.WorkOrder as wo 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; JOIN AdventureWorks.Production.Product AS p 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ON wo.ProductID = p.ProductID 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; WHERE DueDate &gt;&nbsp;'2004-04-30' 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AND DATEDIFF(dd, '2004-04-30', DueDate) &lt;&nbsp;2 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ORDER BY DueDate ASC, 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(p.ListPrice - p.StandardCost) * wo.OrderQty DESC 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FOR XML PATH('tr'), TYPE 
&nbsp; &nbsp; ) AS NVARCHAR(MAX) ) + 
&nbsp; &nbsp; N'' ; 
 
EXEC msdb.dbo.sp_send_dbmail @recipients='danw@Adventure-Works.com', 
&nbsp; &nbsp; @subject = 'Work Order List', 
&nbsp; &nbsp; @body = @tableHTML, 
&nbsp; &nbsp; @body_format = 'HTML' ; 
 
check following link as well. topic c 
<a href="http://msdn.microsoft.com/en-us/library/ms190307.aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/ms190307.aspx</a>
</div>

<div>
dbo.sp_send_dbmail i dont think works on SQL 2000.. 
 
Either way i currently do not have this stored procedure, 
 

</div>

sphtmlemail2000.txt

<div>
 

<pre><code class="code-10 nolinks" id="code-124129">CREATE PROCEDURE SendHTMLMail
@From varchar(100)='defaultfrom@domain.com',
@To varchar(100)='defaultto@mydomain.com',
@CC varchar(100)='',
@Subject varchar(100)='no subject supplied',
@Body varchar(8000) ='no body supplied'
AS
BEGIN
DECLARE @iMsg int
Declare @hr int
Declare @source varchar(255)
Declare @description varchar(500)
Declare @output varchar(1000)
DECLARE @ReturnVal int
 
EXEC @hr = sp_OACreate 'CDO.Message', @iMsg OUT
EXEC @hr = sp_OASetProperty @iMsg, 'To', @To
EXEC @hr = sp_OASetProperty @iMsg, 'From', @From
EXEC @hr = sp_OASetProperty @iMsg, 'CC', @CC
EXEC @hr = sp_OASetProperty @iMsg, 'Subject', @Subject
EXEC @hr = sp_OASetProperty @iMsg, 'HTMLBody', @Body
EXEC @hr = sp_OAMethod @iMsg, 'Send', NULL
 
IF @hr =0
SET @ReturnVal= 0
ELSE
BEGIN
--SELECT @hr
EXEC @hr = sp_OAGetErrorInfo NULL, @source OUT, @description OUT
IF @hr = 0
BEGIN
SET @output = 'Error! Description: ' + @description --+'Source: '+@source
PRINT @output
SET @ReturnVal = -1
END
ELSE
BEGIN
PRINT 'There was an error, but sp_OAGetErrorInfo failed so I cannot tell you what happened.'
SET @ReturnVal = -1
END
END
EXEC @hr = sp_OADestroy @iMsg
RETURN @ReturnVal
END
 
-- Test send
EXEC SendHTMLMail @To='me@mydomain.com',@Body='Well &lt;b&gt;hello&lt;/b&gt; there!'
</code></pre>
</div>

<div>
whoops sorry that wasn't what you asked. My bad. 

</div>

<div>
drequinox, 
 
When i run the exe, i get an error message, 
 
Server: Msg 170, Level 15, State 1, Line 4 
Line 4: Incorrect syntax near 'autoemail@meteorelectrical.com'. 

<pre><code class="code-10 nolinks" id="code-124143"> 
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO
 
exec sp_send_MailHtml 
 'EXCHANGESRV' 		--SMTP Server
 'autoemail@meteorelectrical.com',			--From
 'eoin.conway@meteorelectrical.com',		--To
 '',	--CC
 '',								--CCi
	'List of USA Customers',	--Subject
	'select *						--Query to send
	from dbo.Customers 
	Where Country = ''USA''
	'
</code></pre>
</div>

<div>
you are missing comma after the 'EXCHANGESRV' , make sure that this is your smtp server. 
 
try the following , just change the parameters accordingly 
exec sp_send_MailHtml 
&nbsp; &nbsp;'smtp.fr.oleane.com', &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;--SMTP Server 
&nbsp; &nbsp;'YourEmail@sql.com', &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;--From 
&nbsp; &nbsp;'daniel.eyer@free.fr', &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;--To 
&nbsp; &nbsp;'daniel.eyer@wanadoo.fr', &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;--CC 
&nbsp; &nbsp;'', &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;--CCi 
&nbsp; &nbsp; 'List of USA Customers', &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;--Subject 
&nbsp; &nbsp; 'select * from dbo.Customers' &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; --Query to execute 
 

</div>

<div>
That did it, 
But i'm still having an issue with performace, 
it is taking 15 seconds a time to send an email, 
 
I was intending on using this for an email campaign but it would take much to long as i would be using a cursor to send an email to 2000 different recipents, 
 
When i use xp_sendmail it is practically instant, 
why would that be? 

</div>

<div>
in fact this xp_sendmail extended stored procedure makes calls to the MAPI API which are handled at the API/O.S level thats why its faster. and the stored proc uses CDO , but CDO is a wrapper for MAPI there should not &nbsp;be any difference with regards to performance, the only difference which I see is that it connects to the microsoft to refer schemas first , may be thats where its slowing down. but too be honest I never had this problem. may be check your smtp / network etc. 
for more info on different types of messaging options please check 
<a href="http://support.microsoft.com/kb/200018" rel="ugc nofollow">http://support.microsoft.com/kb/200018</a> 

</div>

<div>
Sorry don't understand you exactly there, 
 
Are you saying that 
 
xp_sendmail would be faster than sp_send_MailHtml because it makes calls to the MAPI API which are handled at the API/O.S level?
</div>

<div>
this is what it looks like but thats just guess honestly, because CDO is again wrapper for underlying MAPI therefore it shouldnt be slow either. 
another thing in sendhtml stored proc is that it referes to certain schemas online, which might take a while to get referenced, may be that is one of the reasons. 

</div>

<div>
Is there any stored procedures avaiable that makes calls to the MAPI API which are handled at the API/O.S level and also send HTML? 
 

</div>

<div>
not that I know of, sorry. this script is what I use on my sql server and I shared it with you. I am not sure that if there any others available. 

</div>

<div>
<div class="content wysiwyg-content">
How do i send out HTML Using SQL MAIL from exchange, 

</div>
</div>

How do i send out HTML Using SQL MAIL from exchange,


How do i send HTML using SQL MAIL (SQL SERVER 2000) from exchange

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.