Post reply

Sending image embedded into the body of mail using DB mail

  • May 1, 2012 at 12:54 am

    #392156

    Hi,

    I want to send an image embedded in the body of mail and want to send that mail using the DB mail i mean using the stored procedure sp_send_dbmail. Please help me ..

    Ashok

  • May 1, 2012 at 2:25 am

    #1481636

    Do a search for the DBMAIL and HMTL on the Microsoft MSDN site or BOL. There are some helpful examples that should point you in the right direction.

    :exclamation: "Be brave. Take risks. Nothing can substitute experience." :exclamation:

  • May 2, 2012 at 10:15 pm

    #1482801

    Yes, Great, I found a solution for it.

    that is :-

    exec msdb.dbo.sp_send_dbmail

    @recipients = xyz.abc@abc.com',

    @subject = 'hello Yo Yo Honey Singh ',

    @file_attachments='E:\temp\Blue_hills.jpg',

    @body= 'Suno Mere Veero Ajj Meri Kahaani Main Sofiyan Da Raja Nashe ch Meri Rani ...Yo Yo Honey Singh<p>:) :)Image Test</p><img src="Blue_hills.jpg" /><p>:) :)See image there?</p>',

    @body_format = 'HTML';

    -----------

    Ashok

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply