Hi, we have a peculiar situation. We have an application on our Domino Server which contains a huge list of details of contacts of our company. All the data is in a well-organized manner.
We want to use this data to compile a few letters using the “Mail Merge” Microsoft Word feature. Can somebody help me out? Is there any place where I can get the code to achieve this? Thanks in advance.
Subject: Mail Merge Notes data with Word
I saw the other posting which proposed you can export the data to Excel, then execute a mail merge from Word.
However, if you plan to mail merge the data in the Notes database more than one-time than I suggest to seamlessly integrate it for the end user. For example, the user would just open the Notes database, select specified or all documents, then simply click a “Mail Merge” button. If so, this requires a 3rd party add-on such as Print Merge Reporter.
http://www.notesmail.com/PrintMergeReporter
[
[
[Find the “crucial tools you need to succeed” including product descriptions, downloads, demos and testimonials.]
Speed up IBM Lotus Notes and Domino administration and development with these crucial software tools.
[Better, stronger, faster productivity for administrators and developers.]
Subject: mailmerge
What I’d do (assuming you’ve got excel as well), is set up an excel template for merging with a Word doc.
You can then export your contacts to excel, get a new word document based on that template (or prompt the user for it) and merge it using lotusscript (do a search, you should be able to find some code)