Hello,
I have Word template(s) that I would like to use to merge Lotus Notes documents data into based on user selection as a programmatic client feature. I have seen some older examples and one that I have done in the past using tags. Is something like this still the best solution to accomplish or are other examples available?
I have a workable solution using Word templates. I use bookmarks in the Word template that I populate based on a settings document that matches the Notes data field(s) to the Word Template bookmark(s).
You could do it that way, or give the user a selection method that allows them to choose from a list of Notes fields that are then matched to the Word bookmarks.
Just be careful - Word does not like handling bookmarks in Headers and Footers but there is a solution out there (check the MS Forums for sample VB code, or use the Macro editor in Word to figure out what is going on when you add a bookmark to a Header or Footer in Word.)
There are commercial products available (Integra for Notes), but they are pricey and probably overkill for your project.
Good luck!
Hi William.
John's response is great. But I like to learn by seeing examples of how it might be done.
1. Drive from Domino (OLE basically)
Below is an example of using a MS DOT (template file) and a scheduled agent, whose purpose to do calendar merges for our old Lotus Notes users group:
https://www.mindwatering.com/SupportRef.nsf/all/f9048852fc8448e785256aa70051d6c5
2. Drive from VB Script running w/in Word (Domino COM access):
https://www.mindwatering.com/SupportRef.nsf/all/6ef8cfd497388c8f8525728f007af41a
We used this second option, to add code in MS Word to populate forms/documents, and then afterwards, check documents back into Notes Teamrooms, Domino.Doc, and Quickr.
We don't these as often since so much is just web and mobile (smaller web) these days. Most of our current work classic Domino web (browser) apps, and external web apps pulling Domino data via REST APIs.
Hope these are helpful.
Regards.
Tripp