C++/VB - VBscript embed images in HTML email body

Asked By sumit.halde

21-Mar-07 01:12 AM

Hi
Im sending email's using the "script task" of SQL Server 2005
Integraton Services. The email body is an HTML string . Now i want to
embed image in that body.I tried to do that by downloading the CDO
library ( CDOEX.dll ) but could not add it to the script task ( was
not able to add the cdoex.dll file to the refference of that script) .
Can anybody help me on the same ( either how to add a .dll file in
SSIS script task or any other way to embed image using vbscript to an
html email body)

21-Mar-07 09:52 AM

I don't know anything about "SQL Server 2005
Integraton Services" so I don't know how you're doing
it. I assume that you want a simple solution like

OtherComponent.AddFileToThisEmail

I can't offer any help in that case.

If you actually want to do it "by hand" you can.
It requires converting your binary file to Base64 and
then adding that text to the end of the email. The format
varies slightly depending on whether you actually want a
displayed image or an attachment. That approach
can be done without needing any extra component, but it
requires getting into the details of email structure.