How to print mail merge letters from Word on any office copier

TutorialWord workflowAll sectors12 min read

A mail merge from Word turns one template letter and one spreadsheet of recipient details into hundreds of personalised letters in minutes. The print step at the office copier is the final five percent of the work; the preparation in Word and the test cycle determine whether the output ships cleanly or wastes a ream of paper.

The nine step workflow

1

Prepare the recipient list as Excel or CSV

Each column is a field (first name, last name, company, address line 1, postcode, etc.). Each row is one recipient. Keep column headers descriptive; Word displays them during merge field selection.

2

Save the recipient list and close the file

Word locks the data source while the merge is active. Closing it in Excel beforehand avoids a "file is in use" error during the merge.

3

Open or create the letter template in Word

Type or paste the body of the letter as it should appear, with placeholders where personalisation will go. For example, "Dear [Recipient]" with [Recipient] marked for later replacement.

4

Open Mailings > Start Mail Merge > Letters

Word switches to mail merge mode. The Mailings tab options become active. Other tabs remain available; the merge does not lock the document.

5

Click Select Recipients > Use an Existing List

Navigate to the Excel or CSV file. Word displays a sheet selection if the workbook has multiple tabs. Choose the sheet containing the recipient list and confirm.

6

Insert merge fields at each placeholder

Click into the template at each placeholder. Click Insert Merge Field and select the matching column. The field appears as «FieldName». Repeat for every personalisation point.

7

Preview Results to confirm a few records look correct

The Preview Results button substitutes the first row's data into the template. Click the arrows to step through several records and confirm all personalisation lands correctly.

8

Click Finish & Merge > Print Documents

Word generates one letter per recipient and sends the whole batch to the printer. Confirm the printer selection in the dialog and choose duplex if appropriate.

9

Use pull printing if the office has it

Mail merge batches contain recipient names and addresses. Pull print release at the device keeps the batch private until released, useful for sensitive merge data.

Why "Edit Individual Documents" is the safer intermediate step

Instead of sending directly to print at step 8, choose "Edit Individual Documents". Word generates a single Word file containing every personalised letter, one per page or section. You can review the full output before printing.

For first time mail merges, always use this route. The review catches missing data, wrong field positions, or address blocks that overflow the window envelope. Once the output looks correct, send the consolidated document to print as a normal Word file.

Common mail merge field expressions

Field needWord expression
Full name from first and last fields«FirstName» «LastName»
Formal salutationDear Mr/Ms «LastName»,
Conditional salutation by title{ IF { MERGEFIELD Title } = "Mr" "Dear Mr " "Dear " }«LastName»
Date formatted as long Spanish{ DATE \@ "d 'de' MMMM 'de' yyyy" \* MERGEFORMAT }
Conditional content if field empty{ IF { MERGEFIELD Company } = "" "" "«Company», " }

Settings for the print run

For most mail merge runs to office MFP, four settings matter.

Paper source

Letterhead in dedicated tray, plain paper in main tray. Confirm Word's print dialog picks the letterhead tray for the first page if the template uses a letterhead overlay.

Duplex

For multi page letters, enable duplex if the device supports it. Single page letters do not need duplex. Confirm the duplex binding edge matches the letter style (long edge for portrait letters).

Print order

By default, Word prints letters in recipient list order. For posting in alphabetical batches, sort the recipient list alphabetically before merge.

Output organisation

Most office MFPs collate by default. For mail merge of single page letters, collation is irrelevant. For multi page letters, confirm collation is on so each recipient's pages stay grouped.

Combining with window envelopes

Mail merge pairs naturally with window envelope addressing. Position the recipient address block in the letter at coordinates that match a DL or C5 window envelope. When the letter folds, the address appears through the window.

Standard DL window envelope target position:
Left margin: 25 to 30 mm
Top margin: 50 to 60 mm
Address block width: 80 to 90 mm

For C5 envelopes (unfolded A4), the address block sits higher on the page since the letter does not fold. The Word template needs adjustment between DL and C5 envelope use; one template does not serve both.

Mail merge directly to envelopes if needed.Word's Mailings tab includes Envelopes alongside Letters. The same recipient list feeds an envelope merge that prints addresses directly on envelopes rather than into letter address blocks. Useful for cases where window envelopes are unavailable or where the envelope needs a return address printed on it.

Volume thresholds

Office MFP mail merge runs handle volumes up to about 500 letters per session comfortably. Beyond that, the device duty cycle becomes a constraint, and the run may need to split across two sessions. Above 2,000 letters, posting partner services (mailing houses) typically run cheaper than in house printing once postage discount tiers are included.

Troubleshooting common merge errors

Three errors recur in office mail merges.

Fields appear as «FieldName» in printed output

The merge was not finalised. Click Finish & Merge before printing. The Preview Results view shows the substituted values; the actual document still contains field codes until merge completion.

Address block contains blanks or "0"

The Excel source has empty cells or numeric formatting issues. Confirm every recipient row is complete; consider an IF expression in the template to suppress blank lines.

Wrong recipient in printed letter

Recipient list sort changed between preview and final print. Re sort the source and rerun the merge. Verify the first three letters of the printed batch before sending the full job to the printer.

滚动至顶部