PDA

View Full Version : Simple problem major blank help needed




kplain
Aug 24, 2006, 08:47 PM
I have a simple enough problem just not sure how or what I need to do in order to resolve it. I have a small fencing company and a web site which generates leads that are emailed to me. Those emails have first and last name as well as address, city, state, zip, phone and four other fields. The email is always the same except what is in the fields. Is there a way to use automator or applescript to extract the data and import it into excel or a filemaker database? I would be happy to provide anyone with a copy of the emails, or any other information you need to point me in the right direction. If you would like to write the applescript for me I would be glad to donate some cash for your time.



savar
Aug 24, 2006, 11:08 PM
I have a simple enough problem just not sure how or what I need to do in order to resolve it. I have a small fencing company and a web site which generates leads that are emailed to me. Those emails have first and last name as well as address, city, state, zip, phone and four other fields. The email is always the same except what is in the fields. Is there a way to use automator or applescript to extract the data and import it into excel or a filemaker database? I would be happy to provide anyone with a copy of the emails, or any other information you need to point me in the right direction. If you would like to write the applescript for me I would be glad to donate some cash for your time.

Why don't you post a sample e-mail here? Depending on the format this might be pretty easy to do with a shell script.*

*Hard to create an excel file, but easy to create a .csv file which could then easily be viewed in excel.