I have a table which spans several pages and contains a header row, set to repeat at the top of each page. I need to convert this to text in a VBA script, but it doesn't keep the header rows when this happens, and I don't see any options to do so.

Is there any way to convert a table into text and have the header rows on each page included in the text?

Alternately, is there a way to achieve this without using a table? (Note - the header text on each page has to be part of the body of the document, I cannot put the header text in the header/footer)