Losing Records When Using Response.ContentType Msword.

I have a problem in that i have a page that works fine and shows all records/Output until i add Response.ContentType=msword

And then i only show every other record.

I probably should have coded the page differently. But for context - it's a school report system and i have setup a Subroutine which queries a database and builds a summary report for a girl. I wanted to print out a class list of these. I.e one for each girl in a class and so i loop around the results of one recordset and within each loop make a new query and create the report. This is probably not the best way to do it.

Anyhow, in the browser it woorks fine. As soon as i add the code to output it to word (or excel ) i lose evry other report.