Sending the same letter to 50, 200, or 500 people by hand is a logistics problem that most businesses solve badly — printing stacks of pages, stuffing envelopes, running out of stamps, and still finishing with typos in recipient names. There's a better way.
This guide walks you through exactly how to send a letter to multiple recipients online using WriteToMail — a platform that handles printing, postage, and USPS First-Class Mail delivery without you ever touching an envelope. By the end, you'll have a functional bulk mail campaign ready to send.
What You'll Need Before You Start
Prerequisites:
- A list of recipients with names and mailing addresses (in a spreadsheet)
- Your letter content — either already written or a rough draft
- A WriteToMail account (free to create)
- Roughly 30–60 minutes for your first campaign
What you'll achieve:
Every recipient gets a physical letter addressed to them personally. Variable fields — like their name, account number, or amount owed — populate automatically from your spreadsheet. You don't touch a printer.
Step 1: Prepare Your Recipient CSV File
The CSV is the engine of any bulk mailing campaign. Get this right, and everything downstream flows easily.
Open a spreadsheet in Excel, Google Sheets, or Numbers. Create one row per recipient. At minimum, your spreadsheet needs these columns:
| Column | Description | Example |
|---|---|---|
FirstName |
Recipient's first name | Maria |
LastName |
Recipient's last name | Santos |
Address1 |
Street address | 412 Birchwood Ave |
Address2 |
Unit/suite (optional) | Apt 3B |
City |
City | Chicago |
State |
Two-letter state code | IL |
Zip |
5-digit ZIP code | 60614 |
Beyond those address fields, add any columns you need for personalization. A landlord sending lease renewal notices might add a UnitNumber, MonthlyRent, and LeaseEndDate column. A law firm sending demand letters might add AmountOwed and CaseNumber. A business sending quarterly statements might add AccountBalance and StatementPeriod.
The rule is simple: every piece of recipient-specific information you want to appear in the letter gets its own column.
Export the finished file as a .csv (comma-separated values). UTF-8 encoding prevents character issues with names that include accents or special characters.
Expected outcome: A clean CSV with a header row and one data row per recipient, no merged cells, no blank rows, no special formatting.
Step 2: Write Your Letter with Variable Placeholders
Now write the letter itself. This is where mail merge comes in — instead of typing a specific name or number, you insert a placeholder that matches a column header in your CSV.
WriteToMail's variable data mail merge uses a simple placeholder syntax. If your CSV has a column called FirstName, your letter might begin:
Dear {{FirstName}},
If you have an AmountOwed column:
Your current outstanding balance is ${{AmountOwed}}.
Every placeholder gets replaced with that row's actual value before the letter prints. Maria Santos gets her name. John Okafor gets his. Each letter is physically distinct — personalized, not form-letter generic.
You have two options for writing the letter inside WriteToMail:
- Use the rich text editor — compose from scratch with font, style, and color options
- Use AI-powered letter drafting — describe what you need and let the platform generate a draft you can edit
The second option is useful when you're staring at a blank page. Describe the situation ("I need a lease renewal notice reminding tenants their lease ends on a specific date and providing the new monthly rent amount") and the AI produces a solid first draft with placeholder fields already suggested.
If you already have a finalized document, you can also upload it as a PDF and map variable fields to recipient data.
Expected outcome: A letter with placeholders that correspond exactly to your CSV column headers. Every variable field is accounted for.
Step 3: Upload Your CSV and Map Variable Fields
With your letter template saved and your CSV ready, it's time to connect them.
Upload your CSV file to WriteToMail's bulk mailing tool. The platform reads your column headers and presents them as available fields for mapping.
This step is where most first-time users spend a few extra minutes — and rightfully so. You're telling the system: "when you see {{AmountOwed}} in my letter, pull the value from the AmountOwed column in my spreadsheet." Confirm each mapping carefully.
Address fields get their own mapping: Address1, City, State, and Zip map to USPS delivery address fields. The platform uses these to address the physical envelope — not just to populate the letter body.
After mapping, WriteToMail validates your address data. Rows with incomplete or malformed addresses get flagged before anything ships. Fix those rows in your CSV, re-upload, and continue.
Expected outcome: All variable fields mapped correctly, address data validated, recipient count confirmed on screen.
For a deeper look at how CSV column mapping works across different use cases, the variable data mail merge guide covers formatting requirements and supported field types in detail.
Step 4: Preview Individual Letters Before Sending
Never skip this step.
Before any letter goes to print, preview at least 5–10 individual records — not just the first one. Preview the first record, one from the middle, and the last. If your campaign has edge cases (a tenant with a very long name, a customer with a null value in one column), they'll surface here.
Check for:
- Placeholder text appearing in the final letter (means a mapping failed)
- Awkward line breaks caused by long variable values
- Missing data showing as blank instead of a default value
- Incorrect amounts or dates that suggest a CSV formatting issue
WriteToMail's preview renders each letter exactly as it will print. What you see is what gets mailed.
This is also the right moment to read the letter as a recipient would. Does it make sense? Is the tone appropriate? A demand letter going to 200 defendants needs to be precise. A lease renewal notice going to 50 tenants needs to be clear about dates and rent amounts. A quarterly statement going to 500 customers needs the numbers to be right.
Expected outcome: At least 5 letters previewed and approved. No placeholder errors. No formatting issues.
Step 5: Select Paper, Envelope, and Delivery Options
Physical mail has physical options. Before you finalize the order, choose:
- Paper type and color — standard white is common for legal and business correspondence
- Single or double-sided printing — longer letters may need two sides or additional pages
- Envelope type — standard #10 envelope for most business letters
- Mail class — WriteToMail sends via USPS First-Class Mail
USPS First-Class Mail typically delivers in 3–5 business days for domestic addresses. For legal correspondence — demand letters, tenant notices, compliance mailings — First-Class Mail creates a delivery record that email simply can't replicate.
Expected outcome: All mailing options confirmed. Total piece count and estimated cost visible before checkout.
Step 6: Review, Approve, and Send the Batch
The final screen shows you a full campaign summary:
- Total number of letters
- Total cost (price per piece × number of recipients)
- Selected paper and envelope options
- Estimated delivery window
Review it. Confirm the recipient count matches your expectation. If you uploaded 200 rows but the system shows 194, something got filtered during address validation — find out what before you pay.
Once you approve and complete checkout, WriteToMail processes the entire batch. Each letter is printed with that recipient's personalized data, enveloped, stamped, and handed off to USPS.
You don't print anything. You don't buy stamps. You don't go to the post office.
Expected outcome: Batch confirmed, order processing, USPS delivery in motion.
Real-World Use Cases
Landlords sending lease renewal notices: A property manager with 50 units can send personalized renewal notices — each showing the tenant's name, unit number, current rent, and new rent — in under an hour. Variable fields handle the personalization; USPS handles the delivery. For property managers dealing with overdue rent, the guide to sending bulk rent demand notices covers that specific workflow.
Small businesses mailing quarterly statements: A business with 500 customers can upload a CSV with account balances, statement periods, and customer names. Each customer gets a statement that looks individually prepared. For businesses that also need to send overdue notices, sending past due notices by mail explains how to structure 30/60/90-day cadence mailings alongside regular statements.
Law firms sending demand letters: A firm with 200 defendants can send personalized demand letters — each showing the defendant's name, case number, and amount owed — without paralegals spending two days printing and stuffing envelopes. The platform's SOC 2 compliant infrastructure handles sensitive data appropriately. Law firms doing this at scale should also review the complete direct mail guide for law firms for compliance and documentation best practices.
Common Mistakes and How to Fix Them
Placeholder text appearing in the sent letter. This means your column header in the CSV doesn't exactly match the placeholder in your letter. {{firstname}} and {{FirstName}} are different strings. Match them exactly, including capitalization.
Addresses getting flagged as invalid. The most common causes: missing ZIP codes, two-letter state abbreviations typed out in full ("Illinois" instead of "IL"), and PO Box formatting issues. Fix these in the CSV and re-upload.
All letters showing the same data. You uploaded the letter template but didn't complete the field mapping step. Return to the mapping screen and connect each placeholder to its CSV column.
Recipient count is lower than expected. WriteToMail filters rows with incomplete address data during validation. Export the validation report to see which rows were rejected and why.
CSV won't upload. Most upload failures come from the file not actually being saved as .csv — it's still an .xlsx. In Google Sheets, use File → Download → Comma Separated Values. In Excel, Save As → CSV UTF-8.
Variable amounts formatted incorrectly. If your AmountOwed column contains values like $1,250.00 (with dollar sign and comma), the letter might render oddly depending on your template formatting. Store amounts as plain numbers (1250.00) in the CSV and handle currency formatting in the letter template itself.
Troubleshooting: When Something Goes Wrong After Sending
Contact WriteToMail support immediately if you notice a systemic error after a batch is submitted — for example, a wrong CSV was uploaded or a letter contained incorrect data for all recipients. The window to intercept a print job is narrow but exists.
For individual letters that never arrived, USPS First-Class Mail does not include tracking by default. If delivery confirmation is critical for your use case (legal notices, compliance mailings), factor that into your workflow decisions.
Next Steps
Once you've sent your first bulk campaign, the workflow gets faster every time. Your letter template stays saved. Your CSV structure becomes standardized. Subsequent sends — monthly statements, quarterly notices, annual renewal cycles — become a repeatable process rather than a project.
If your use case involves sending invoices, the bulk invoice mailing guide covers how to format CSV files specifically for invoice data including due dates and invoice numbers. For teams managing ongoing accounts receivable workflows, automated accounts receivable mailing explains how to build a recurring physical mail cadence that runs without manual intervention each cycle.
The ability to send a letter to multiple recipients online — with genuine personalization, physical delivery, and no printing infrastructure — used to require a print house contract or an in-house mail room. Now it takes a spreadsheet and an afternoon.
Sources
- WriteToMail — Bulk Mailing via CSV Upload — Platform capabilities for variable data mail merge and bulk letter sending via USPS First-Class Mail.
- USPS First-Class Mail — Delivery Standards — Domestic delivery timeframes (3–5 business days) for First-Class Mail.
- USPS — Addressing Standards and Requirements — Official USPS Publication 28 covering address formatting, state abbreviation requirements, and ZIP code standards.
- SOC 2 Compliance Overview — AICPA — Definition and requirements for SOC 2 compliant data handling in SaaS platforms.
- HIPAA for Business Associates — HHS.gov — Requirements for HIPAA-compliant handling of protected health information in physical mail workflows.