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

A Lasting Grand Design

-
Image
We have only had our allotment since end of last year (Nov/2014) and have learnt that to get the most from the allotment requires a lot of time, energy and effort - sometimes to get minimal returns.  But gardening in the evening watching the sunset, picking the weeds knowing you will see them again, chewing on a broadbean picked freshly and mostly seeing the fruit and vegetables grow is possibly the most rewarding thing that has been given to all of us.   This is a suggestion for a Lasting Grand Design Project for Kevin McCloud of Grand Designs fame, the legacy of a great programme... ... let’s turn prisons into gardens! 46% of adults are reconvicted £36,808  Annual cost of a prison place 1994 Overcrowded in every year since 84,305 Prison population When it can be said by any country in the world, my poor are happy, neither ignorance nor distress is to be found among them, my jails are empty of prisoners , my streets of beggars, the aged are not
Read more

Reuse vs Recycle

-
Image
Creating "stuff" takes away from the planet, makes big holes that will only be filled with plastic and clutter. So why not try and reuse where possible? We could change our habits so we are more prone to reuse items rather than recycle or just throw away. What to do with wine bottles? An example is a wine bottle, rather than use it and then put it into a recycle bin where it is broken down and then reformed into another bottle (but less pure) why not send the bottle back to the original supplier who can reuse it? I see some social responsibility of returning boxes/bottles/packaging to the original store where it can be returned to the supplier for reuse. Who's with me on this? Who can make a big difference? Recycle gives the responsibility to other people. Reuse gives you the power to make a big difference now. If you think this is a great idea and want to start something then let me know and let's get started.
Read more