• Anonymous
  • Login
  • Register



MailMerge Excel to Notes - Discussion: Microsoft/Notes OLE integration

Created on May 19, 2011
Created by David Turner
Status
Open

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.




Documents
     
Creation Date
Author
Subject
May 19, 2011 David Turner Microsoft/Notes OLE integration
Jun 2, 2011 David Turner     Response: CSV Support Possible
Nov 27, 2011 David Turner         Response: Feature Request created
     
In this field you can enter the actual discussion topic.

You can use the rich text editor for rich text formating. You can also enter HTML to embed objects, e.g. to embed a YouTube video or a screenshot of the project. In this case use '[' and ']' to mark the passthrough HTML as such.

Please note that the first time you use the new UI your description is converted from rich text to MIME. You might want to copy and paste the raw plain text from the old UI in the new UI so that you don't loose information.