WPS Office: Print One Excel Template Page for Each Data Row
Question details
The user needs to print a completed Excel-based template once for every data row without manually entering badge numbers or lookup values.
- Product
- WPS Office Writer and WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- An Excel worksheet contains one record per row, and each record must populate a separate copy of a printable template.
- Observed behavior
- The template values would otherwise need to be entered manually before each print job.
Make sure the first row of the spreadsheet contains clear, unique column headers and that each data row has complete values. Save the workbook in a supported format such as .xlsx before connecting it to the template.
Use WPS Writer mail merge with the Excel worksheet
Use this method when every worksheet row should populate one separate copy of the same template for printing or saving.
Mail merge treats the Excel worksheet as a recipient list. Each inserted merge field is replaced with the corresponding value from one row, creating one completed page per record.
Open the workbook in WPS Spreadsheets, place field names such as BadgeNumber in the first row, remove blank rows or columns from the data range, and save the file.
Open the template document in WPS Writer, then select the Mailings tab and choose Start Mail Merge. Select the document type and confirm that the template is arranged as a single printable page.
On the Mailings tab, choose Select Recipients or Select Data Source, browse to the saved Excel workbook, and select the worksheet or table that contains the records.
Click each location in the template where a value should appear, choose Insert Merge Field on the Mailings tab, and select the matching Excel column header.
Choose Preview Results to check several records, then select Finish & Merge. Create a merged document for all records or send the merged pages directly to the printer so each row produces one page.
Create and print personalized pages with WPS Office mail merge
WPS Office can connect a WPS Spreadsheets worksheet to a WPS Writer template, insert spreadsheet fields, preview each record, and generate one printable page per data row.
- 1. Prepare the worksheet: Open the Excel-compatible workbook in WPS Spreadsheets and verify that the first row contains field headers.
- 2. Start the merge: Open the template in WPS Writer, go to Mailings, choose Start Mail Merge, and connect the workbook through Select Recipients or Select Data Source.
- 3. Add fields: Use Insert Merge Field to place the spreadsheet columns in the correct locations on the template.
- 4. Print the records: Use Preview Results, select Finish & Merge, and choose the option to create all merged pages or send them directly to the printer.
Frequently Asked Questions
Can WPS Office print one template page for every Excel row?
Yes. Open the template in WPS Writer, connect the Excel-compatible worksheet through the Mailings tab, insert the worksheet fields, and use Finish & Merge to generate one page for each data row.
How should the Excel worksheet be structured for mail merge?
Put a unique field name in each cell of the first row, place one complete record on each following row, and avoid blank header cells or merged cells in the data range.
Can I print the merged pages without creating a separate document first?
Yes. After selecting Preview Results on the Mailings tab, choose Finish & Merge and use the print option if it is available in your WPS Office version. You can also merge the records into a new document and print that document.
Why are some badge numbers or lookup values missing in the merged template?
Check that the source worksheet is connected to the correct sheet, the field names match the headers, and the affected rows contain values. Reconnect the data source or reinsert the merge field if the header was changed.
