Send a personalized letter from a spreadsheet

Send each unit its own fee, balance, due date, or other value in the email subject and letter. You need staff access to Email Merge and a CSV or Excel file with one row per unit.

ManagerConcierge· Updated November 15, 2026Open in app
  1. Open Email Merge, click Compose, and choose the people under To.

    Tip: To include residents who do not have an email address, open To and turn on Show people with no email. Your other recipient filters still apply.

  2. Click Tools, then click Spreadsheet data.
  3. Click Upload file, or click Download template and choose Budget, Annual fee, Special assessment, or Balance reminder.

    Tip: The downloaded file already lists the selected units. Keep the Unit column and fill the other columns. Files can be .csv, .xlsx, or .xls, up to 5 MB. Email Merge reads the first sheet and up to 5,000 rows.

  4. Review Units, Residents, Unmatched, Units missing, and Residents missing.

    Tip: Rows always match by Unit. One unit can match several residents. Unmatched means a spreadsheet row has no selected recipient. Units missing means a selected unit has no spreadsheet row. Tip: An empty fee or other value appears in a separate warning even when the unit matched. Fix the cell before sending.Spreadsheet data match summary and empty-value warning — Spreadsheet data dialog showing matched units, matched residents, unmatched rows, missing units, missing residents, and units with empty values

  5. Keep Only send to recipients with a matching row turned on if people without a spreadsheet row should be removed from To.
  6. Click Add spreadsheet to the email.

    Important: The spreadsheet is private merge data. It is not an attachment, and residents do not receive it.

  7. Click Insert field on the spreadsheet card and choose a column to add to the letter.

    Tip: Unit is the matching column, so it is not listed on the spreadsheet card. To replace the spreadsheet, click Delete, then add the new file.

  8. Click Insert field beside Subject and choose a spreadsheet field if the subject should also be personalized.

    Example: Budget for unit [[DATA.Unit]] — New fee [[DATA.Monthly fee]] Tip: The subject Insert field menu appears only while a spreadsheet is added.

  9. Click Add attachment for any shared PDF, financial statement, or notice that everyone should receive.

    Important: Shared attachments are sent to the recipients. The spreadsheet remains private and is never included with them.

  10. Click Preview, choose several people, and confirm the subject and letter show the correct values for each unit. Then click Send or Schedule.

    Tip: People are grouped by unit in Preview. Each person is marked Email or PDF. The preview uses the same design as the editor, with that person’s spreadsheet values filled in.

If a selected person has no email address, choose Only units with no email or Everyone, including residents with no email under Printed notices. The person is added to the personalized PDF instead of the email list. You cannot leave Don't create a PDF selected when the audience includes someone without email.

If a value used in the subject or letter is empty, sending is blocked. Fix the spreadsheet and upload it again. When Only send to recipients with a matching row is off, you can instead enter an If empty value for the affected column.

Result: Every emailed resident receives the values from their own unit row in the subject and letter. Residents without email appear in the personalized printed-notices PDF. Shared attachments are delivered normally, but the spreadsheet itself is not attached.

Spreadsheet mailings are sent immediately and do not have the three-minute unsend window. Auto-translate is unavailable while a spreadsheet is added. A spreadsheet and one response tool can be used in the same email.

Was this article helpful?

Browse all topics

Can't find what you need?

Contact Support