I have hundreds of forms submitted via email in which I need to pull certain form data from and place it into a excel spreadsheet. I have tried just about everything I can think of with Automator to accomplish this and admittedly I'm not even close to being a programmer, so apple script is a tad beyond me. 
I have these as .eml files, I have them as .txt files and I have them as .pdf files and I'll figure out how to convert them to whatever I need if someone can help me understand (like you're teaching a 3rd grader) how short of manually going into each email I can automate this thing. I feel like I'm overlooking something obvious but I can't figure out what. I've downloaded a whole bunch of things that only want to extract the email address - I want EACH line of the form into an excel spreadsheet so I can eventually get to putting a database together with it.
This is what the text of the email looks like (I've pulled identifying info out of it only....form wise it's what comes in.
----------
Received: from fmailhost01.isp.att.net (fmailhost01.isp.att.net [204.000.000.000])
by mx.perfora.net (node=mxus2) with ESMTP (Nemesis)
id 0LxyCS-1Nz2dC1t8m-015HAD for lg@xxxxx.com; Wed, 13 Jan 2010 15:29:14 -0500
Received: from [192.100.0.000] (adsl-215-208-195.aep.bellsouth.net[00.000.208.195])
by isp.att.net (frfwmhc01) with SMTP
id <201001131002oaope>; Wed, 13 Jan 2010 20:29:13 +0000
Return-Path: <inquiry@xxxxxxx.com>
From: "xxxxxxxxx" <inquiry@xxxxx.com>
To: <lg@xxxxxx.com>
Subject: FW: Availability
Date: Wed, 13 Jan 2010 15:24:16 -0500
Message-ID: <C7739620.D637%xxxxxxxxx@xxxxx.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="US-ASCII"
Content-Transfer-Encoding: 7bit
X-Mailer: Microsoft Office Outlook 11
X-Originating-IP: [68.215.000.000]
In-Reply-To: <20100113202228.5126019CC77@localhost.localdomain>
Thread-Index: AcqUjxIyqxaMLKPTROisPEmWPMOYqQ==
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.6578
------ Forwarded Message
From: <xxxxxxxxx@hotmail.com>
Date: Wed, 13 Jan 2010 12:22:28 -0800 (PST)
To: xxxxxxxxxxxxxxx
Subject: Availability
MESSAGE SENT THROUGH YOUR WEBSITE
This form was submitted: Jan 13 2010 / 15:22:28
by a visitor with this IP Address: 75.00.000.222
userid = inquire
name = mary
replyemail = xxxxxx@hotmail.com
departuredate = 02/25/10
#_of_nights = 4
adults = 2
Junior_(13-17) = 1
child2-12 = 2
childunder2 = 0
chkflightandresort = yes
departure_city = Other City - Type In Comments Below
Date_Not_Flexible = No
comments = ewr airport
Resort = Sheraton xxxxx Beach
------------------
Ideally I want to be able to que up hundreds of emails and have some script rip thru the emails for the obvious form pieces, pull that info and deposit it into csv format (which can easily be pulled into a spreadsheet) or even better right into a spreadsheet (not that I'm asking for the world or anything
)
I have these as .eml files, I have them as .txt files and I have them as .pdf files and I'll figure out how to convert them to whatever I need if someone can help me understand (like you're teaching a 3rd grader) how short of manually going into each email I can automate this thing. I feel like I'm overlooking something obvious but I can't figure out what. I've downloaded a whole bunch of things that only want to extract the email address - I want EACH line of the form into an excel spreadsheet so I can eventually get to putting a database together with it.
This is what the text of the email looks like (I've pulled identifying info out of it only....form wise it's what comes in.
----------
Received: from fmailhost01.isp.att.net (fmailhost01.isp.att.net [204.000.000.000])
by mx.perfora.net (node=mxus2) with ESMTP (Nemesis)
id 0LxyCS-1Nz2dC1t8m-015HAD for lg@xxxxx.com; Wed, 13 Jan 2010 15:29:14 -0500
Received: from [192.100.0.000] (adsl-215-208-195.aep.bellsouth.net[00.000.208.195])
by isp.att.net (frfwmhc01) with SMTP
id <201001131002oaope>; Wed, 13 Jan 2010 20:29:13 +0000
Return-Path: <inquiry@xxxxxxx.com>
From: "xxxxxxxxx" <inquiry@xxxxx.com>
To: <lg@xxxxxx.com>
Subject: FW: Availability
Date: Wed, 13 Jan 2010 15:24:16 -0500
Message-ID: <C7739620.D637%xxxxxxxxx@xxxxx.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="US-ASCII"
Content-Transfer-Encoding: 7bit
X-Mailer: Microsoft Office Outlook 11
X-Originating-IP: [68.215.000.000]
In-Reply-To: <20100113202228.5126019CC77@localhost.localdomain>
Thread-Index: AcqUjxIyqxaMLKPTROisPEmWPMOYqQ==
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.6578
------ Forwarded Message
From: <xxxxxxxxx@hotmail.com>
Date: Wed, 13 Jan 2010 12:22:28 -0800 (PST)
To: xxxxxxxxxxxxxxx
Subject: Availability
MESSAGE SENT THROUGH YOUR WEBSITE
This form was submitted: Jan 13 2010 / 15:22:28
by a visitor with this IP Address: 75.00.000.222
userid = inquire
name = mary
replyemail = xxxxxx@hotmail.com
departuredate = 02/25/10
#_of_nights = 4
adults = 2
Junior_(13-17) = 1
child2-12 = 2
childunder2 = 0
chkflightandresort = yes
departure_city = Other City - Type In Comments Below
Date_Not_Flexible = No
comments = ewr airport
Resort = Sheraton xxxxx Beach
------------------
Ideally I want to be able to que up hundreds of emails and have some script rip thru the emails for the obvious form pieces, pull that info and deposit it into csv format (which can easily be pulled into a spreadsheet) or even better right into a spreadsheet (not that I'm asking for the world or anything
)