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

kjm

Joined
Apr 4, 2013
Messages
1
Reaction score
0
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!
 
Joined
Apr 20, 2013
Messages
4
Reaction score
0
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top