Export email threads and attachment from filesystem into seperate folders
Posted on 2009-04-29
Preface: we are currently migrating one users (we'll call him Ted) mailbox from his outlook to a document management system. Reason being is that he stored ALL of his working documents in outlook by emailing working drafts to himself and others. He did not use a file server. I know thats wrong in everyway, however its my job to move his documents and emails to our new system so they can be managed.
I have used a 30 day free trial of "outlook attachment sniffer" to export Teds outlook folder structure + emails + attachments to the file system. I was able to name the emails <subject (without FW or RE)>.msg. And all the attachments were stripped out and named <subject>---<attachmentname>.<extension>
here is an actual naming structure from the export:
Rev 2 of TOTAL proposal for RGV. -2.msg
Rev 2 of TOTAL proposal for RGV. -3.msg
Rev 2 of TOTAL proposal for RGV..msg
Rev 2 of TOTAL proposal for RGV.---TOTALpricereduction109.doc
These three emails and attachment are all part of an email thread, i.e. the orginal plus RE or FWDs (they are incremented by the number). What i would like to do is write a script to move all emails and attachments of a single thread into their own folder named after the subject.
What would be the easiest way to accomplish this and does anyone have a script that could be modified to pull this off