Solved: Excel tables pasted on different pages in Word

[kathyb0527]

Hi everyone,
I'm just learning how to develop code, so I'm not sure that this can even be done. I need to take a table that will span several pages and paste it into word as a word table. However, the table title needs to be included on each page and cannot be a part of the table.

Thank you for any help you can give!


I just reread my own post and realized that it's very confusing. Let's try again. I have a very long excel table that needs to be pasted into Word as a Word table (it will span several pages). The table titles in the word document need to be included on each page and cannot be a part of the table.
I am thinking that I need to write something to split the table in Excel then use bookmarks (?) or mailmerge (?) to create a document.

Thanks for your input!