Export Email

Export email

This is the second script I use together with Mailsmith. This exports email from Mailsmith to a FileMaker Pro 4.1 database. I use it for long term storage of messages, using Mailsmith for short term storage (not to mention that Mailsmiths searching is much better).

Note: The current version is 2.0.3 and was updated 2000-11-05

Install

1. Download the scripts and unstuff them
2. Create a folder called "jem script prefs" in the preference folder and inside that create another folder called "lib" and finally copy the file "Mailsmith script library" to the "lib" folder. If you this sounds complicated, double-click the script called "Export install" and it will do this for you.
3. Make a copy of the FileMaker database for each archive you want, I have for example "AppleScript", "MacPerl", "MRJ" and "Email in general". Store them where ever you want
4. For each database you created make a copy of the script "Export selecteded messages" and give them easy-to-understand names, mine are called "=> FileMaker AppleScript", "=> FileMaker MacPerl", etc.
5. Move the scripts into Mailsmiths script folder (so that you can start them by selecting them from the script menu)
6. You are finished with the installtion ... except for one thing: you have to install the Akua Sweets scripting addition (I use that to do the date conversion). You can find it at Akuas web site.

How to use them
When you want to export some messages just select them or one or more mailboxes and select the proper script. For example if I want to export my "MacPerl" mailbox I select it and then select the "=> FileMaker MacPerl" script. The first time you run the script it will ask you for which database to use, select the correct mailbox (in this case the one called "MacPerl") and the export will start. The script will remember which database to use until you rename or move the database.

During export a progress will show you what is happening, in the picture below it has approximately exported 20-25% and is currently exporting a message with the subject "Re: changing fonts"

The database
The database is a very simple one, see pictures below, but I don't need anything more so I haven't bothered to make it more complicated. The three buttons to the left allows you to change view, the BBEdit icon sends the current message to a new window in BBEdit, the "New" button creates a new message in Mailsmith addressed to the sender of the current message. The "Reply" button replies to the sender of the message quoting the message and creates a proper subject line. In the script menu in FileMaker there are a couple of other commands whose function should be obvious.

The List View

The Mail View

The Detail View