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 technology
If 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.
4 replies on “Mail to FileMaker Importer Rocks”
Thanks for a great recommendation! This readymade db along with the importer not only saves space on my mail servers but its a much better way to archive mail for both business & personal purposes.
You are very welcome. I was just doing a little more archiving to FileMaker today in fact.
Unfortunately, a mail attachment makes the wheels fall off. Until Apple allows us to extract an attachment so we can save it in a container in FileMaker, this isn’t a very robust way to archive emails. Unless I’m missing something.
This seems like the solution I’m looking for, however, I have no idea how to get the data from the body parsed into searchable feilds.
Can you recomend any resources?
Thanks! – ab