Not sure how to split Outlook Body Text to Single Cells

Hi, thanks to google I have managed to find some code to enable me to extract emails to transfer the data onto an excel spreadsheet. I would like to take this further by splitting the Outlook Body Text into individual cells but not sure how. The following is my current code:

Please Login or Register  to view this content.

Currently the outlookmessage.Body is pasted into 1 cell, but the following is an example of how the email body looks like:

1) Please select type of change:

Temporary

2) Please complete:

Name:
Humpty
ID:
12345678
Reason for Change:
Plan Leave
Current shift:
08:00 - 17:00
Date of Change:
16/10/12
End date if applicable:
16/10/12

If somebody could please advise me or if there are any tutorials, as its all well, somebody writing this for me, but I want to make sure I learn at the same time as to how what the code all means.

Thanks in advance.

Hi,

Is the mail body always contains data like above? More clearly, do you always get Name:, ID:, Reason for Change: etc. etc. ?

If yes then the same can be done in excel itself.

Let us know so that we can help.

Regards
taps

taps, thanks for your response. The mail body will always contain data in the same format, as its a form that is filled out and I am trying to extract the information to the separate fields.

Btw, ideally I am looking only to only pick up the answers, so not sure if the text from the body would need to be defined as keywords. i.e. Name, ID, etc..

Thanks