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?
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
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?