Email BLOBS as a .jpg attachment

  • Thread starter Thread starter Jacob Bushnell
  • Start date Start date
J

Jacob Bushnell

Hi, How can I send a BLOB as an email attachment?
I am using outlook to send my existing mail and it is not
located on a Server. Mailing a snapshot of a report is
not feasible because the recipients will not have a
viewer for snapshots.
Oh, I should mention that the attachment is a .jpg.
Anybody know how this can be done?
Thanks a lot, Jacob Bushnell
 
Hi Jacob,

When you say BLOB do you mean an OLE field containing an embedded jpg
(i.e. packaged), or a field that just contains the data from the
original jpg?

If the former, one technique is to use a form with a bound objectframe
control. Navigate to the record, use the objectframe's Verb and Action
properties to activate it in its parent application, and then use
Automation to make the app save it as a disk file that can be attached.

If the latter, you can use GetChunk() to extract the data from the field
and then write it to a disk file yourself.

But first, check out www.lebans.com, where MVP Stephen Lebans has some
amazing stuff for dealing with pictures among other things.
 
Back
Top