Extracting Email Details

Dear all,

Firstly, thank you in advance for any help you can give me with my problem.

Ok, I run the office of a small travel business, and have written a scripted form on our website so that the public can submit their details to enquire further about our various packages.

There is a script embedded into the website that grabs all of this data and emails it to us in the following format (anything in BOLD refers either to details the customer has entered on the form, or to private information):

From: CUSTOMER NAME [mailto:CUSTOMER EMAIL]
Sent: WHATEVER THE DATE IS
To: OUR COMPANY NAME
Subject: Booking Request

Customer Name = CUSTOMER NAME
Telephone No. = TELEPHONE
Email Address = CUSTOER EMAIL
No. of Adults = NUMBER
No. of Children = NUMBER
Earliest Departure = DATE
Latest Departure = DATE
Departure Airport = AIRPORT
Duration of Stay = DURATION
Preferred Area = AREA
Board Type = BOARD
No. of Rooms = NUMBER
Other Information = INFO

Now this section works perfectly, and the enquiries come into our inbox without a problem, and are diverted to a seperate folder called Sales.

Now the problem...I have just been asked by the company director to build up a list of all the customers who have used the enquiry form, together with their emails, telephone numbers, and number of adults enquired about.

Now all the emails are stored in one folder (Sales), and are fine. I can use the Export function to get an Excel spreadsheet, but that doesn't give everything I need (essentially, it automatically puts in columns for subject, from name and from email).
Extracting the name of the customer and their email address is easy, since the emails come in as being marked from whatever name the customer put into the Name box on the form, and from whatever email address they put in. I can therefore easily use Export to get a spreadsheet of names and addresses. What I can't get, and the crux of my problem, is any of the information from the bulk of the email. I want to arrange something that would, for example, automatically grab any information after the "Number of Rooms = " section of the email, and put it into its own Excel column.

Is this possible?

 

Since the only place you have descrete chunks of information is on the web site, you will probably have to capture what you need at that end and package it so you can extract the information you need.

The way your email works with the body being just a long character string makes using the email itself nearly impossible to do what you want. I say "nearly" since the only ways I could think of would require manual coding and I'm sure that isn't what you are after.

As to any method of doing the existing emails automatically, nothing comes to mind immediately. I'll think on it a while. Hopefully someone else will be able to offer a suggestion.