Excel to generate reports in Word
 

I want to use Excel to generate reports in Word.

Column A contains text.
Column B contains Y or N.

If B1 contains a Y then put the contents of A1 into a new word document.
If B2 contains a Y then put the contents of B1 onto the next line of the
same word document.
If B3 contains a Y then put the contents of B3 onto the next line of the
same word document.

Obviously where column B contains an N, I don't want the contents of column
A on that row included.

It seems highly likely that someone has written some code to do this
already, so I'm asking for help here.


--
Regards,
David