hi i am sending email from sqlserver database using html format and sp_send_email:
/*
here i have done database select query with html format
create procedure sp_email (@id int)
.
.
for ex:
/*html design*/
SELECT
TD=tbname1.image,'',
TD=tbname2.ID ,'',
TD=tbname1.Description,'',
FROM tb1 left outer join tb2 on tbname1.ID= tbname2.ID
*/
EXEC msdb.dbo.sp_send_dbmail @recipients = @EMAIL,
@profile_name = 'christ',
@subject = @emailsubject,
@body = @tableHTML,
@body_format = 'HTML'
exec sp_email 2,'chrst@christinfo.com'
After executing that email stored procedure
i am getting output in my mail account like follow.
Image ID Description
0xFFD8FFE00..... 123 Amanatools
here, 0xFFD8FFE000104A4649460 is imagebyte which is in database. i can show as an image in asp.net using imagestream(bitmap concept). but i need to send image instead of bytecode through email stored proecudure. is it possible? How to do that. any help.