[X4U] Extracting data from an email

[Russell McGaha]

Andy;
	You've got two main approaches:
		export the mails as some form of text and use Applescript and/or Shell, scripts to manipulate it into a CSV file for FileMaker.
		get SMPTit [a Filemaker plugin] to get the email directly into file maker and manipulate it/them there.

Russell

On Jul 17, 2010, at 11:14 AM, Andy wrote:

> I want to extract some data from emails sent from a shopping cart. The data will be something like Product: xxxx
> Order No: xxxx, Name: xxxx, Address: xxxx etc.
> 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.
> 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?
> Or is there some other way of doing this? 
> 
> Any help from you guys would be really appreciated.
> 
> Andy
> _______________________________________________
> X4U mailing list
> X4U at listserver.themacintoshguy.com
> http://listserver.themacintoshguy.com/mailman/listinfo/x4u
> 
> Seven Cent Deals - Great legacy stuff Great Legacy Price
> http://www.drbott.com/prod/db.lasso?cat=Seven+Cent+Deal

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listserver.themacintoshguy.com/pipermail/x4u/attachments/20100717/ed42d614/attachment.htm>