Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2012
    Posts
    2

    Unanswered: All emails received as junk or spam folder

    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..

  2. #2
    Join Date
    Aug 2004
    Location
    Dallas, Texas
    Posts
    831
    It might be the account settings of the recipients have spam filtering for these types of emails. Yahoo may allow these emails and Hotmail doesn't. I don't believe it is a sql db mail issue though. Try sending these emails to various accounts and see if they are blocked or not?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •