email to database?

[superlukeyboy]

whenever anyone sends me an order off my site i get this email:

--------- FORM DATA STARTS HERE ---------

<First Name>

Potato

<Last Name>

Head

<Email>

[email protected]

<Email Confirmed>

[email protected]

<Address>

Potato House

Highland Road

Northburog

Shiringhamshire

IG7 4FX

Twoodeland

<Refered By>

friend

<Friend's Email>

[email protected]

<DVD>

Saving Private Ryan

<Gift>

portabledvd

<Comments>

make it snappy!

<Terms>

on

<Mobile/Phone Number>

07548 531468

---------- FORM DATA ENDS HERE ----------

Now the email is sent via a free email service so unfortunately i can't edit how it appears. wot i'm wondering is if i can get it so that when i open my database it will run a script that will open my mail application, (in this case it is actually the Mac OS X Jaguar application "Mail") read through the order emails which will always have the subject, "New Order" and import all the data present into the correct fields in a new record for each email. can i do this? if so how? i have encolsed my databases.

by the way, in the order database the "referred by" field should be the email address of the person who referred them.

[CyborgSam]

The download didn't work...

I don't know Mail's AppleScript dictionary, but this should be possible. Basically, get Mail to export as text the messages. The trick to making this easy is: can you tell Mail what to name the export file for each message? Have Filemaker import each message into a single text field. Have the script parse that field and set all the other fields.

[AudioFreak]

This is a double post! I replied to the other post Here

There is no need to post into several sections.

Michael