sharmila k

sharmila k

  • NA
  • 62
  • 51.4k

Mail Sending Query Using Sql

Feb 13 2013 8:17 AM
Hi friend,
As, I want to send birthday wishes image to mail.
This is my coding in Sql mail sending query,
EXEC msdb.dbo.sp_send_dbmail
@recipients='[email protected]',
@subject ='Birthday Wishes',
@file_attachments = 'c:\MyFolder\image.gif',
@body=N'<p>Image Test</p><img src="image.gif" /><p>See image there?</p>',
@body_format = 'HTML',
@profile_name ='SQlAlert';
 
Its working good but, it will be display image as attachment in mail.
My requirement is if i send birthday wishes image to mail using sql mail sending query. Once i login my mail click inbox it will be display image in message body automatically.
Please any one solve this problem for me.

Answers (2)