Hi to all,
I use sqlmail to send mails to clients, but I must send a report mail in HTML format...
is possible ????

this is my code, that return a simple string and not a HTML page when I open the mail:

------------------------------------------------------------------------
------------------------------------------------------------------------
set nocount on
declare @message varchar(8000)
declare @tempmsg varchar(8000)
declare @attach varchar(255)
declare @msg_id varchar(255)
declare @subject varchar(255)
declare @status int,
@originator varchar(255),
@cc_list varchar(255),
@date varchar(255),
@originator_address varchar(255)

Set @message=&#39;<!DOCTYPE HTML PUBLIC &#34;-//W3C//DTD HTML 4.0 Transitional//EN&#34;>&#39;
Set @message=@message + &#39;<!-- -->&#39;
Set @message=@message + &#39;<HTML>&#39;
Set @message=@message + &#39; <HEAD>&#39;
Set @message=@message + &#39; <TITLE>NovitÃ* di Microsoft Italia - Anno 2 Numero # 20</TITLE>&#39;
Set @message=@message + &#39; <META content=&#34;text/html; charset=iso-8859-1&#34; http-equiv=Content-Type>&#39;
Set @message=@message + &#39; <META content=&#34;MSHTML 5.00.2920.0&#34; name=GENERATOR>&#39;
Set @message=@message + &#39; </HEAD>&#39;
Set @message=@message + &#39; <BODY>&#39;
Set @message=@message + &#39; <TABLE bgColor=#ffffff border=0 cellPadding=8 cellSpacing=0 width=600>&#39;
Set @message=@message + &#39; <TD vAlign=top width=220>&#39;
Set @message=@message + &#39; <FONT face=Verdana,Arial,Helvetica size=2 style=&#34;FONT-FAMILY: Verdana; FONT-SIZE: 11px&#34;>&#39;
Set @message=@message + &#39; <IMG alt=&#34;Software gratuito&#34; border=0 height=50 src=&#34;http://www.microsoft.com/italy/newsletter/images/sw.gif&#34; width=180>&#39;
Set @message=@message + &#39; <TABLE border=0 cellPadding=0 cellSpacing=0>&#39;
Set @message=@message + &#39; <TD>&#39;
Set @message=@message + &#39; <FONT face=Verdana,Arial,Helvetica size=2 style=&#34;FONT-FAMILY: Verdana; FONT-SIZE: 11px&#34;>&#39;
Set @message=@message + &#39; <A href=&#34;http://www.microsoft.it/italy/adv/jump.asp?cod=0020_wordup&#34;> Word 2000 - Aggiornamento: protezione della stampa unione </A>&#39;
Set @message=@message + &#39; </FONT>&#39;
Set @message=@message + &#39; </TD>&#39;
Set @message=@message + &#39; </TABLE>&#39;
Set @message=@message + &#39; </BODY>&#39;
Set @message=@message + &#39;</HTML>&#39;

EXEC master.dbo.xp_sendmail @recipients = &#39;emiliano.cecchetti@tei.ericsson.se&#39;,
@subject = &#39;Report&#39;,
@message = @message
---------------------------------------------------------------------------------


Thanks for any help,
Emiliano.