event managment

[Phil]

We have a non-profit summer school for about 500 pupils. We have an online form on our website which emails us sign-up details in the format:

SURNAME:
dskfjkds

NAME:
hsahdjkashd

AGE:
12

ADDRESS:
fdsfjhdsjkf

jdshfjkdshf

jdsfkljdsklfj

and lots more info, like parent's names, contact details, transport details, lunches, allergies, payements, etc. We could just print it, but it is really messy because the information doesn't fit on one page and the font is too small. Plus, once it's on paper it can't be manipulated further.

So, what smart things can Outlook 2002 do with that sort of email body? Can we put that into an Outlook contact form or address book form without copy/pasting it? Can we get it into a datbase?

For the life of me, I can't see what Outlook can do with the information in the email body, unless I pay an extortionate amount of money for a plugin which parses the email?

Also, I discovered that the email addresses supplied in the body cannot be clicked on and added to a contact/address book. Is that normal? The 'from' field has to be mailto:[email protected], so we need to easily retrieve the users address from the body of the messege; any ideas?

Cheers

 

[dlw]

those on-line forms are usually storing the data in some sort of backend
database format, maybe you can get it from there instead of the body of the
email?
If not, you really need to do that in the future, the format you are getting
it in is not very useable.

 

[Phil]

maybe you can get it from there instead of the body of the

email?

Thanks for your reply.

If I did find a way to get the web-form information stored into an SQL database (I'd need to learn some php to do that I think), could Outlook then connect to the database and copy the data into one of its own custom forms?

Cheers.