Hi,

Currently we are in the process of migrating lotus notes/domino to MS Outlook 2010.We have our have agent(coded using java notes API) running in notes that picks up mails from mailboxes and changes/updates a document property of each mail and creates an entry for that updated mail in sybase database(backend database for our application). Is there anything equivalent in MS Outlook 2010 so that we can build up an agent or will oulook 2010 supports the same agent code which we used in LN . Please help.

Hi,

I am not confirm whether there is a build-in function in Outlook without detailed. Could you tell me what is based on attributes to update/change the message properties via JAVA script?  

Generally, we may create a macro to achieve it.

Method 1: Load the JAVA note API library (dll) into macro to connect backend database.
BTW, what the kind of DB you use? SQL or Oracle?

Method 2: Code  VBA to replace the previous JAVA not API to touch it.

Visual Basic for Applications (VBA) in Microsoft Outlook makes it easy to control Outlook within Outlook itself. Using VBA in Outlook, you can create macros that perform complex or repetitive tasks automatically. You can also develop program code that responds to Outlook events, allowing you to automate common tasks (such as arranging windows when Outlook starts).

If you need more assistant about VBA coding, better to post your question to the forum for Outlook Developer
http://social.msdn.microsoft.com/Forums/en-US/outlookdev

For more detail about macro, please see the link:http://msdn.microsoft.com/en-us/library/aa209971(v=office.11).aspx

Feel free to post back, thanks.

Tony Chen

TechNet Community Support

• Edited by Tony Chen CHNMicrosoft contingent staff, Moderator Monday, March 26, 2012 6:27 AM
• Marked as answer by Tony Chen CHNMicrosoft contingent staff, Moderator Thursday, March 29, 2012 8:55 AM

Thanks a lot for your reply.

Below is what we do .

1.The Agent is scheduled to run every 5 mins.

2.A property"DocProcessStatus" in each mail is updated as "ProcessedDocument"

3.We have created a view which show the mails from inbox whose DocProcessStatus property is not updated. So every 5 mins,the agent picks up the mails from view and does step 2.

4.The processed emails are updated in database through JDBC connection . We use SQL for this.

So as per your suggestion,My understanding is either we can use macros or VBA in equivalent for our agent(we are using in NOTES now). please correct me if my understanding is wrong.

For a conversion of Lotus Notes to Outlook, you can checkout a very effective third party software from here http://www.howconvertnsftopst.convertnsftopst.biz/. it is very advanced software that easily moves notes data to Outlook PST format within seconds.