Jump to content

email to database?


 Share

This topic is 6507 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 6507 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.