Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
neo302
Starting Member
30 Posts |
 Posted - 2006-12-05 : 11:48:26
|
| 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 = 'Test@Test.com', @Body = 'Visit <a href="http://192.168.1.1/App">App</a>', @profile_name = 'DB_Admin', @body_format = 'HTML', @Subject = 'TEST'Thanks! |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-12-05 : 12:54:28
|
| Are you sure it's not sending, it may just be getting blocked as spam because it includes a link? Check the logs of the SMTP server to see if the email is being sent. |
 |
|
|
neo302
Starting Member
30 Posts |
Posted - 2006-12-05 : 13:39:44
|
quote:
Originally posted by snSQL
Are you sure it's not sending, it may just be getting blocked as spam because it includes a link? Check the logs of the SMTP server to see if the email is being sent.
Thanks for the reply.Our email guy can't find anything regarding the mail server. I was hoping someone with 2005 could give it a shot. Thanks |
|
|
|
neo302
Starting Member
30 Posts |
Posted - 2006-12-06 : 11:16:25
|
quote:
Originally posted by snSQL
Are you sure it's not sending, it may just be getting blocked as spam because it includes a link? Check the logs of the SMTP server to see if the email is being sent.
Appeared to be going to the SPAM folder due to our anti-virus software.Thanks for the help! |
|
|
|
|
|
|
Database mail w/ HTML format