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 |
|
Shibbu
Starting Member
2 Posts |
 Posted - 2012-04-18 : 07:13:15
|
hello all,i got stuck, while sending emails using store procedure sp_send_dbmail,when i m sending simple text format then mail received in inbox but wheneveri m trying to send an html format emails with links of images and href tagsmails received in spam.. i store procedure is given below..DECLARE @tableHTML varchar ;SET @tableHTML ='<table border="1" ><tr><td width="187"><a href="http://printbooth.in/product-list.php?cat_id=16&subcat_id=265" target="_blank"><img src="http://printbooth.in/mailer_28-dec/don1.jpg" width="188" height="231" /></a></td>sdfsdflkdfjlksdfldsjfdfsdf<td>Table Cell</td>fsdlfkjsdlkhfsdhfkjsdfsdfsdf</tr><tr><td>Table Cell</td>dfsdfsdfsdfsdfsdfsdfsdfsdfs<td>Table Cell</td>dsfsdfsdfsdfsdfsdfsdfssdfsdf</tr></table>';-- DECLARE @tableHTML1 NVARCHAR(MAX) ;--SET @tableHTML1 ='this is testing message'EXEC msdb.dbo.sp_send_dbmail@profile_name='mindz',@recipients='shibbu.issac86@gmail.com',@subject = 'Work Order List varchar',@body = @tableHTML,@body_format = 'HTML';plz... help me out from this problemanyone have any idea.. s.issac |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-04-18 : 07:32:13
|
| This cannot be controlled from the SQL side/sender side. The spam filter on your e-mail is using whatever rules it is using and deciding that the e-mail is spam. Perhaps the presence of HTML tags plays into that decision making. So the settings on the recipient side need to be change. For example, if the recipient adds the sender e-mail address to his/her address book, most e-mail systems would consider the mail to be non-spam. |
 |
|
|
|
|
|
All emails received as junk or spam