Forum Discussion
Report text data from Microsoft Forms
Hi ExcelAthlete
TBH I'm not clear re. what you're asking - might be due to my lack of knowledge of Word's MailMerge functionnality
The following is a quick and dirty Power Query approach that does "This is the text of a report that won't change and should only be once at the top of the document"
(see attached file) Does this help?
Hi!
Thanks a lot for your reply! Technically the list would be what I'm looking for. By "technically" I mean the data itself is there and in the right order as well but I need to be able to format it similar to how I could do it in Word. The "Feedback" can be a few hundred words in multiple paragraphs so having this in Excel will make it unreadable. Furthermore I already have a report in Word that gets populated by hand but is way too cumbersome to deal with. Sorry I should've maybe mentioned this in the beginning.
What the Word "Mailings" function essentially does is enable you to set up a "template" that gets populated with data from an excel sheet over and over, but unfortunately it seems very inflexible. So I wanted to know if there's some other way before taking my question to the Word forum.
- LorenzoApr 19, 2023Silver ContributorNot sure I can help you further with this :(( - Sorry