Database mail w/ HTML format | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Database mail w/ HTML format

Hey, I’m trying to send an email in HTML format with a hyperlink. When I include http in it to send a hyperlink, the email does not send. Can someone please tell me if it works for them? Here is an example:
EXECUTE msdb.dbo.sp_send_dbmail @Recipients = ‘[email protected]‘, @Body = ‘Visit <a href="http://192.168.1.1/App">App</a>’, @profile_name = ‘DB_Admin’, @body_format = ‘HTML’, @Subject = ‘TEST’ Thanks!
I have checked this nothing do with code. check your mail server and SMTP Service —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/

quote:Originally posted by dineshasanka I have checked this nothing do with code. check your mail server and SMTP Service —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/

Appeared to be going to the SPAM folder due to our anti-virus software. Thanks for the help!
great.
If you didn’t get any errors in mail log, you can safely say that it is some other error —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/

]]>