Define specific page breaks when printing to PDF

D

Daniel Uribe

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 numberof 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Images are pixelated when saving to PDF 0
Problem with printing a word document containing a table 0
How to paste this down? 3
Converting excel to PDF, single page converts to multiple HELP! 1
Loosing transparency effect of Master Page graphic when Saving Publisher files as .pdf 0
Publisher adding blank page when printing my booklet... 2
hide progress bar when using ExportAsFixedFormat for printing to PDF 1
Columns appearing from nowhere, formatting going weird 0

Top