I am trying to put the results of a questionnaire in a Word document.
The questionnaire is completed using a web application, and the results are stored in a database. The letter needs to only include those questionnaire results that are deemed unsatisfactory, so the number of results varies. The results that need to be on the letter can be easily exported to an Excel spreadsheet. The table is something like this.
Question | Answer | Reason
====================================================
Is the project up to code? | No | Plans missing.
Has payment been made? | No | Cheque returned, NSF.
How can I display the information as paragraphs inside of a Word document? Something like this.
Dear So-and-So,
The results of your questionnaire are as follows:
No - Is the project up to code?
Plans Missing.
No - Has payment been made?
Cheque returned, NSF.
Sincerely,
The Administration
When I use Mail Merge, I end up getting a separate document for each questionnaire item. I could insert in the <<NextRecord>>
merge field, and duplicate the other merge fields, but still, multiple documents are generated, and unless there are the right number of copied fields, blank rows are made, or data is missed.
Is there a way to do a Mail Merge, inserting an unknown number of items into the same document? The result could either be a table or a series of paragraphs. Some sort of Mail Merge loop would be awesome!