Mail merge, suppression of entire paragraphs
Posted on 2015-02-02
I am doing a merge into a Word document of data from an Excel spreadsheet. My merged Word document is formatted as a number list (say 12 numbered sections, each of which contains fields from the spreadsheet). I have no problems with doing this, but I want, as and when I require it, to suppress some of those numbered sections entirely. What happens at the moment, quite correctly, is that I produce a Word document with all the required fields putting the correct data into my Word doc., and all is well. However, I want, quite frequently, to only show say sections 1,3,5,6,7 and 9 on my Word doc. Although these sections will all have their fields correctly filled in from the spreadsheet, I don't want to show them in my Word doc.
Hope that's clear. So I feel I am now a dab hand at doing the fields, but I have no idea of how to automatically, and on my command (somehow) suppress these sections when I want to in Word, or even if it's possible. Is it possible, and if so, how? Oh, and maybe also renumber these paragraphs after suppressing the bits I don't want, so that the numbering is then, again, continuous, rather than having missing numbers 2,4 and 8.