I want to read the emails from lotus notes into a database. First I tried using MAPI. At the beginning I encountered some problems in configuring the MAPI Client for Lotus Notes and finally got it working. But now my problem is, I can't get the subject or attachments. (Those fields are not populated at all!)

So I tried the OLE Automation method and it is working where I can get all the fields and data. (Still I have couple of problems in finding the mail box the mail item comes from and detaching the attachments.) Another problem in using OLE is we need to maintain two separate programs (MAPI - for Outlook & OLE for Lotus Notes) as well.

I want to know some comments on which is the better way to proceed in a long run.