Parsing Information in an email message in outlook to excel
Posted on 2003-02-22
I am currently using Office XP.
I have been receiving emails that follows a certain format regularly through a POP mail system. In the emails there are certain fields which i would like to extract and place into an excel spreadsheet. I would like to write a program that will check the mailbox for unread emails, and parse the required fields from new emails into the spreadsheet.
I have a little experience in programming in excel VBA but i am totally unfamiliar with the outlook object library. Hence, I would appreciate it if someone can provide me with the directions i should take to reach my objective. I do not need a sample code but rather, i need to have assistance on how do i approach the problem and the keywords (ie Outlook methods or properties as well as how to insert the fields into excel from outlook) that i should look up on.