<div>
IF you using SQL Server 2005 &nbsp;you can use database mail.<br />
<br />
For SQL Server 2000 go to <a href="http://www.sqldev.net" rel="ugc">www.sqldev.net</a>&nbsp;and you will find the html option.<br />
<br />
I dont think xp_sendmail allows html format email.<br />
<br />
Hope this helps<br />
<br />
Cheers,<br />
<br />
Aash.
</div>


<div>
use tested by many DBAs: &nbsp;xp_smtp_sendmail for sql server 2000<br />
<a href="http://www.sqldev.net/xp/xpsmtp.htm" rel="ugc">http://www.sqldev.net/xp/xpsmtp.htm</a>&nbsp;<br />

</div>


<div>
Can i use xp_smtp_sendmail &nbsp;to send from Exchange?
</div>


<div>
You can provided they allow non-authenticated mail using SMTP protocol,
</div>


<div>
It takes 15sec to send a single email using this stored procedure, <br />
i'm looking to send out over 2000 emails using a cursor,<br />
This would take over 8hours, <br />
whilst with the xp_sendmail its practically instant,<br />
Can you see why this would be? <br />

<pre><code class="code-10 nolinks" id="code-124044"><span></span>
<span> </span>
<span>declare @rc int</span>
<span>exec @rc = master.dbo.xp_smtp_sendmail</span>
<span>	@FROM			= N'autoemail@meteorelectrical.com',</span>
<span>	@FROM_NAME		= N'Automated Email',</span>
<span>	@TO			= N'eoin.conway@meteorelectrical.com',</span>
<span>	@subject		= N'Hello HTML SQL Server SMTP Mail',</span>
<span>	@message		= N'&lt;HTML&gt;&lt;H1&gt;this is some content for the body part object&lt;/H1&gt;&lt;/HTML&gt;',</span>
<span>	@type			= N'text/html',</span>
<span>	@server 		= N'EXCHANGESRV'</span>
<span>select RC = @rc </span>
</code></pre>
</div>


<div>
Would you mind telling us what was the outcome?
</div>


<div>
<div class="content wysiwyg-content">
I'm currently using xp_sendmail,<br />
<br />
but i now realising that it only sends in simple text format,<br />
<br />
how do i send this in HTML (what stored procedure do i use?)<br />

</div>
</div>


I'm currently using xp_sendmail,

but i now realising that it only sends in simple text format,

how do i send this in HTML (what stored procedure do i use?)


What stored procedure do i use to send a HTML email over exchange server on SQL server 2000

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.