Emailing an OLEObject

A

Andy

I have a database I use for tracking performance reviews
and related documents. The documents are embedded word
documents saved in the OLEObjects field.

What I would like to do is be able to email the documents
out to the participants as needed following their review.
I have figured out the mechanics of getting an email to
our Lotus Notes system. However, I cannot figure out how
to get the document out of the OLEObject field to add as
an attachment.

I have tried copying the document from the field to the
hard drive, but something in the format is not correct - I
believe it is an additional header added by Microsoft as
it saves it in the OLEObject field.

Any ideas would be appreciated!

Thanks!
 
K

kevin

Have you tried to simply link the document rather than
embed them. This would allow for you to pull up the
original document through the use of a Hyperlink scenario?
 
A

Andy

Document security is the main reason I cannot do that.

I did not want to link the document as I will be storing
this database on a network drive - encrypted and password
protected - and the folks being reviewed are technically
savvy.

Even if storing them on a local drive, I do not want to
keep a bunch of loose documents out there. I may be being
unrealistic, but wanted to at least try using embedded
documents first.

Probably better tools for me to use out there, but this is
one I can usually code in.

Thanks for responding!
 
Top