Congratulations - C# Corner Q4, 2022 MVPs Announced
Why Join
Become a member
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
C# Corner Home
Technologies
Monthly Leaders
ASK A QUESTION
Forum guidelines
sharmila k
2.1k
62
48.8k
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
=
'projectjamesnagar@gmail.com'
,
@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.
Reply
Answers (
2
)
How to create validation in SSRS
Function