Hello, i developed a mass mailing tools, but all mails received in junk and spam folder i use an store procedure 'sp_send_dbmail' which is by default in sql server, when i send an testing mail using object explorer ->Database mail -> right click -> send testing mails, then this mail received in inbox, but when i call 'sp_send_dbmail' this procedure using job with 2 min intervals then mails received in junk or spam folder of recipients.. i configured correctly all information of smtp details ip address... is there is any idea related to this problem... why mails r received as junk or spam folder ?? thanks..
First welcome to Forums.. Always , such issue have nothing to do with codes, but for SMTP security configurations regarding blocked list of Senders or IPs. or DNS names …etc Therefore , to double check SMTP configurations if mail sender + DB Server IP or DNS ( In case of DB cluster, it is much preferred to specify physical IPs plus VIPs to assure no block for any of them..)
hello, 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 whenever i m trying to send an html format emails with links of images and href tags mails 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>sdfsdf lkdfjlksdfldsjfdfsdf <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 problem anyone have any idea..
If your mail profile email address is marked as spam, changing that email address of this account should resove the issue