Mail Merge at 12:30: Diagnosing Four Faults Before the 4 p.m. Dispatch
You are the administrative assistant in a training institute. Today 210 offer letters must go out to shortlisted candidates. You prepared the main document in Word with an Address Block and a merge field «Offer_Percent», and the data source is an Excel sheet maintained by three different clerks. You run the merge and find four faults: 37 letters print with «AddressBlock» visible instead of an address; 12 letters show the offer percentage as '0.85' instead of '85%'; 5 letters are addressed to candidates who withdrew last month; and one letter breaks so that the signature block sits alone on page 2. The dispatch deadline is 4 p.m., it is now 12:30 p.m., and nothing has yet been printed on the institute's letterhead.
1. Why do 37 letters show «AddressBlock» and how do you fix and contain the problem before printing?
Read the worked answer
Word prints the field name inside those angled quotes when it cannot obtain a value for that record. Three causes are typical, and all three should be checked because the sheet is maintained by three clerks: (1) the address columns are blank for those records - a candidate with no street or city line; (2) the header row does not match the fields in the main document, so the mapping is broken (check Mailings → Match Fields); (3) the connection to the workbook was lost or the sheet was re-saved in a different format, so Word is reading a stale or partial copy.
Fix order: re-select the recipients and re-check Match Fields first - it is a two-minute check and explains most mass failures. If the fault is genuinely blank cells, do not fabricate addresses: filter the list so those 37 records are excluded, print the remaining letters, and send the 37 as a separate short batch after the clerks supply the missing lines.
Containment: never print 210 letters and sort afterwards. Print a proof set of five records that include the problem cases, read them, then run the full merge. Keep a printed control list of the 37 held-back names so that nobody assumes they were dispatched.
2. How do you correct the '0.85' percentages and remove the five withdrawn candidates?
Read the worked answer
The percentage. Excel stores 85% as the number 0.85 and applies the display format separately; the merge carries the underlying number, not the appearance. Two reliable fixes:
- Best fix - add a helper column in Excel:
=TEXT(F2,"0%")and merge that text column instead of the raw number. What you see in the cell is then exactly what prints, whatever the Word version. - Alternative - keep the numeric field and apply a numeric picture switch in Word:
{ MERGEFIELD Offer_Percent \# "0%" }. Test it on one record before committing 210 letters, because the switch behaves differently across versions.
Either way, preview the merged document for three or four records before printing.
The withdrawn candidates. Do not delete them from the master sheet - the withdrawal record is needed for audit and for the waiting list. Instead add a Status column and use Mailings → Edit Recipient List to clear the withdrawn five, or apply a filter (Status = Active). Merging then simply skips them. Check the count in the status bar reads 205 before printing, and note the five names in the dispatch register as 'withdrawn - not issued'.
3. How do you fix the page-break fault, and what print sequence do you follow to protect the 4 p.m. deadline?
Read the worked answer
The break. The letter is one line too long, so the signature block is orphaned. Fix in this order: (1) select the signature block and its closing line and set Paragraph → Line and Page Breaks → Keep with next, and Keep lines together; (2) trim the body - reduce paragraph spacing after by 2 pt, or tighten the top margin - rather than shrinking the font; (3) if a single letter still spills, insert a manual page break before the closing paragraph for that letter only, through a conditional rule, not for all.
Print sequence for a 12:30 start:
- 12:30–12:45 - fix mapping, helper column, filter; confirm record count is 205.
- 12:45–13:00 - print five proof letters on letterhead, including one previously faulty record; check alignment to the pre-printed letterhead, address window position if envelopes are windowed, and page fit.
- 13:00–13:15 - get the section head's initials on the proof.
- 13:15–15:00 - full run in batches of 25, removing each batch from the output tray so a jam cannot mix pages.
- 15:00–15:45 - collate, count against the control list, stuff and seal; keep the five withdrawn names and the 37 held back out of the dispatch bag.
If the run fails, report by 2 p.m., not 4 p.m.