FMP 10 Adv on Mac: I'd like to have a tools that imports E-Mails into a
filemaker table.

Until now, I copied the mail body from my mail app Eudora, have a script
parse the text and extract informations like Date, Subject, From and To.

This worked as long a I used Eudora where Cmd-A would get me the whole
mail including the header info.

Now that I moved a new computer, I tried Apple Mail, Opera Mail and
MacSoup. None of those seem to let me select and copy the mail text and
the headers at once. I need to got back to the mail app and copy those
in a seperate step.

Suggestions? How do you get Mails into Filemaker for safe keeping?
--
http://clk.ch

"Christoph Kaufmann" <clk (AT) tele2 (DOT) ch> wrote

How is having the emails in FileMaker any more "safe" than in Mail?? It
might be better to set-up a folder system in Mail to file emails away (do
NOT use silly "Smart" Folders), and using a backup system would mean they
are safe (or as safe as you can get). You could also print them out and put
them in a filing drawer, as well as Saving the emails to a normal OS folder.

If you really want emails in FileMaker, then Mail might have an option to
display all the header information, which can then be copied in one step (I
haven't got Mac OS X on either of these computers to check). The other
option is that there are plug-ins available (expensive) which mean you can
use FileMaker itself as your email application to collect and send emails.

Helpfull Harry )

Christoph Kaufmann wrote:

I occasionally use Mail to FileMaker Importer.app

Slightly quirky but avoids reinventing round objects.

With email in FM, one can link individual communications to billing
records...

Helpful Harry wrote:

[get mails into filemaker for safe keeping]

It isn't, of course. When I started archiving mails in filemaker, I just
assumed I couldn't (or maybe wouldn't want to) use my Eudora folders
for ever, and the information would be unusable as soon as I start using
a different mail reader.

Yeah, I had a dozen folders in Eudora.

I find it convenient to see a customer's mails from his address record.

I can do that with the header info by itself, but then it won't include
the text. Cmd-Alt-U does the trick, but changes to "raw file format",
leaving me with tons of =20= etc.

Thank you for the posting. BTW, can't you put "Helpful Harry" into the
place where you have "your name" now? :-)
--
http://clk.ch

Christoph Kaufmann <clk (AT) tele2 (DOT) ch> wrote:

a few lines of applescript will do the job

With AS, you can register your actions, and FMP can play it (or an
AppleSript in the dock...).

drop mail on the script editor, and look at the "message" item of the
"message" suite.

--
Philippe Manet
en fait, c'est manet avant @

"Christoph Kaufmann" <clk (AT) tele2 (DOT) ch> wrote

Instead of copy / paste, you could probably Save the emails from most email
applications, and then use a Container field in FileMaker to store them.
Saving might keep all the headers.



A Calculation field, Script, ro auto-enter formatting would fix those types
of problems.
i.e.
Substitute(IncomingText; "=20="; " ")



This isn't my computer and I can't access the Internet from my Mac (at least
not without paying an expensive per-minute for a long-distance call). I was
planning to upgrade the computers in the "Black Friday" sales, but that idea
got squashed, so I don't know when ,or even, if that will happen.


Helpfull Harry )