Mail Merge Lite: Send Personal Emails From an Excel List, Without Uploading It

Send personal emails to a list, without uploading the list

Sometimes you need to send the same email to twenty people, but each one should say their own name, their own invoice number or their own meeting time. Word and Outlook can do a mail merge, but it takes a dozen steps and only works on Windows. Online mail merge services want you to upload your contact list and connect your mailbox.

This tool keeps both on your computer. Paste the list from Excel, write the message once with placeholders such as {{First name}}, and check every email before it goes anywhere. Then open the emails one by one in your own email program, or download them all at once as drafts that open in Outlook or Apple Mail, ready to read and send. The list is never uploaded, and nothing is sent by this page.

How to use it

1. Add your list. Copy the cells in Excel or Google Sheets, including the row with the column names, and paste them in. Or open an Excel or CSV file.
2. Pick the email column. The tool chooses the column called Email if there is one.
3. Write the message. Click a column name to put its placeholder where your cursor is. Placeholders work in the subject too.
4. Check each email. Step through them with Previous and Next. Filled-in values are highlighted; anything missing is shown in red and listed under "Check before sending".
5. Send. For a few emails, press Open this one in my email app for each. For many, use Download all as drafts and open the drafts in your email program.

Three ways to send

• One at a time: opens a new email in your default email program with the address, subject and message already filled in. Very long messages may be cut off by some email programs, so the tool warns you when a message is long.
• Drafts (.eml files): a ZIP with one draft per person. Double-click a draft to open it in Outlook or Apple Mail as an unsent email, then press Send. Your own email account sends it, so replies come back to you.
• Excel: a sheet with every row plus the finished Subject and Message columns, handy for other tools or as a record of what was sent.

Tips for emails that read well

• Always add a fallback to greetings. Hi {{First name|there}}, reads naturally even when a name is missing, instead of "Hi ,".
• Keep the column names simple. "First name" and "Due date" are easier to read in a template than "fname_1".
• Format numbers and dates in Excel first. The tool uses the values as they appear in your list, so $1,280.00 stays $1,280.00.
• Send yourself a test. Put your own address in the first row of the list and open that draft before sending the rest.

When it comes in handy

• Invoices and payment reminders with each client's amount and due date.
• Meeting invitations with each person's time slot or room.
• Event follow-ups thanking people by name and linking the slides for their session.
• HR and admin notices that mention each person's own leave balance or deadline.

How this tool was tested

Before publishing, I ran 45 automated checks on the finished page in a Chromium-based browser. Last full run: 14 November 2026.

• Filling in: placeholders with odd capitals and spaces, fallbacks (including empty ones), unknown columns, accents, emoji and line breaks, plus 300 random templates compared with a simple separate version.
• Addresses: good and bad email addresses, and finding the email column by its name or by what is in it.
• Email formats: the "open in my email app" link keeps the address, subject and message intact; each draft file is marked as unsent, and its subject and message decode back to exactly what was written, accents and emoji included.
• Using the tool: the sample, stepping through emails, inserting columns at the cursor, warnings for empty cells, unknown columns and bad addresses, the drafts ZIP, the Excel download, copying, pasted CSV with quoted commas, and an Excel file with blank rows.

What the tests did not cover: the drafts were checked as files, not opened in every email program. They follow the standard format that Outlook, Apple Mail and Thunderbird read, but please open one and check it before sending a batch. I did not run the tests in Firefox or Safari. Something not working? Tell me on the contact page.

FAQ