Making e-mail attachments directcly from a BLOB/OLE data field using VBA/MS Access
Posted on 2014-08-19
I have the e-mail attachments working in my built in e-mail module, but the user has to identify the attachment by file location, so to attach any embedded documents requires them to open and save them to their hard drive first.
The client wants to attach documents already embedded by means of a file loaded through MS Access/OLE and stored in the BLOB field of a MySQL database. The client naturally wants to just identify that document in the software and have the software make the attachment to the e-mail without having to export and identify it in a file location first.
Since the app can have any manner of file types embedded, although most are MS Word documents, are there any viable options to improve the user experience around making e-mail attachments directly from the OLE field, or by pulling it out of the MySQL database and orchestrating the attachment behind the scenes based on having the user just identify the document in the application?
I think loading them through OLE puts a wrapper around the data in the BLOB field so it has to come out via OLE as well?
If they were linked, I imagine we could just use the same path, but this isn't a viable solution as embedding the documents solves other issues for the client, and we don't want to throw the baby out with the bathwater... :)