email adobe pdf document stored in OLE Object table

Posted on 2008-11-08
Last Modified: 2012-05-05
I have several imported pdf documents stored in a OLE Object column.  I woul like to email them via outlook when a user clicks on a command button on a form.  I have the email code, except for how to attach the OLE Object.  I tried to write the file to a temp.pdf file, but when I receive the email the pdf is unreadable.  is there a memory stream or other object that can be used to attach to an email msg and be filled with the ole object column?
Question by:prumery
    1 Comment
    LVL 74

    Accepted Solution


    This is one of the reasons why most people do not store this type of data in OLE fields.
    The other resaon is that it bloats the database.

    See this lnk for a possible solution:


    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    PaperPort is a popular document imaging/management product from Nuance Communications ( It is in widespread use by both individuals ( and businesses (http:/…
    Inserting page numbers in Portable Document Files not only enhances manageability but also makes them look professional. With numbered pages, the file appears more organized and it becomes easier to search for a particular page. The size and the vol…
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
    We often encounter PDF files that are pure images, that is, they do not have text characters, but instead contain only raster graphics. The most common causes of this are document scanning software and faxing software/services that create image-only…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    25 Experts available now in Live!

    Get 1:1 Help Now