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.

Version: v6.x

Platform: Mac OS X Jaguar

[AudioFreak]

Hi,

I have never used This but heard good things about it. Allows you to receive the mail into Filemaker. Then I assume it would be a matter of parsing the info out to the correct fields. HTH

Michael

[Jeff Spall]

Hi, yes good call!

I've used both the pop3it and SMTPit extensions and they do just what's needed here, plus much more. You can "get mail" on a timed basis (like every five minutes) and do complicated sends even with enclosures. The price is quite reasonable for the functionality - as long as the client is paying :-)

regards, jeff