A mail merge reads as personal when each copy carries one thing only that person could have been sent. Their first name doesn’t do it on its own. Everyone knows a first name can be filled in. What does it is a detail from your shared history: the invoice they asked about, the date you met, the project you’re both waiting on. Add a column for that detail, write the template around it, and give every blank a fallback. Then fifty emails can read as fifty notes.
None of this means hiding that it’s a merge. People know you write to more than one client. They just want the note in front of them to be about them. This guide covers the columns worth adding, the sentences that hold up whatever fills them, and the small slips that give a merge away. It works for Gmail’s built-in merge, Word with Outlook, and the add-ons alike. Google, Microsoft and Mailmeteor facts are from their own help pages, checked on October 5, 2026.
Write it to one person first
Pick a real row from your list. Write the email to that person, the way you’d write it if they were the only one getting it. Then go back through and find the words that would change for the next person. Those words become your tags.
This order matters. A template written as a template comes out generic, because you’re writing to nobody. A note written to Maria, with her details lifted out, still sounds like it was written to Maria. Now it sounds that way for Sam too.
Read the finished template once with Sam’s row in mind. Anything that only fit Maria needs a tag, or it needs to go.
The columns that make it personal
Your sheet or Excel list already has an address and a first name. The columns you add next carry the message. Each one should hold something the reader recognizes as theirs.
| Column | What it holds | What it does in the email |
|---|---|---|
| FirstName | The name they sign with | “Hi Bob,” for someone who signs as Bob, not “Hi Robert,” |
| Detail | Their invoice number, booking date or project name | Shows you’re writing about their account, not to a list |
| LastContact | When and how you last spoke | “Since we spoke at the October open house…” |
| Opener | One sentence you write by hand for this person | The line that reads as written to them, because it was |
The Opener column is the strongest of these. It’s a plain text column, and you write one sentence per person: “Thanks again for the referral to the Hendersons.” “Hope the move to the new office went smoothly.” Fifty sentences take about as long as a cup of coffee. The rest of the email can stay the same for everyone, and nobody minds, because the first thing they read was theirs.
Setting up the sheet itself, with headers your tool can read, is covered in mail merge from a Google Sheet. One rule from there matters here. Each tool reads the header names exactly, so FirstName and First name are different columns. Mailmeteor’s help puts it plainly:
“Always make sure that your variable matches your spreadsheet’s headers precisely.”
Write sentences that hold up for every row
A tag drops whatever’s in the cell into your sentence. The sentence has to read right for every value it might get. A few places trip people up:
- “A” and “an.” “You ordered a @Product” reads wrong when the product is an umbrella. Rewrite around it: “Your @Product order is ready.”
- Singular and plural. “Your @Count item is ready” breaks at two. “Items ready for you: @Count” doesn’t.
- The start of a sentence. If a tag opens a sentence, the cell needs a capital letter. Most lists aren’t that tidy, so keep tags mid-sentence where you can.
- Dates and amounts. Type them in the sheet as you’d want them read, like “October 15” and “$1,240.00”. A spreadsheet date can arrive as a number or in a format you’d never write.
Keep the formatting your normal mail has. A merge sent from your own mailbox looks like your other mail if it’s written like it. No banner, no colored headings, your usual signature. If you paste text in from elsewhere, paste it as plain text, with Ctrl+Shift+V on Windows or Cmd+Shift+V on a Mac. Otherwise the pasted part can carry a different font, and the seam shows.
Write the length you’d usually write. A three-line note from you that turns into six paragraphs reads as a mailing.
A fallback for every blank
A blank cell is the most common giveaway. “Hi ,” tells the reader everything. Every tool handles this a little differently.
Gmail’s built-in merge
Gmail won’t send with a gap. Google’s help says:
“If you have a recipient with missing information for a merge tag, you get an error message.”
That error message is where you type the default. Google’s example is “Hi friend”. You can also add the missing details, or take that person off the list. A default works best when it fits how you’d normally greet that group. “Hi there” suits most small-business mail. To someone you’ve worked with for years, though, “Hi there” reads colder than no greeting at all. So for your closest contacts, fill the name in.
Word with Outlook
Word’s Greeting Line has its own choices for names it can’t read. For anything beyond the greeting, use a rule. Microsoft describes it this way:
“Use an If…Then…Else… rule to personalize the message for all the recipients”
It’s under Mailings > Rules > If…Then…Else. You pick a column and a condition, then type the text for each case. So a blank FirstName can give “Hello,” while a filled one gives “Hi Maria,”. The step-by-step for the Word, Excel and Outlook setup is in mail merge in Outlook and Word.
Mailmeteor and similar add-ons
Mailmeteor puts the fallback inside the tag, after a vertical bar: {{ firstname | there }}. A row with a name gets “Hi Sally”. A blank row gets “Hi there”. Other add-ons have their own version of this, so check the help page for the one you use. Mail merge tools says what each add-on is for.
Clean the name column by eye
Fallbacks catch blanks. They don’t catch names that are there but wrong. Read the name column top to bottom before you send:
- All capitals. “Hi MARIA” reads like a form letter. It usually comes from an export.
- The formal name. A contact card might say Robert. If he signs every email Bob, write Bob.
- A company in the name field. “Hi Northside Bakery” happens when a contact was saved without a person’s name.
- Two people in one cell. “Hi Maria and Tom” is fine if you meant it, and odd if you didn’t.
Google Sheets has a PROPER function that fixes capitals in one go. Google’s own help warns about its limit: it lowercases everything after the first letter of each word, so “McLeod” becomes “Mcleod”. Run it, then read the result.
One template, two kinds of reader
Sometimes part of your list needs a different line. New clients need a welcome. Returning ones don’t. You have three ways to handle it.
- A column for the line itself. Add a column that holds the whole sentence, or nothing. This works in every tool, including Gmail’s built-in merge.
- A rule in Word. The If…Then…Else rule picks between two texts based on a column. Word also has Skip Record If, which leaves out rows that match a condition.
- Two merges. If the groups differ by more than a line or two, write two templates. Two good emails beat one email that’s trying to be both.
The subject line everyone shares
Gmail’s built-in merge can’t personalize the subject. Google’s help is direct:
“You can’t use merge tags in: Subject lines”
Word’s merge to email takes one subject line too, typed in the Merge to E-mail dialog. Mailmeteor and most add-ons can put a tag in the subject.
A shared subject can still read as personal. Write it the way you’d title a note to one person about this thing: “Your October invoice”, “Moving our Thursday sessions”, “The new office address”. Those fit every reader because they’re about the reader’s side of it. Leave out anything that sounds like a mailing, such as “Update” or “News from us”. Writing subject lines in general is covered in subject lines that get opened.
What gives a merge away
Even a careful merge can slip. These are the things readers notice:
- A sorted sheet with scrambled rows. If you sort one column on its own, names stop matching addresses. Maria gets Sam’s invoice. Always sort the whole sheet together, or don’t sort it at all.
- The unsubscribe link. Gmail’s built-in merge adds one to every email. Google says a “unique unsubscribe link is automatically added to the bottom of each email.” To a client, that footer makes the email look like a newsletter. For a handful of close contacts, a separate note avoids it.
- The same paragraph to people who talk to each other. Recipients can’t see who else got it. Two partners in the same firm will still compare notes. If both get a word-for-word copy, give each a different Opener, or write to them together.
- Lines that pretend. “I was just thinking of you” doesn’t belong in a merge. Personal comes from the details being right, not from claiming you wrote each one by hand.
- A greeting that doesn’t fit the relationship. “Dear valued client” to someone you text. “Hi Tom” to someone you’ve always called Mr. Okafor.
Read a few rows as the people in them
Your tool’s own checks catch blanks and counts. How to mail merge in Gmail lists those before-you-send checks. The check here is different. Read the email as these people on the list would:
- The person with the longest name or company.
- Someone whose row has a blank cell.
- A new contact, and one you’ve known for years.
- Anyone with an unusual detail, like a long project name or a date next year.
In Word, Preview Results steps through each person’s version. In Gmail or an add-on, send a test with your own address in those rows. If each one reads like you wrote it to them, the rest of the list will too.
When a merge stops being the right tool
Watch the Opener column. When the hand-written part grows longer than the shared part, you’re writing individual emails with extra steps. For under ten people, or for news that’s bad, sensitive or different for each person, separate emails are usually better. When a mail merge is the wrong tool helps you decide.
The replies to a personal merge
A merge that reads as personal gets personal answers. People reply the way they’d reply to a note from you. They ask a real question, mention their weekend, or forward it to a colleague. In Gmail each reply comes back as its own thread, one per person. Handling the replies to a mail merge covers working through them. If some don’t answer, following up without nagging picks it up from there.
This is the part where Point helps. Point doesn’t send mail merges. Your mailbox and your merge tool do that. When the answers come back, Point reads each one as it lands. Maria asking about invoice 1042 comes first, with an answer to her already drafted in your voice. It waits there until you’ve read it and pressed send. The thank-yous and out-of-office notes stay out of her way. What Point takes off your plate covers the rest of the inbox too.
Common questions
How do I personalize a mail merge?
Add a column for each detail that changes per person, and put a tag for it in your message. The first name helps, but a detail from your history with them does more. A column with one hand-written sentence per person is the strongest step.
How do I make a mail merge not look like a mass email?
Write it to one real person first, then swap their details for tags. Keep your normal formatting and signature. Give every blank a fallback, check the name column for capitals and formal names, and keep the length you’d usually write.
What happens if a first name is missing in a mail merge?
Gmail’s built-in merge shows an error and lets you type a default, like “there”. Word can use an If…Then…Else rule to pick a different greeting. Mailmeteor takes a fallback inside the tag, as in {{ firstname | there }}.
Can I personalize the subject line of a mail merge?
Not in Gmail’s built-in merge, and Word’s merge to email takes one subject for everyone. Mailmeteor and most add-ons allow tags in the subject. A subject about the reader’s side, like “Your October invoice”, reads well without one.
Can recipients see who else got my mail merge?
No. Each person gets their own copy. Google’s help says recipients “can’t check who else you sent the message to.” People who know each other may still compare notes, so vary the opening line for them.
Can I add a different sentence for each person?
Yes. Add a column to your sheet and write one sentence per row. Put its tag where the sentence goes. Leave the cell empty for anyone who doesn’t need one.