How to Print a Specific Page or Sheet from a Word Mail Merge
Question details
The user needs to print a specific record, label sheet, or page from a completed Word mail merge document.
- Product
- Microsoft Word
- Device & OS
- not provided
- Scenario
- Attempting to print only the second page or a specific record from a mail merge document using standard page numbers.
- Observed behavior
- Typing a standard page number (like '2') in the print dialog results in a blank Print Preview or blank PDF output because mail merge documents separate records using section breaks rather than continuous pages.
Enable non-printing characters (the ¶ symbol on your Home tab) in your document to easily identify where 'Section Break (Next Page)' markers occur.
Print Specific Pages by Defining the Section Range
Since a mail merge creates a new section for each record, you can print specific records by typing the section number (e.g., s2) instead of the page number.
In mail merge documents, each set of labels or individual letters exists in its own separate section. Because each section may only contain one page, typing '2' in the page range looks for the second page of section 1, which doesn't exist. Instead, you must point the printer to the second section.
Navigate to the 'File' tab and select 'Print', or press Ctrl + P on your keyboard.
Locate the 'Pages' or 'Page Range' text box. To print the second record, type 's2' (which stands for Section 2).
To print multiple non-consecutive records, separate the section numbers with commas (e.g., 's2, s4, s7'). To print a continuous block of records, use a hyphen (e.g., 's3-s5').
Verify your printer settings and click the 'Print' button to output your selected merged records.
Print by Selecting the Current Page
If you only need to print one specific merged record, you can visually navigate to it and command the software to print the active page on your screen.
Easily Manage and Print Mail Merge Documents with WPS Writer
WPS Office provides a highly intuitive Mail Merge feature that lets you preview, manage, and print individual merged records effortlessly without having to memorize section codes.
- 1. Open Your Document: Launch WPS Writer and open your mail merge main document.
- 2. Access Mail Merge: Go to the 'References' tab on the top ribbon and click on 'Mail Merge'.
- 3. Connect Data Source: Click 'Open Data Source' to link your spreadsheet or address list, then preview your records.
- 4. Merge to Printer: Select 'Merge to Printer'. In the popup dialog, you can easily define exactly which record numbers you want to print without dealing with manual section breaks.
Frequently Asked Questions
Why does my mail merge print preview show blank pages?
Because mail merge documents separate individual records by generating sections rather than continuous standard pages. If you type standard page numbers in the print dialogue, the software looks for pages that might not exist within the first section, resulting in a blank preview and output.
How do I print a range of sections in a Word document?
In the Print dialog's 'Pages' field, type 's' followed by the section number. For a continuous range, use a hyphen (e.g., 's2-s5'). You can also list individual sections separated by commas (e.g., 's1, s3, s5').
How can I see where one section ends and another begins?
You can reveal section breaks by clicking the 'Show/Hide ¶' button on the Home tab. This reveals hidden formatting symbols, allowing you to clearly see the 'Section Break (Next Page)' markers separating your merged records.
