Form Mail data put into excel spreadsheet

  • Thread starter Brent E. Waldrep
  • Start date
B

Brent E. Waldrep

OK, I need some help.

I would even be willing to hire someone to help me with this project.

I have a few forms set up on my web site, they use the basic formmail
script. The data gets e-mailed to me, I then respond to the e-mail, and file
the e-mail in a folder in Entourage.

Now I have a few thousand messages, and need to some how get this info into
a spreadsheet so I can keep that data. For example. One main form that is
used, which can be viewed @ http://LBDSL.com/availablity.html , has phone
number name, e-mail, address info. I need this info put into a spreadsheet.

I found a program called Mail Convert 2.5.4 on apple's web site that is
supposed to do the exact thing I want, but I can't get it to work. If some
one can even just get this to work for me that would be great.

Any help would be great. Thanks

Brent Waldrep
[email protected]
http://LBTech.com
 
B

Barry Wainwright

It's an ideal application for parsing the message body with an applescript
and outputting a text file. You could even fire the script off by a mail
rule so that the data gets captured without any further input from yourself
at all.

Post an example of the format the data arrives to you in, and I'll do a
script for you.
 
B

Brent E. Waldrep

Thanks Barry,

Here is a sample of what the e-mail looks like:

Below is the result of your feedback form. It was submitted by
Name lastname ([email protected]) on Friday, August 01, 2003 at 07:36:40
---------------------------------------------------------------------------


Interested-in: Res. ADSL

areacode: 256

prefix: xxx

phone: xxxx

address: 123 anywhere st

city: Athens

state: Alabama

zip: 35614

submitButtonName: Check Availability

---------------------------------------------------------------------------

HTTP_USER_AGENT: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR
1.0.3705)
REMOTE_ADDR: xxx.xxx.xxx.xxx


The information I would want to keep would be:
Full Name
Email
Full Phone
Full Address (Street, City, St, and Zip)

Any help would be great!
 
B

Brent Waldrep

Barry,

Any luck coming up with a script that will do what I'm looking for?

Brent
 
Top