Prev: Convert SQL timestamp to Unix timestamp with timezone
Next: Your SQL Server monitoring habits
From: coolerboy on 18 Jan 2010 14:42
Hi,
I try to send HTML email with sp_send_dbmail. In body of the email I have a
HREF tag. Sending email works fine but I can't get the URL as it should be in
HTML the body, it shows both url and text in the body of the message, see the
example below


EXEC msdb.dbo.sp_send_dbmail
@recipients='anyone(a)nowhere.com',
@subject = 'MCP Alarms for Previous 24 Hours',
@body = '<A HREF="http://mydomain.com?id=27736">product 1</A>',
@body_format = 'HTML',
@profile_name = 'myProfile';



Thankful for any help
Regards



 | 
Pages: 1
Prev: Convert SQL timestamp to Unix timestamp with timezone
Next: Your SQL Server monitoring habits