Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Email to Excel data
Name: Perttu Date: December 9, 2003 at 23:52:21 Pacific OS: XP CPU/Ram: Duron 1300 / 512 SDRAM
Comment:
Hi,
I have answers to web survey in my Outlook Express Inbox. Messages are like this:
VAR1 = First Name VAR2 = Surname VAR3 = Sex . . .
Now I would like to create statistical data with variables in columns from these email messages. SPSS or Excel format. How to do the trick, any ideas? Thank you for you comments.
Name: Taxi Date: December 10, 2003 at 01:04:32 Pacific
Reply:
Copy all to a text file and next import it in excel, usin conversion tool.If u open a .txt file with xl, conversion tool is auto launched, and u can define ur columns.If prob, send a sample
0
Response Number 2
Name: Perttu Date: December 10, 2003 at 02:00:13 Pacific
Reply:
Thanks, but there are so many of them that I would prefer more automatic way to process all the messages.
0
Response Number 3
Name: Paul Buyers Date: December 12, 2003 at 11:15:51 Pacific
Reply:
At work we do similar conversions, What our guys tend to do is write a batch file in dos that reads a txt file then cuts required parts out of the file eg line 1 characters 6 -15 which would be "First Name" then compiles this info in a new txt document or even email you the document. Draw back is I do not know ho to do it myself but I am sure some of the DOS guy's in the dos forum would.
Hope it helps a little.
0
Response Number 4
Name: Paul Buyers Date: December 12, 2003 at 11:17:27 Pacific
Reply:
also note on the above, the batch file can be set to run at any time or times eg every hour.
0
Response Number 5
Name: bronson Date: December 16, 2003 at 17:18:43 Pacific
Summary: I am exporting my emails from Outlook to excel, and it is almost fine, but the date (received/sent) doesn't come along. Only these fields: Subject Body FromName FromAddress FromType ToName ToAddress T...
Summary: Hi We have a file on MSword using tables, and I want to export one of the column called email to excel so I can save it as a space format to import into yahoo group email list, or even better export s...
0 
