TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
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
Forums
Monthly Leaders
Forum guidelines
sharmila k
NA
62
51.6k
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.
Reply
Answers (
2
)
How to create validation in SSRS
Function