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'
Image Test

See image there?
',@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.
sharmila kPosted Feb 15, 2013, 1:30 AM
Thanks for your reply.
But i need send image from sql mail sending,its display without attachment to mail.
Jignesh TrivediPosted Feb 13, 2013, 10:40 PM
hi,
Please check following link
http://www.sqlservercentral.com/Forums/Topic1292947-391-1.aspx
http://www.example-code.com/sql/mht_emailHtmlString.asp
it might help you.