Formatting Text from email to Excel

[njlife]

Ok this is probably a dumb question, but asking you guys is my last resource.

I am web editor for a magazine. For contests, we have a html web form for users to fill out on our website with their information. It comes to us through email with the following fields:

Name
Address
City
State
Zip
Phone Number
Email

The information from these thousands of emails have to put into excel spreadsheets, with each column heading being each one of the above. For months I've been just dragging and dropping information, line by line, from each email into its respective column on the spreadsheet, but I'm wondering if there is an easier way? Is there a program? Is there a special formatting tool in excel where I can copy and paste ALL the content from each email and have it go to the right column, rather than having to drag and drop text line by line?

 

[tusharm]

You could probably write a VB(A) routine to do the needful -- or hire someone to do it.

But, more interestingly, what does it mean to assign a 5 star rating to a discussion with just the original question?

 

[Norie]

Why does the form come by email?

I'm pretty sure there's software out there that can take data from a form when it's submitted and put it into some sort of database.

 

[njlife]

You could probably write a VB(A) routine to do the needful -- or hire someone to do it.

But, more interestingly, what does it mean to assign a 5 star rating to a discussion with just the original question?

More interestingly? I'm not surprised that in a forum like this that you would focus on something silly like that instead of just answering the question with a simple response and leaving it at that. I did it hoping to get a faster response. Sorry that I don't know the forum "rules". And I don't see how "hire someone" answers the question at all.

 

[njlife]

Why does the form come by email?

I'm pretty sure there's software out there that can take data from a form when it's submitted and put it into some sort of database.

We have a company that does the backend stuff for our site, and thats just the method they chose for some reason. But thanks for the response. I kept focusing on a solution to the excel problem and I never looked up a program to put data into excel format.

 

[Norie]

Want you want to do probably is possible using Excel VBA.

But there a lot of other factors to consider.

Firstly, what email client are you using? If it's Outlook or Lotus Notes it maybe possible to use automation to extract the data.

Also is the structure of the data/emails uniform?