|
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. cheers |
|
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... |
|
Managing Messages by Using Rules: i already have a rule to put what I want into a pst. if i can expand on this a little. 100 emails, all of them have 5 lines of data and a lot of other stuff. i need to extract these 5 lines and only these into excel. |
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). |
What are you trying to accomplish?
im try to accomplish. the emails are error reports, that have the database version, o/s and software verion in it. Ideally i would like this to be extracted into excel, giving an accurate view of who is using what. without having to manually copy and past the data out from each error 9there are hudreds of them )
-thanks