Email Processing - turn email output into a spreadsheet

-
One of the problems when I worked at PDG was the build up of a lot of emails in the Microsoft Exchange mailbox. There didn't seem to be a quick way to get all this information into a nice spreadsheet format for reviewing, processing and then sending to the client. We could also impress the client by sending a report from a backup of the emails when a database got corrupted.

So I tasked myself with creating an application to take the raw text file output from microsoft mail by hightlighting the emails and doing a "Save As.." into a text file.

Once the file has been produced it can be uploaded to the application which will process the file into a CSV that can be imported into a spreadsheet.

Example Data


This data was produced by selecting emails in MS Exchange and doing a "Save As.." into a text (.txt) file.

From: info@helsburypark.co.uk
Sent: 26 April 2011 18:30
To: info@helsburypark.co.uk
Subject: Helsbury Park Enquiry

Your Details... :
* Name : mr.anonymous
* Telephone : 07070707071
* Email : mr.anonymous@ntlworld.com
Address : 88 harley road
Address :
City : kettering
Post Code : pa14 1xa
Your Requirements... :
Preferred Property : Don't mind
Number of Adults : 2
Number of Children : Not Sure
Number of Dogs : 2
Holiday Month : August
Please Leave :

From: info@helsburypark.co.uk
Sent: 26 April 2011 18:12
To: info@helsburypark.co.uk
Subject: Helsbury Park Enquiry

Your Details... :
* Name : Ms A N ONYMOUS
* Telephone : 07070707072
* Email : a.n.ONYMOUS@googlemail.com
Address : 71 Stoke Road
Address : Fair Oak
City : Easleigh
Post Code : NO50 1AP
Your Requirements... :
Preferred Property : Don't mind
Number of Adults : Not Sure
Number of Children : 2
Number of Dogs : 1
Holiday Month : Not sure
Please Leave :


Data Imported Into Excel


Once the data has been processed into a CSV file you can then select "Data >> Import External Data.." from the menu options and select comma as the delimiter. It will then appear as below...


If you want the Project Materials for this application then please post me and I will send you the following:

  • Application Files (Classic ASP)

  • Example data to process

  • Log file of results


This application is still being used on the helsburypark.co.uk site.

Comments

Post a Comment

Popular posts from this blog

Knowledge Bomb eXperiment - books not bombs!

-
Image
Inspired from a bag with the image "Books not Bombs" - a real experiment that could be tested in the real world. Pick a war, any war then drop books instead of bombs, drop knowledge instead of destruction, drop help and remove fear, drop equipment (microscopes, telescopes) to investigate the world rather than destroy it ... The amazing thing about this thought, this idea is that it can be tried now, today, at this very moment and the results can be checked. Military still get to fly sorties and dodge missiles, but the bombs hold knowledge of this world to help them improve their lives - from the greatest writers of our time. I would rather see depleted books lying around rather than depleted uranium! Contents of a Knowledge Bomb? William Li: Can we eat to starve cancer? https://www.ted.com/playlists/181/the_most_popular_science_talks A 50-cent microscope that folds like origami https://www.ted.com/playlists/2/tech_breakthrough The Knowledge: How to R...
Read more

Chalkboards for Learning

-
Image
Whilst living on a boat we had to create areas of interest for our daughter Mia to play in. When creating a doorway to cover the hatch exit we covered it in chalkboard paint so it could be used for lot of different things: Learning to draw and write with Mia Writing notes Leaving messages for other people So I say we can take this idea further just like in the image below and have chalkboards on every childs bedroom wall. Providing a fun learning area that is reusable and cheap to get up and running. I think this should be supported by governments and companies as a cheap and fun way to teach children and provide them with an area of creativity. So a simple kit would contain the following: enough paint to create a 2m x 2m square paint brush instructions on how to use the new "chalkboard for learning" chalk to last for a month sign up to receive a quarterly newsletter on activities for the chalkboard Number counting with Rainbow Dash ...
Read more

A Garden Zoo with Friends

-
Image
After moving house and collecting a lot of cardboard packaging - what to do with it all? Straight down to the tip? Well the first load went that way and then I thought, hey maybe I can do something with this stuff? So 30 minutes later with my daughter insisting on helping me we had a larger than life "Upsy Daisy" and a "Snap Happy Annie" Crocodile in the garden made from cardboard packaging from Ikea . These look great and our little girl couldn't help but drag the 2d characters around the garden and gave them great big hugs.   Could this be taken further - maybe drop some characters in a park (nice ones only please). Build a Zoo in the city? Not too many now or else the cardboard will get everywhere but for special occasions and fun.
Read more