MS Access Client: LotusScript/COM/OLE to Web Access
Posted on 2005-04-15
We have a number of Access applications that include VBA code to reference LotusScript objects to carry out 2 main functions:
1. Search all available Lotus Notes Address Books for a particular name and return all matches. This functionality opens each of the ADDRESSBOOKS attached to the current Notes SESSION, then through the "people" VIEW cycles through each document to see if the name matches the search criteria, and if so the First Name, Middle Initial and Last Name, and the
FullName or MailAddress or ShortAddress are returned to be inserted in a list for the user to select from.
2. Send Email including attachment(s) if required. This functionality opens the default mail database within the current Notes SESSION and creates a new mail Document. If attachments are required these are attached to the document. Values are set for Subject, Body, SendTo, DeliveryReport and SAVEMESSAGEONSEND is set to true. The document is then sent.
The intention is to allow the sending of emails from within the application without having to switch applications. We did not use the SendTo method in Access because it insists on bringing up dialog boxes to select which Outlook Profile to use etc.
The users are now planning to move up to Domino 6.51 and away from the client version, preferring to go down the Web Access route. I would welcome any suggestions on how we can best replace the existing functionality that relies on the Lotus Notes client being on the PC, with similar functionality that does not.