How do i turn 300 e-mail replies into an Excel spreadsheet?

Problem- my work has about 300 replies to a questionnaire that is hosted on our website. The each response comes as an e-mail which we receive in outlook.





Rather then us manually uploading this data into an excel spreadsheet, is there a way of scripting this process?

How do i turn 300 e-mail replies into an Excel spreadsheet?
It would have been smarter to perform the questionnaire by a dedicated program that processes the emailed answers (many programs available).





Since that was not done, I would suggest a workaround: use MacroExpress - it's a shareware.


http://www.macros.com/
Reply:search the web with key words.
Reply:i was gonna suggest copy and paste until i seen "not manually". other than that i have no idea.
Reply:I love answering impossible questions. This is how I earn the most points. The answer is simply to locate websites that provide customers with "freelance coders". In effect programmers who are jobless and willing to work dirt cheap. I bet for about $80 you can have one of those guys code you a script that will do what you need. :-) Have a nice day!
Reply:It can be done...Probably PERL is your best bet.


How hard it will be depends on how standardised the responses are...If they are in a CSV (comma separated value) format (Answer 1,Answer 2, etc) then it will be easy...If not then it gets harder...


It would be easier to answer this question if you put an example e-mail to show the received format...