1 of 1 people found this helpful
why not have your email server put copies of all emails in a separate account.
Than you can download those emails via IMAP or POP3 and process them to store them in database.
This way you can have them all in a database.
Copy of emails, so people can read and delete their own copies.
Your database deletes them on server once processed.
You can do that e.g. with MBS Plugin.
We have a solution that we developed for the same purpose (robustly archiving emails and linking to FileMaker) that we use internally.
Using AppleScript the system:
* Archives the email text to a FileMaker database
* Make message folders (as needed) on 2 separate file servers.
* Saves the emails as complete individual .eml files using a well thought out folder hierarchy and naming convention.
* Saves the attachments out as files viewable though FileMaker.
* Ties the emails to our contact management system based on the sender and recipient email addresses
Done using AppleScript+Entourage+FileMaker
Took quite a bit of effort to code the AppleScript and set it up. Plus we spend time deciding which emails to archive and which to delete. This effort seems to pay off. Most of this email was based on text pulled from the email archive.
* Possible portable to Outlook (although my first quick run at it makes me wonder if the Outlook AppleScript dictionary is wonky)
* Partly ported to Apple Mail (started last weekend and then got pulled in a different direction)
All the best,
Tony White Designs, Inc.
We integrate email in to all our CRM solutions and use Dacons MailIt. Very pleased with it and have had good support from them.
I have used 360Works email plugin and there example database for years for this with great resultat. I can really recommend the plugin. Besides that I use BaseElements plugin and my company also use MBS plugin