Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

kplain

macrumors newbie
Original poster
Aug 24, 2006
1
0
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

macrumors 68000
Jun 6, 2003
1,950
0
District of Columbia
kplain said:
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.
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.