if I had 100 emails,and each one had a consitent field ie: version number and o/s. I would like to extract those two lines into a central csv database and so forth to be able to pivot the data in excel
eg: export details where:
version = and o/s =
the export tool in outlook doesnt accomodate this sop far, and sending to access doesnt work either.
any help would be awesome.
Answer by trueb · Oct 06, 2010 at 10:31 AM
well you could write a program to look for the information in the email you want... an email is like a text file, basically... so it can be done with the text file operations in most programming languages... i would choose C or C++... but i dont know of any way to do it in outlook directly...
Answer by r0bErT4u · Oct 06, 2010 at 01:58 PM
Managing Messages by Using ***Rules***:
Answer by Seb · Oct 07, 2010 at 11:06 AM
Download curl's IMAP implementation. Takes about 5 minutes.
Write code to retrieve emails. Test code by writing code that displays incoming emails to the console. 30 minutes? Less.
Comment out test code and place a comment to indicate that it's test code, write code (using regular expressions if possible) that parses the contents of the email and sends the desired content to a csv file. Another 30 minutes?
This is extremely optimistic, to the point where a competent programmer who has experience with C and/or C++ code might take about 15-20 minutes to hack something like this together. If you don't know C or C++ and you can't palm it off to someone else, I'm not sure how else I can help you. Hacking up Outlook just seems to me like a silly idea. Too reliant upon Outlook (which isn't really a bad thing, but isn't a good thing either).
Why Do I Have 2 Inboxes? 1 Answer
A baffling question... 3 Answers
Data Roaming iPhone iOS 4 2 Answers
NetWork between 2 PC's uses wifi data? 3 Answers