I have a little challenging task. I gotta open outlook from my vb code, go to the inbox folder, and pull out an email sent from an oracle database containing daily stats. Then I gotta parse that email. I started with opening outlook...but none of the 2 or 3 code snippets i got from internet worked.
My main qs is how should i approach about parsing the email. The email format is same and looks like following:
Report of Act/Deactivations
Report of Total subscribers on 2004-10-19
Report of Activations done on 2004-10-19
Report of Activations done on 2004-10-19 by hour
Report of Acttivations done on 2004-10-19 by site
I need to store values of Total Subscribers, Activations done and activations done by hr into vb variables.
So what should I do, should i copy email to some text file (i dont know how to do that) and try to parse it or is there any way to directly extract data from the outlook and store them into vb variables.
Has anybody came across something like above before.
Any help would be appreciated,