email attachmnet (OLE object)

[Dan]

I am trying to email via vba using the following code

http://www.serverwatch.com/tutorial...E-mail-Using-Microsoft-Outlook-Automation.htm

but how do I email as attchment a file that is a field in a table (OLE
object)?

Many thnaks,
Dan

 

[Tom van Stiphout]

On Mon, 18 Jan 2010 08:05:01 -0800, Dan

That's not easy to do. If you insist in emailing using Outlook
Automation you may first have to extract the file from the OLE Object
to a file in the file system, then attach it. Use your favorite search
engine to find hints on how to extract an OLE Object.

Or you could use Access DoCmd.SendObject, and email a report with this
OLE Object on it.

-Tom.
Microsoft Access MVP