FAQ
How can we help?
Full Site Search

Print documents with fixed title and page numbers on each page

Too many Subtable records in an entry may cause the print layout to extend across multiple page. If you want to display specific parts of the sheet (e.g., the title field and page number) on each page, you can use the Mail Merge tool and configure the "Page Layout" in the Excel template or use the Word's Custom Print Report feature with "Repeat Header Rows" setting. This allows you to define which elements appear on each printed page.

For example, this purchase order will generate multiple pages when printed due to the large number of purchase details.

Mail Merge with Excel Features

To print documents with fixed title and page numbers on each page, first download the record’s Mail Merge sample template in Excel. In the file, navigate to the "Page Layout" top bar option, choose "Page Setup" > "Sheet" > "Print Titles" to select the rows and columns you want to show on each page. After everything is set, upload the template back to Ragic.

To set up page number on every page, go to "Page Layout" > "Page Setup" > "Header/Footer", and select your preferred page number format.

Remember to upload the modified template back to Ragic and set it as a mail merge action button (shown in below image). By doing this, you will have the same template format the next time you export the records.

You can print it after you download the record through Mail Merge.

The page number and title are shown on every page as configured.

Custom Print Report with Word Features

Custom Print Reports use a Word file as the template. After downloading the sheet’s print template, follow these steps to configure the Subtable to display a fixed title on each page.

First, adjust the template file as needed. Select the header row of the Subtable, then, from the toolbar, click "Table Layout" and choose "Repeat Header Rows".

You can also click "Insert" and select "Page Number" to add page numbers to each page.

Once the adjustments are complete, save the file and upload the modified template.

After downloading the report, the Subtable will display the fixed title on each page.

Top of Page

    Start Ragic for free

    Sign up with Google