Define specific page breaks when printing to PDF
 

Hi, I've been trying to find a solution to this but nothing seems to work.

I'm populating an Excel page to automate a report that contains several standard cells and at the end a variable length table.
I tried to define this report using mail merge with Word, but the table is the problem, so I simply created a worksheet in Excel that used the information from other sheet and filled up (including the variable length table) and then printed the result to PDF.

For short tables, there is no problem, but for long lists the PDF is created in a single page, making it really hard to read anything in it.

I have tried using FitToPagesTall, which separates the result in the number of specified pages, but since I want the labels of each column at the beginning of each new page, it does not work well, since it creates the page break wherever it seems fit.

For printing to PDF I'm using ExportAsFixedFormat

Thanks,

Daniel