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.