<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Andy;<div><span class="Apple-tab-span" style="white-space:pre"> </span>You've got two main approaches:</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>export the mails as some form of text and use Applescript and/or Shell, scripts to manipulate it into a CSV file for FileMaker.</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>get SMPTit [a Filemaker plugin] to get the email directly into file maker and manipulate it/them there.</div><div><br></div><div>Russell</div><div><br><div><div>On Jul 17, 2010, at 11:14 AM, Andy wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div>
<font face="Calibri, Verdana, Helvetica, Arial"><span style="font-size:11pt">I want to extract some data from emails sent from a shopping cart. The data will be something like Product: xxxx<br>
Order No: xxxx, Name: xxxx, Address: xxxx etc.<br>
The emails will arrive as either html or plain text. I want to be able to automatically extract this data and insert it into a Filemaker database.<br>
I know I can run a script from a Rule in Mail or Entourage to save/export the emails as plain text but how to get the data into a form that Filemaker can use?<br>
Or is there some other way of doing this? <br>
<br>
Any help from you guys would be really appreciated.<br>
<br>
Andy<br>
</span></font>
</div>
_______________________________________________<br>X4U mailing list<br><a href="mailto:X4U@listserver.themacintoshguy.com">X4U@listserver.themacintoshguy.com</a><br><a href="http://listserver.themacintoshguy.com/mailman/listinfo/x4u">http://listserver.themacintoshguy.com/mailman/listinfo/x4u</a><br><br>Seven Cent Deals - Great legacy stuff Great Legacy Price<br>http://www.drbott.com/prod/db.lasso?cat=Seven+Cent+Deal</blockquote></div><br></div></body></html>