Excel How do you export e-mail content into an excel spreadsheet

[kjm]

We are holding an event, and people will register for the event online by filling out a form. The answers will be directly sorted to a folder in outlook named "Softball" I would like to create a spreadsheet that will automatically take this info using VBA or a Macro. However, I have never done one of these before.

Here is a sample of the email

The submitted value of field named "Name" is:
-------------------------------------------------------
Karen
-------------------------------------------------------

The submitted value of field named "Age" is:
-------------------------------------------------------
Over 21
-------------------------------------------------------

The submitted value of field named "Club Number" is:
-------------------------------------------------------
2222
-------------------------------------------------------

The submitted value of field named "Club" is:
-------------------------------------------------------
PRC
-------------------------------------------------------

The submitted value of field named "Cellular Number" is:
-------------------------------------------------------
555-555-5555
-------------------------------------------------------

The submitted value of field named "Email Address" is:
-------------------------------------------------------
(e-mail address removed)
-------------------------------------------------------

The submitted value of field named "Guest's Name(1)" is:
-------------------------------------------------------

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

The submitted value of field named "Guest's Age(1)" is:
-------------------------------------------------------

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

If anyone can help that would be great. Thanks!

 

[rich_value]

Why use excel / vba for this. PHP or other scripts have very interactive forms and database to save valuse as you want with strong validation. You should recheck it dear.