If you have a need to get some or all of your email into FileMaker, Mail to FileMaker Importer is your application. I'm using their latest version 1.1 for FileMaker 7. It is simple, well-documented and does its job beautifully.
Mail to FileMaker Importer is made and published by by Automated Workflows, LLC . They describe themselves as:
a leader in professional AppleScript and workflow automation and software integration services and technologyIf this app is any indication, I believe them.
You can meet Benjamin S. Waldie, president of Automated Workflows at the Apple Consultants Network booth on the Macworld Expo show floor on Tuesday, January 11th, from 2:00 PM to 6:00 PM. He will be available to answer AppleScript-related questions. Mr. Waldie writes the Applescript Essentials column for Mac Tech Magazine.
If you are reading this, I have no doubt that you think getting your email into FileMaker is a really good idea. Besides a cool place to archive email, sometimes you may want to process data that you get from web apps that send you email into your database.
When someone downloads my Studio Manager demo off the web, the fill out a little contact information form and a little PHP script sends me an email with lines something like this:
Name: John Doe
Company: ABC Inc.
With Mail to FileMaker Importer (MFI), I highlight the new download emails every so often in Apple Mail and then push the button in MFI to import that mail into my Email Archive database. That gives me all the usual fields including the Body with all the contact information.
I then run a looping script that parses the data into separate filemaker fields. It's that simple! I love it.