Exporting from Outlook

[ajw150]

Hi,

New to this site, but hope you can help.

I have a batch of emails that have been produced as online forms. The user completes the form on the website, presses send and it is emailed to my account.

The data is all held in the body of the email.

Is it possible to export this data to either excel or access and have the data split down into headings and entered into different cells.

For example, I receive the following:

Email body:

The following information has been submitted:

Subject: abcdef

-------------------------------------------------------------------

Name of applicant: abcdef

Position: heal

Name of workplace: abc

Type of business: abc

Address:etc

Postcode:

Telephone number:

Email address:

-------------------------------------------------------------------

Please indicate what support you require from our services:

a

b

c

How can I split the text into parts and have seperate cell lists for name, address, postcode etc.?

Hope I have explained this ok.

really appreciate any assistance.

thanks

Andrew