Import Oracle data into word template
Murthy, November 29, 2017 - 5:51 am UTC
For following reasons I believe this solution is just good enough but not elegant.
1. This introduces one more step - creating and populating access database
2. Mail merge wizard itself has lot of limitations. For example. it doesn't support population of multiple rows into a single document
I propose the following solution.
1. Create XML from SQL query using XMLElement
2. Populate that XML into MS Word template using document generation tools
The whole process can be automated by integrating with REST APIs of document generation software.
December 01, 2017 - 2:52 am UTC
If I was going for a full blown solution I'd possibly look at BI Publisher as well