Data Mapping from emails to Excel

We need data extracted from e-mail forms put into an Excel file so it can be imported into a MySQL database.? Email body contains multiple fields that were completed on a web submission form that need to be separated so they can be imported into appropriate field in a new database.? A sample of one of the e-mails is included in the full description for this bid.? There are approximately 1,000 emails that need to be mapped and to fields in Excel. ## Deliverables We will provide a spreadsheet that maps which fields should go into the columns/fields in Excel.? Below is a sample of the body of the emails that will need to be imported.? From the below, there are approximately 20 items that will need to be parsed into a corresponding field in the Excel document - For example, the Excel file will need to have a column for: First Name, Last Name, Phone, City, State etc..? All 1,000 emails need to be parsed on the same rules and put into one continuous Excel file. Sample of email body: 01_first_name: Mary 02_last_name: Smith 03_age: 38 04_submit_by: <email@[login to view URL]> 05_home_phone: 407-555-1212 06_home_city: Miami 07_home_state: FL 08_home_zip: 32703 100_additional_info: I have done? many jobs.? Every store owner I have worked for has stated that I am the best promo person they've ever hired. I 11_Female: female 51_myspace1: 52_myspace2: 53_myspace3: 54_personal_site1: 55_personal_site2: 56_personal_site3: 57_college1: UCF, 58_cd_college2: 59_cd_college3: 95_car_at_school: yes 97_hobbies_interests: I am a runner. I work out at the gym 5 days a week.