Mailsmith
Other Programs
FileMaker
Palm Desktop
PGP
Scripts
Accounts
Address Book
Editing
Filters
General
Import/Export
Links
Mailboxes
Memory
Scripting
Speed
send/receive
Tips/Tricks


Mailsmith FAQ: FileMaker

I suppose you know that FileMaker is a database. You can either use Mailsmith to send your emails from within FileMaker, or you can use FileMaker to archive your emails.

Use FileMaker to archive your email

FileMaker can be used to archive emails. There are several solutions to do this:

  • One can be found at BBSW
  • Jason Davies have modified that script for UK users. The description says:
    About Mailsmith to FMPro (UK dates)
    This is a slightly modified version of the script supplied by Barebones as an unsupported script. The only difference is that the dating formats are altered to use standard British dates (day/month/year) instead of US (month/day/year). The US version will only transfer messages whose dates can impersonate US dates. When you first open the Filemaker database it will ask which date settings you want: you should tell it to use the Finder's settings.
  • I have patched together a quick hack from BBSWs solution together with "Emailer Archive" by Dan Crevier and David Cartright. A "hack" means that I just have fixed the things I needed (only export from Mailsmith to FileMaker Pro, nothing else) but since I have little time to improve it I thought I would publish this so you can fix the rest yourself face_happy.
 
Can I send email from within a FileMaker database using Mailsmith?
1999-04-17
Well both yes and no. From what I understand it's not possible to do it with the builtin command in FM4 since it's hard coded to use Eudora or Emailer (I don't own FM4 myself so this could be a misunderstanding on my part). But you could do using an AppleScript, you could do it in three different ways:
  • René Brouwer have this solution:
    I'd write an AppleScript telling application "Mailsmith 1.1" (etc. etc), and put that in a Filemaker global field. In lieu of the stuff you want to send and the subject, addressee etc, use lettercombinations (like "the-subject", "the-body", "the-to", "the-cc") that you'll substitute in the next step. Now create a calculation field that takes this global field and substitutes these lettercombinations with the contents of the fields that contain the appropriate information. So, substitute the lettercombination "the-subject" with the field "subject", etc. Next, create a Filemaker script using the "Perform AppleScript" command, using the calculation field, that should now contain a valid AppleScript for each record, as its source.
  • Christian Smith at BBSW gave this solution:
    I built a script a couple of weeks ago that does this by building an extended mailto: url and then passing the mailto: url to the finder which causes it to be passed to the prefered email client. This is really the best way to do this sort of thing. It does require the use of the (free) Encode URL OSAX.
    Rob Russell took the script and turned it into an FMPro dataabse which I have placed at:
    ftp://ftp.barebones.com/pub/scripts/mailsmith/mail_from_fmpro.hqx
  • My version: see this page
 
Where can I get FileMaker
1999-05-06
According to some sources you can a free copy of v2.1 at www.macuser.co.uk