Saving Attachment to specific folders

[I-jen]

Hi All, I receive attachments on a daily basis in which I need to archive to specific folders determined by a file number which I will have to enter. Once saved, I need to generate a record in an Access table relating the file path to the file number.

Is there a way to add a submenu item (ex. “Archive File”) when you right click on an attachment which will prompt for a file number then proceed to save that file to a specific location designated by the file number, then open and append a record to an Access table.

Currently, I have to save the file to disc, then open an Access application to “archive” the file.

Thanks a bunch!

BTW, I do not want to automate the entire saving of ALL attachment process as there are other attachments I do not want to save in this matter.

[matthewspatrick]

I-jen,

Can you elaborate a bit on what you're trying to do? Some specifics on how to identify files that go to certain directories, what to do with Access, etc are needed.

[I-jen]

In more detail,

In our office, we have a job tracking application built with Access 2003. Our clients and/or contractors will email documentations related to specific jobs to us. Each job is identified by a 6 digit job number. These documents are moved to a very structured folder schema as defined by the job number. For example, job number #123456 will be stored in the folder "I:\DocArchive\123000\123456\". When moving the file to that location, a time stamp string is concatenated in front of the file name, which will allow us to store multiple version of the same file. Once the file is moved, the path to the document is stored in a table for ease of retrieval. In most cases, we will know what the job number is when we receive the attachment as our client/contractor is asked to put the job number in the subject line.

Currently, we have to right-click on the attachment and save it to a temp folder. Then using the job tracking app, go to the job number in question, fire up the documents form, click a button to open the file dialog box, look for the file, and "upload" it.

I'm looking to see if it's possible to automate the entire process starting from the email with the attachment. I would like to be able to "right-click" on an attachement and, instead of "Save-As" to put the attachment on the hard drive, to open a dialog box which asks me for the job number and that's it. The dialog box will need to create the folder if it doesn't already exist, move (or copy and delete) the file to the designated place, change the file name with a time stamp string. Finally, open the table which stores the path to the file, write a record with the job number, path to the file and the new file name.

Since we receive 30-40 orders a day, we would like to automate this process. Hope this helps to explain what I would like to achieve.

Thanks