MS SQL Server DTS - Adding Image field data to HTMLBody of an email

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Adding Image field data to HTMLBody of an email

KevinHanson

2006-03-29, 8:27 pm

Hi folks,

I've got a database table that includes an image field (with binary
data in it).

I'm trying to create a DTS package that will generate an email with the
contents of that image field as the HTMLBody.

I've got everything in place to generate the email, but I can't just
say:

objEmail.HTMLBody = rsImage("image_field")

All I end up receiving is an email full of question marks!

I figure I need to do something sneaky with streaming or something, but
I'm in a time crunch here and am hoping I don't have to spend 2 days
stabbing in the dark to figure it out.

Anyone out there seen/done anything like this before?

Thanks for your help!

Kevin Hanson

Sponsored Links