Archive for Mail Merge

SymphonyThursday: A LotusScript Mail Merge API Tip

April 15 2010

Here is a great tip for anyone working with mail merge in Lotus Symphony Documents 1.3 using the LotusScript API. One of the first things people want to do with automating mail merge is to automate just enough so the user can write a form letter without having to automate the whole process. Just get the selected documents, map the fields, and open the mail merge wizard/process. We do this pretty easily with Microsoft Word Mail Merge and the Mail Merge Wizard. Until now, this was not possible with Lotus Symphony Documents. The key is the ShowMailMergeSideBar function on the Mail Merge object. We (PSC) was using the document text as stated, and it was causing issues. The Sidebar would come up in strange ways and the completed merge would not have the field data. Totally strange. So before I reveal the solution, let's look at the documentation for the method: Method ShowMailMergeSideBar This method opens mail merge sidebar in Lotus Symphony. Be sure that the document is visible, othe

Lotus Symphony 1.1 has Notes mail merge built in!

August 29 2008

After all of those years of asking, we finally have Notes .nsf based mail merge. This feature comes from Lotus Symphony 1.1 (which will be included in the final Notes 8.5 final release). Here is a screen grab You can select any nsf file, and I selected a database based on the Notes Personal Name & Address book (Notes Contacts in Notes 8.X). It seems that it reads the Person document specifically, but I am already in the Symphony API and looking on how to build a mapping tool for custom contact forms in custom applications. Thank you IBM for this first great step! We need envelopes, labels, and a complete mail merge automation API in the future, but this is the beginning and it looks great!