PDF for fundraisers — donor letters + receipts at scale

The mail-merge-to-PDF workflow for personalized donor letters and IRS-compliant tax receipts, produced in bulk.

6 min read

PDF for fundraisers — donor letters + receipts at scale

By ScoutMyTool Editorial Team · Last updated: 2026-05-21

The first year-end appeal I helped a small nonprofit close ended with a stack of 600 thank-you letters that someone was about to address by hand. We were a week from the holidays, and the development director was bracing for two lost days. The thing that saved the campaign was unglamorous: a clean donor spreadsheet, one good letter template, and a mail merge to PDF. Each donor got a letter with their name, their gift, and a compliant tax-receipt line — produced in an afternoon. This guide walks through that workflow end to end, the IRS substantiation rules your receipts must satisfy, and how to keep a bulk run from reading like a form letter. (It is general information, not tax advice.)

The donor-acknowledgment pipeline

StageToolAt scaleBest for
Personalize lettersMail merge (Word / Google Docs → PDF)One template, many recordsNamed, dated thank-you letters
Add the tax-receipt clauseMerge fields for amount + date + EINPer-donor figures from your listYear-end and per-gift acknowledgments
Brand each pageWatermark / logo stampApply across the whole batchLetterhead and seasonal campaigns
Combine into one packetMerge-PDFHundreds of letters → one fileMail-house handoff or archiving
Number for mailingAdd page numbersSequential across the batchTracking large print runs
Protect donor dataProtect-PDF (AES)Encrypt before any sharingFiles containing donor PII

Step by step — letters and receipts in bulk

  1. Clean the donor list first. Your merge output is only as good as the data: consistent name formatting, correct gift amounts, accurate dates, and valid addresses. Fix the spreadsheet before merging — errors here become errors on every letter.
  2. Write one template with merge fields. Draft the letter in Word or Google Docs with placeholders for name, amount, date, and fund. Include the tax-acknowledgment language: your organization name, the amount, and the no-goods-or-services statement (or a description and good-faith value estimate if any were provided).
  3. Run the mail merge and export to PDF. Generate one personalized letter per donor record, then export to PDF — the format that prints and emails identically everywhere. Spot-check a handful of merged letters against the source rows.
  4. Brand and combine. Apply your logo or letterhead watermark across the batch, then merge the individual letters into a single ordered PDF and add sequential page numbers for tracking the print run.
  5. Protect donor data before sharing. The combined file contains donor names and amounts — encrypt it with an open password before handing it to a mail house or storing it, and send the password separately.
  6. Archive the run. Keep the source spreadsheet and the final PDF together as your record. You will want them for audit, for next year’s template, and for any donor who asks for a duplicate receipt.

Keeping it compliant and personal at once

The two goals — IRS compliance and genuine warmth — are not in tension if you build the template well. The compliant elements (name, amount, the goods-or-services statement) are fixed text and merge fields you set once. The personal elements (referencing the specific campaign, the donor’s giving history, a real signatory) are also template-driven but written to read as specific. Segment your templates — first-time, recurring, major donor — so the tone matches the relationship. The donor cannot tell that 600 letters went out the same afternoon; they see their name, their gift, and a thank-you that also happens to satisfy the substantiation rules.

Related reading

FAQ

How do I personalize hundreds of donor letters without writing each one?
Use mail merge. You write one letter template with merge fields (donor name, gift amount, date) and connect it to a data source — a spreadsheet of your donors — and the word processor generates one personalized letter per row. Word and Google Docs both support this, and you export the result to PDF for printing or emailing. The donor sees a letter that reads as if written individually; you wrote it once. The key to quality at scale is a clean donor list: consistent name formatting and accurate amounts in, correct letters out.
What must a tax-deductible donation receipt actually contain?
In the United States, the IRS requires a written acknowledgment for any single contribution of $250 or more, and donors need it to substantiate their deduction. A compliant acknowledgment states the organization’s name, the amount of cash contributed (or a description of non-cash property), and either a statement that no goods or services were provided in return, or a description and good-faith estimate of the value of any that were. Include the gift date and your organization details. The IRS Publication 1771 lays out the substantiation and disclosure rules; follow it so your donors’ deductions hold up.
Should donor acknowledgments go out as PDF email attachments or printed mail?
Both are common; choose by donor preference and gift size. PDF email attachments are fast, free, and easy to archive — ideal for the bulk of online gifts and for donors who expect digital communication. Printed letters carry more weight for major gifts, older donor segments, and year-end stewardship where a physical letter signals care. Many nonprofits do both: an immediate emailed PDF receipt at the time of the gift, plus a printed year-end summary letter. Whatever the channel, keep an archived PDF copy of every acknowledgment for your records.
How do I keep a batch of letters from feeling impersonal?
Personalization is more than the name field. Reference the specific gift amount and date, and where your data supports it, the fund or campaign the donor supported and their giving history ("your third year of support"). Segment templates by donor type — first-time, recurring, major — so the tone fits. A signature block from a real person, and a short handwritten-style line for major donors, lift a merged letter out of the form-letter feel. The mechanics are bulk; the content should still read as specific.
Is it safe to process files full of donor data with an online tool?
Only if processing happens on your own device. Donor records are personal data, and server-side tools upload your file to a third party, where it may be cached or logged. Client-side (in-browser) tools process locally so the file never leaves your computer — ScoutMyTool’s PDF tools work this way. Before any letter batch containing names, amounts, or contact details touches an online tool, confirm it is client-side, and encrypt the combined file before sharing it with a mail house or storing it.
How do I combine hundreds of individual letters into one file for the printer?
After the mail merge produces your letters (often as individual PDFs or one long document), use a merge tool to combine them into a single PDF in the correct order, then add sequential page numbers for tracking. A mail house or print shop generally prefers one ordered file over hundreds of separate ones. Keep the source spreadsheet and the final merged PDF together as your record of the run, and encrypt the file if it leaves your office.

Citations

  1. IRS — Charitable contributions: written acknowledgments (substantiation rules)
  2. IRS — Publication 1771, Charitable Contributions: Substantiation and Disclosure Requirements
  3. Microsoft — Use mail merge for bulk letters, email, labels and envelopes

Combine your donor letters into one file

After the merge, ScoutMyTool Merge PDF combines hundreds of letters into a single ordered file — entirely in your browser, so donor data never leaves your computer. Then add page numbers and encrypt before handoff.

Open Merge-PDF tool →