Sending 200 past-due notices by hand is a full day's work. Printing, folding, stuffing envelopes, applying postage, hauling everything to the post office — for an accounts receivable team or property manager with a real job to do, that process is a tax on your time that doesn't need to exist anymore.
This guide shows you exactly how to send bulk mail online using a CSV upload and a mail merge workflow. No printing equipment. No post office runs. No minimum order requirements from a commercial print house. You upload a spreadsheet, personalize each letter with variable fields, and USPS First-Class Mail handles delivery.
What You'll Need Before You Start
Who this is for: Accounts receivable teams, property managers, collections departments, law firms, and any business that sends personalized letters to more than a handful of people at a time.
What you'll have by the end: A repeatable workflow for sending personalized bulk mail — think past-due notices, rent demand letters, legal notices, or collection correspondence — without touching a printer or visiting a post office.
What to prepare:
- A CSV file with one row per recipient
- A letter template (your own text, or a starting template)
- Recipient mailing addresses formatted to USPS standards (more on this below)
- Any variable data you want merged per letter: name, amount owed, account number, due date, etc.
Step 1: Build Your CSV File the Right Way
Your CSV is the foundation. If it's wrong, your letters go out wrong — or don't go out at all.
Each row in your spreadsheet should represent one recipient. Each column represents a data field. The minimum required columns for mailing are:
FirstNameandLastName(orFullName)Address1(street address)Address2(apt, unit, suite — optional but include the column)CityState(two-letter abbreviation: CA, not California)ZipCode(5-digit, keep it formatted as text so leading zeros don't get dropped)
Beyond addressing, include any variable data you plan to merge into the letter body:
InvoiceAmountDueDateAccountNumberPropertyAddress(useful for landlords managing multiple units)
USPS address formatting matters. The USPS addressing standards require that addresses be deliverable as printed. Common issues that cause returned mail: abbreviated street suffixes used inconsistently, missing apartment numbers, PO Box formatting errors, and ZIP codes that don't match the city/state. Clean your list before you upload — not after.
A realistic expectation: even a clean list will have 2–5% undeliverable addresses. That's normal. The goal is to minimize it with accurate data upfront.
Step 2: Write Your Letter Template with Variable Fields
Your letter template is written once. The variable fields get replaced with each recipient's specific data at send time. That's the mail merge.
Variable fields are typically denoted with double curly braces or a similar syntax depending on the platform. On WriteToMail, you embed fields like {{FirstName}}, {{InvoiceAmount}}, or {{DueDate}} directly in your letter text.
A collections notice might open like this:
Dear {{FirstName}} {{LastName}},
Your account (#{{AccountNumber}}) has an outstanding balance of ${{InvoiceAmount}}, which was due on {{DueDate}}. As of today, we have not received payment.
Every recipient gets a letter that reads as if it was written specifically for them. That's not just a nicety — it matters legally. A generic "Dear Customer" letter carries less weight than a letter that references the actual invoice amount and account number when you're documenting a formal collection attempt.
Keep your letter under one page if possible. Single-page letters are less expensive to mail and faster to process. If your notice requires more detail, two pages is fine — just be intentional about what earns the space.
Step 3: Upload Your CSV and Map Your Fields
Once your template is written and your CSV is clean, upload both to the platform.
Field mapping is the step where you connect your CSV column headers to the variable fields in your letter. If your CSV column is called InvoiceAmt but your letter uses {{InvoiceAmount}}, you'll map those together during this step.
What to check before confirming the mapping:
- Every variable field in your letter has a matching CSV column
- No column has blank values in rows where the field appears in the letter (a letter that reads "your balance of $" is worse than no letter)
- Date formats are consistent — "03/13/2026" and "March 13, 2026" are both fine, but mixing them looks careless
- Name casing is correct — "john smith" in your CRM should be cleaned to "John Smith" before export
Preview at least 5–10 letters before submitting the batch. Pull rows from the beginning, middle, and end of your file. If something is wrong with your column mapping or data formatting, you'll catch it here instead of after 500 letters go out.
Step 4: Choose Your Mail Class and Submit
For most business correspondence — collections notices, rent demand letters, legal notices — USPS First-Class Mail is the right choice.
Here's why it matters: First-Class Mail is forwarded if the recipient has filed a change of address, and undeliverable pieces are returned to the sender. That return piece is documentation that the address was bad. For collections and legal purposes, that's useful information. Marketing mail (formerly "bulk mail" or Standard Mail) is not forwarded and not returned — it just disappears.
USPS First-Class Mail delivery for letters typically runs 1–5 business days domestically. For a portfolio of 500 past-due accounts, letters can be in recipients' mailboxes within a week of upload.
Once you submit, the platform handles printing, folding, envelope insertion, postage application, and USPS induction. You get a confirmation. Your recipients get physical mail.
Step 5: Track Delivery and Document Your Send
Physical mail doesn't come with read receipts, but you're not flying blind either.
Platforms like WriteToMail provide send confirmations with timestamps. For legal and collections use cases, that timestamp is meaningful — it establishes when the letter was mailed, which supports documentation of formal notice. If you're an AR team escalating to a collections agency, or a property manager building an eviction file, that paper trail matters.
For high-stakes mailings, consider whether Certified Mail makes sense. Certified Mail provides USPS tracking and a delivery confirmation signature — proof that the specific piece arrived. The tradeoff is cost and friction: recipients must sign for it, which some avoid. For most demand letters and collection notices, First-Class Mail is sufficient and far more practical at volume.
Keep your sent records. Export your submission confirmation. If your platform allows it, retain a copy of the merged letter for each recipient. This takes 60 seconds to set up and can save hours of work if a recipient later disputes receiving the notice.
Common Mistakes (and How to Avoid Them)
Sending from a personal name when it should be a business name. The return address on your envelope sets expectations. If your letter comes from "Sarah Chen" instead of "Lakeside Property Management," it looks informal and may be ignored or mistaken for personal correspondence.
Not cleaning addresses before upload. Running a quick NCOA (National Change of Address) check on a large list before mailing saves money and improves deliverability. Services like Melissa Data or SmartyStreets can validate and standardize addresses at scale.
Using vague variable fields. A field like {{Amount}} works, but {{InvoiceAmount}} is clearer when you're building and maintaining templates over time. Name your columns and fields for future-you, not just present-you.
Forgetting to preview. Skipping the preview step is the single most common mistake. One misaligned column can send 800 letters with the wrong account numbers. Always preview.
Over-relying on mail alone for legal notice. Physical mail is excellent documentation, but for eviction-related notices or formal demand letters, check your jurisdiction's requirements. Some states require specific delivery methods or notice periods. A letter sent via USPS First-Class Mail on the right date still needs to satisfy local requirements to be legally effective. For formal legal correspondence like a cease and desist, understanding how to send a cease and desist letter correctly — including mailing standards — is worth reviewing before you send at volume.
Who Uses Bulk Mail Workflows Like This?
Accounts receivable teams use CSV bulk mail to replace manual letter stuffing. A 300-account past-due run that took a full day now takes 20 minutes to set up. If you want a more detailed look at structuring those mailings, the guide on automating past-due notices for AR teams covers mailing cadence and escalation workflows specifically.
Property managers send rent demand notices, lease violation warnings, and end-of-tenancy notices across multiple units simultaneously. Managing 80 units doesn't mean sending 80 individual letters by hand. The workflow described here applies directly — and bulk rent demand notice mailing for landlords goes deeper on property-specific use cases.
Law firms and legal departments use bulk physical mail for client communications, opposing counsel notices, and formal demand letters. Physical mail creates a durable paper record that email doesn't.
Collections departments use it to send initial demand letters before escalating accounts — establishing documented formal notice as a precondition for further action.
The Numbers Behind Physical Mail
Physical mail still gets opened. USPS data shows that 98% of Americans check their mail daily or almost daily. Direct mail has an average open rate that significantly outperforms email for financial and legal correspondence — because it requires physical action to discard.
A 2024 study by the Data & Marketing Association found that direct mail response rates average 9% for house lists (existing customers or contacts) — compared to 1% for email. For collections and payment notices, that gap is even more pronounced. Someone who ignores three email reminders about an overdue balance may respond to a physical letter.
The cost of mailing 500 First-Class letters — printing, postage, and handling through an online platform — typically runs $2.00–$3.50 per piece depending on page count and service. Compare that to the fully-loaded cost of a staff member spending a day hand-processing the same batch.
Next Steps
If this is your first time sending bulk mail online, start with a small batch — 10 to 25 recipients — to verify your template, CSV mapping, and address data before scaling to hundreds or thousands.
Once you're comfortable with the workflow, explore variable data mail merge for bulk letters via CSV to understand more advanced personalization options: conditional content blocks, multi-page logic, and supported field types.
The goal is a workflow you can run in 20 minutes — not a full day. Physical mail that used to require a printer, a postage meter, and a trip across town now requires a spreadsheet and a browser.
Sources
- USPS Publication 28 — Postal Addressing Standards — USPS official addressing requirements for mailpiece formatting and deliverability
- USPS First-Class Mail Overview — Delivery timelines, forwarding behavior, and return mail handling for First-Class letters
- USPS — Direct Mail: The Medium That Gets Noticed (PDF) — Statistics on daily mail checking behavior among U.S. households
- Data & Marketing Association — Direct mail response rate benchmarks versus digital channels
- Melissa Data — Address Verification Services — Address standardization and NCOA processing for mailing list hygiene
- SmartyStreets — US Address Verification — Real-time address validation API and bulk list processing
