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.
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.
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.
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.
Word switches to mail merge mode. The Mailings tab options become active. Other tabs remain available; the merge does not lock the document.
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.
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.
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.
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.
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.
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.
| Field need | Word expression |
|---|---|
| Full name from first and last fields | «FirstName» «LastName» |
| Formal salutation | Dear 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», " } |
For most mail merge runs to office MFP, four settings matter.
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.
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).
By default, Word prints letters in recipient list order. For posting in alphabetical batches, sort the recipient list alphabetically before merge.
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.
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.
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.
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.
Three errors recur in office mail merges.
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.
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.
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.