Donor Confirmation Letter Generator

If the user specified a timeframe, add appropriate event_ts filters.

If no results are returned, tell the user and ask them to double-check the email address.

Step 2: Generate the letter

Create an HTML file at ~/Downloads/donation-confirmation-<lastname>.html.

The letter must include these elements, in this order:

Letterhead

• Embed the logo at ~/Downloads/logo.png as a base64 data URI (read and encode the file), if the file exists
• Organization name: read ORG_NAME from .env or .env.local (e.g., "Your Organization")
• Address: read ORG_ADDRESS from .env or .env.local

Date

Today's date, right-aligned.

Recipient

The donor's name (from the query results — use the most recent donor_name value).

Subject line

"Re: Donation Confirmation Letter"

Body

The letter body should include:

1. Opening — thank the donor for their support of the organization (use ORG_NAME from .env)
2. About the organization — brief paragraph using the ORG_MISSION value from .env or .env.local. All contributions are directed toward the organization's charitable purposes.
3. Transaction table — all donations listed chronologically with:
   • Row number
   • Date (formatted like "January 23, 2025")
   • Amount with currency symbol
   • Group rows by year with year headers
   • Total row at the bottom with count and sum
4. Confirmation paragraph — confirm that all donations were received and used exclusively for the organization's charitable purposes
5. Tax status — use the ORG_TAX_STATUS value from .env or .env.local. Mention no goods or services were provided in exchange.
6. Closing — "With sincere gratitude,"

Signature block

Leave space for a signature, then:

• Read DEFAULT_SIGNER_NAME from .env or .env.local (e.g., "Organization Leader")
• Read DEFAULT_SIGNER_TITLE from .env or .env.local, followed by the organization name from ORG_NAME

Footer

• Organization name (from ORG_NAME) with the address (from ORG_ADDRESS), centered, small text

Style guidelines

The letter should look professional and be print-ready. Use:

• Georgia or Times New Roman for body text, ~11pt
• A blue accent color (#00a0e3) for the org name and table headers
• Clean table styling with alternating row backgrounds
• Proper @page CSS for letter-size paper with margins
• Tabular number formatting for the amount column

Step 3: Open the letter

After writing the file, open it in the browser:

open ~/Downloads/donation-confirmation-<lastname>.html

Tell the user the file location so they can print to PDF (Cmd+P) from the browser.

Multi-currency handling

If the donor has donations in multiple currencies, show the currency on each row and provide separate totals per currency at the bottom of the table. Do not mix currencies in a single sum.

Name on the letter

Use the donor_name from the most recent donation record. If the user provides a specific name to use, prefer that.