mbox to Filemaker

[RichardPatterson]

I have 7,000 email exchanges in Mac Mail that I would like to convert to a Filemaker database.  I can export them as an mbox file, but I do not know how to extract them from the mbox archive in a way that will let me import them into Filemaker.  Mail theoretically allows you to export a batch of emails as individual PDF files or even into a large single text file, but there seems to be a limit to the number of emails it can handle in one batch.  Does anyone have any suggestions for a viable procedure for importing emails into a database on the Mac?  I have thought that Applescript might be able to do it, but my Applescript skills are very rusty and I have yet to find any examples of Applescripts that seem to be relevant.  Any suggestions would be greatly appreciated.  I am using Filemaker 18 on a Mac running Mohave (OS 10.14.6).

Thanks.

 

[Ocean West]

Perhaps use third party tool https://c-command.com/eaglefiler/

 

 

[RichardPatterson]

This seems to import the mbox file into its own type of database, but it is unclear to me how to get the data from an EagleFiler library into a format the Filemaker can import.  Do you know if there is a procedure for doing this?

[Ocean West]

Another option move all the emails to an IMAP server then use an EMAIL plugin to download the emails from specific folder form IMAP Server.

 

 

[Steven H. Blackwell]

tell application "Mail"
	activate
	set theSelection to selection
	set theMessage to item 1 of theSelection
	set thesender to sender of theMessage
	set DateSent to date sent of theMessage
	set thecontent to content of theMessage
	set thesubject to subject of theMessage
end tell

tell application "FileMaker Pro Advanced"
	activate
	
	create new record --at after last record
	go to last record
	set data cell "Sender" of current record to thesender
	set data cell "DateSent" of current record to DateSent as string
	set data cell "MessageBody" of current record to thecontent
	set data cell "MessageSubject" of current record to thesubject
end tell

Maybe try this AppleScript..  Note names of fields in FMP database. This won't deal with attachments.  Select one item in Mail client, and with FMP database open, then run the AppleScript.

 

Steven H. Blackwell