Email report with OLE objects attached

  • Thread starter Thread starter Marc Ramsey
  • Start date Start date
M

Marc Ramsey

Hi,

I have table that includes embedded OLE fields, which I
am using as containers for various binary files. I've
made a report based on that table, though it excludes the
OLE objects, since they can't really be displayed
meaningfully.

I am currently able to send this report in an e-mail as
an attachment in various formats (RTF, HTML, etc.).
That's cool.

What I would really like to do is write code to attach
some of those binary files from the table to my e-mail,
along with the report.

Is this possible? Can you point me to the necessary
method?

Thanks!

Marc
 
Mark:

1.) Never store files as OLE objects. It will really bloat your db.
Rather, store a file path in a text field to the db.

2.) Access has no built in method to attach files to an e-mail. You have to
use a third party utility to create and send your mail, or you have use
automation to control Outlook. There's lots of e-mail stuff out there.
Stop by Tony Toews web @ http://www.granite.ab.ca/access/email.htm
 
Back
Top