• Microsoft/Notes OLE integration

    By David Turner 1 decade ago

    The MailMerge function relies upon OLE.

     

    Here is an IBM DeveloperWorks Blog on how the OLE "Excel.Application" component integration works in Notes.
    http://www.ibm.com/developerworks/lotus/library/notes-ole/index.html

     

    Effectively, Notes LotusScript, similar to Macros written in VB or VBA, can access properties and call functions on these OLE applications which are spawned in a child process. Notes keeps a pointer to the application in a LotusScript 'Variant' variable, and the process should be quit once it is no longer needed.

     

    APIs for the OLE functions are quite readily available, and easily translated for LotusScript from VB.

    • CSV Support Possible

      By David Turner 1 decade ago

      I'm thinking I might make a version of this project which will directly support CSV files, without any Excel OLE dependency.

       

      The MergeXLSpreadsheet object interface could be reasonably readily adapted to an equivalent MergeCSVSpreadsheet processor using: a NotesStream, a line-reader, 'split' or other string tokeniser, and a small amount of caching to improve performance.