FileMaker can use Outlook to send email, but it won't automatically import received emails. You'll need to research plug ins to see what is possible. There are quite a few that offer email enhancements.
Thanks. I know that creating custom functions requires FileMaker Advanced. Is this also required for writing/installing plug ins?
Just as you can use custom functions with both FileMaker Pro and FileMaker Advanced (but you can only create them in Advanced), you can use plug ins with both versions of the application. And a plug in is created using a third party compiler rather than FileMaker.
From Entourage or Outlook to Mac OSX Filemaker Applescript importer $15
Importing email with dacons' mail.it plugin $60 (comments are sometimes interesting) http://www.dacons.net/fmplugins/mailit5/
http://www.adbergllc.com/email2fmp.html FREE but very limited
Email2FMP is a set of FileMaker Pro databases which import and parse Eudora, Eudora Lite, Eudora Pro, Netscape Communicator, SweetMail, and Mac OS X mail.app mailboxes.
Email2FMP - This is an update to the previous version of Email2FMP - the first version to import Netscape Communicator mailboxes. It requires FileMaker Pro 5.0 or later. This new version includes a completely unlocked Email Archive file that can be modified by the end user. Registered users can export their emails from the locked archive and import them into the open archive file. For more information, see the release notes. Macintosh and Windows versions are available.
Parsing Text that was copy pasted from emails and saved as text to import into FMP
Another thread about parsing email text
Hi Matt, I always do this sort of thing creating a filemaker database with one text field in it. Call it Import Field or something like that. I then import the file, which results in one line of text per record. I then write a script with a loop in it that skips through the lines looking for things I know should be there. Your example is a really good candidate for this, because you have predictable text, like "Firstname: " I delete all records that are junk, like the one that says "The results of your request are below:" I then create a bunch of calculation fields that use text parsing functions to fill the info I'm looking for. Here's a quick example in FM 7. I've named the field "FirstName" and it's a calculation with the following formula: If ( Left ( Import Line; 9) = "FirstName"; Trim ( Middle ( Import Line; Position ( Import Line; ":"; 1; 1)+1; 100)); "") That would yield "John" in your example below I might also use the "replace" command to fill a field like "Customer_ID" or something so I could create the relationship between my customers file and this record. Maybe that jumpstarts your thinking on this. It's somewhat tedious to make a formula like this for every field, but I have done it a lot when converting unusually formatted text files into databases, and once you get it all scripted, it's worth the effort, because you then just run a script and the data shows up where it's supposed to be. Some functions to look at are Left LeftWords Middle MiddleWords Position Replace Right RightWords Substitute Trim Wordcount I hope this helps, Ron
Thanks for the links. Those look like usefule plugins.