-
xp_sendemail.. mail in html format
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='<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">'
Set @message=@message + '<!-- -->'
Set @message=@message + '<HTML>'
Set @message=@message + ' <HEAD>'
Set @message=@message + ' <TITLE>NovitÃ* di Microsoft Italia - Anno 2 Numero # 20</TITLE>'
Set @message=@message + ' <META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>'
Set @message=@message + ' <META content="MSHTML 5.00.2920.0" name=GENERATOR>'
Set @message=@message + ' </HEAD>'
Set @message=@message + ' <BODY>'
Set @message=@message + ' <TABLE bgColor=#ffffff border=0 cellPadding=8 cellSpacing=0 width=600>'
Set @message=@message + ' <TD vAlign=top width=220>'
Set @message=@message + ' <FONT face=Verdana,Arial,Helvetica size=2 style="FONT-FAMILY: Verdana; FONT-SIZE: 11px">'
Set @message=@message + ' <IMG alt="Software
gratuito" border=0 height=50 src="http://www.microsoft.com/italy/newsletter/images/sw.gif" width=180>'
Set @message=@message + ' <TABLE border=0 cellPadding=0 cellSpacing=0>'
Set @message=@message + ' <TD>'
Set @message=@message + ' <FONT face=Verdana,Arial,Helvetica size=2 style="FONT-FAMILY: Verdana; FONT-SIZE: 11px">'
Set @message=@message + ' <A href="http://www.microsoft.it/italy/adv/jump.asp?cod=0020_wordup"> Word 2000 - Aggiornamento: protezione della stampa unione </A>'
Set @message=@message + ' </FONT>'
Set @message=@message + ' </TD>'
Set @message=@message + ' </TABLE>'
Set @message=@message + ' </BODY>'
Set @message=@message + '</HTML>'
EXEC master.dbo.xp_sendmail @recipients = 'emiliano.cecchetti@tei.ericsson.se',
@subject = 'Report',
@message = @message
---------------------------------------------------------------------------------
Thanks for any help,
Emiliano.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|