SQL Server Performance

All emails received as junk or spam folder

Discussion in 'ALL SQL SERVER QUESTIONS' started by Shibbu Issac, Mar 29, 2012.

?

why mails received in spam or junk folder

Poll closed Apr 5, 2012.
smtp server problem 1 vote(s) 100.0%
coding problem 0 vote(s) 0.0%
Multiple votes are allowed.
  1. Shibbu Issac New Member

    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..
  2. Shehap MVP, MCTS, MCITP SQL Server

    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..)
  3. Shibbu Issac New Member

    this problem resolved..
    thanx for your reply.
  4. Shibbu Issac New Member

    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..[IMG][IMG][IMG]
  5. Daxesh New Member

    If your mail profile email address is marked as spam, changing that email address of this account should resove the issue

Share This Page