I know that it is possible to generate a word document from a list, but what if I need data in my word document from two lists?
I can create a linked data source which combines the two lists, but I have not seen any example on using the linked data source to create a word report. The list relationship is one-to-many, so the first list has header information, while the other has item information.
Can someone point me in the right direction for this? I’d like to do this without any libraries such as OpenXML etc.
Thanks, Ola
You can create a document template in a document library and use quick parts. To create a new document you can use a SharePoint Designer Workflow. I used it to create training certificates automatically.
I hope this gives you some inspiration:
http://www.sharepointsapiens.com/blog/create-training-certificate-sharepoint-automatically/
