Save Outlook Attachment Directly To Access Database

[Hack]

I'm using Excel 2003 VBA (Userforms) as a front end for an app using an Access 2003 Database.

I have a meeting later this week to discuss a requirement I’ve been given for this app.

The requirement is to store Outlook attachments (mostly PDF files) into a database. I know how to do this providing the attachment has been saved to disk.

The users, however, want to be able to save the attachment directly into the database from Outlook itself without having to go through the extra step or two to save it to disk. This I’m not sure of.

The app is an Inquiry Tracking application, and each new inquiry gets a unique, system generated, Inquiry Tracking Number. All attachments saved to the database would need to be associated with that tracking number. In so far as Outlook is completely external to my application, I don’t know how I would be able to do this type of association, presuming I could develop a methodology that actually would save the attachment from Outlook to my database.

I am strongly leaning toward simply telling them they have to save the attachment to disk, and then let my program take over from there. But, as I have a bit of time before this meeting, I was wondering if any of you had any thoughts with respect to how something like they want could be accomplished.

[Siddharth Rout]

Hack One way that I can think of is

1) Vba code will save the attachment to a temp location. Please see this link to extract the attachments.

http://www.vbaexpress.com/kb/getarticle.php?kb_id=522

2) Upload the attachment in binary format in the database. Please see this function by Birger in

http://stackoverflow.com/questions/8...se-using-forms

3) Delete the attachment from the temporary location.

Sid