Skip to content

Handling the replies to a mail merge

On this page

A mail merge goes out as many separate emails, so the replies come back one at a time. They land in the inbox of the address that sent them, each in its own conversation. Most are real answers: a question, a yes, a thank-you. A few are bounces and out-of-office notes. This guide covers what comes back, how to find every reply in one search, and how to settle who answers them, ideally before you press send.

Where the replies land

Every copy of a merge is a private email to one person. So every reply is a private answer to you.

  • Gmail’s built-in merge. Google’s help is direct about it: “you’ll get the recipient’s replies in separate threads.” Each person’s answer sits in its own conversation, under the copy they got. Your sent copies carry a “Sent with mail merge” banner.
  • Word and Outlook. Microsoft’s help says “Word sends an individual message to each email address.” The replies come into the Outlook inbox that sent them, like any other mail.
  • Add-ons such as YAMM or Mailmeteor. They send through your own Gmail or Outlook account, so the replies come to your inbox too. Some also mark the sheet. YAMM’s listing says it tracks whether recipients “respond, bounce or unsubscribe.”

Nobody on the list sees anyone else’s reply. Gmail’s help puts it this way: “Recipients can’t check who else you sent the message to.” A reply reaches you, plus anyone you copied on that one message.

If you haven’t sent yet, the merge itself is covered in mail merge in Gmail and mail merge in Outlook and Word.

What comes back, and what each one needs

Fifty sends rarely bring back fifty of the same thing. Here’s what usually arrives, and the one thing each needs from you.

What arrivesWhat it looks likeWhat to do
A question“Does the new rate apply to the March invoice?”Answer it, soonest first if it names a date
A yes, or what you asked forA signed form, a chosen time, “Confirmed”Mark the row as done
A thank-you“Thanks, got it”Mark the row. A reply is kind, not required
An out-of-office note“I’m away until October 14”Note the return date in the sheet
“I’ve moved on” or “wrong person”A new contact’s name, or a colleague copied inUpdate the row and write to the new person yourself
A bounceA delivery failure notice from your mail providerCheck the address for a typo, then fix the row
An answer from another addressA personal address, or an assistant replying for someoneMatch it to the row by name
An unsubscribe notice (Gmail’s merge)An email from Gmail saying someone unsubscribedMark the row so the next merge leaves them out

Two of these are worth a closer look.

Bounces. Gmail sends you an email when a message can’t be delivered. Google’s bounce page says an address-not-found bounce means “The email address doesn’t exist,” or has a slip like a stray space or a dot at the end. In Microsoft 365, the same failure shows code 5.1.1, which Microsoft’s list of delivery errors calls a “Bad destination mailbox address.” Fix the cell, then send that one person their copy on its own. Re-running the merge would send everyone a second copy.

Out-of-office notes. They’re easy to delete, but they often carry the most useful line in the batch. “I’ve left the firm, please contact Dana Ruiz” is a correction to your list. Put it in the sheet now, while it’s in front of you.

Replies keep your subject line with “Re:” in front. That makes one search enough to gather them.

In Gmail, type this into the search bar, with your own subject in the quotes:

subject:"March fee update" -from:me newer_than:7d

The subject: part finds the merge. The -from:me part hides your own sent copies. The newer_than:7d part keeps it to the last week. All three are standard Gmail search operators.

In Outlook, search for subject:"March fee update", then sort the results by sender. Outlook’s search help covers the subject: and from: keywords.

A few replies won’t match. Someone may start a new email instead of replying, or change the subject. If a row still looks silent after a day or two, search for the person’s name as well.

A distinct subject makes all of this easier. “March fee update” finds your merge. “Quick note” finds half your inbox. Keeping a mail merge personal covers writing a subject line everyone shares.

Keep a reply column in the sheet

The sheet you sent from is the best record of who answered. Add three columns to it before you send:

  • Replied. A date, or blank.
  • Status. Answered, needs an answer, bounced, or away until a date.
  • Owner. Who on your team answers this row.

Five minutes of updating after each batch of replies keeps it current. When someone asks “did the Hendersons ever get back to us?”, the sheet answers in a glance. The next time you send, the bounced and departed rows are already fixed.

If your add-on marks replies in the sheet for you, keep the Status and Owner columns anyway. A tool can tell that someone replied. Only you can tell whether the reply still needs an answer.

Decide who answers before you send

Every reply goes to the address that sent the merge. Most of the time that’s you, and that’s fine. When the right person to answer is someone else, set that up before the send, not after fifty replies have landed in your inbox.

You send it, and you answer

This is the simplest shape, and it suits most merges from a small firm. The only thing to plan is your calendar. Pick a send day with a quiet couple of days behind it, so the answers don’t sit.

You send it, and a colleague answers

Say the merge is a fee notice and your office manager handles billing questions. You have a few ways to get the replies to them.

In Gmail, set a reply-to address. Gmail lets you give your sending address a different reply-to address. Replies then go straight to your colleague. Google’s help on sending addresses shows where the setting lives. It applies to everything you send from that address, so switch it back once the merge has gone.

In Gmail, copy them on each message. Gmail’s merge allows “one recipient in the ‘Cc’ or ‘Bcc’ field in each message.” Your colleague then gets a copy of every email, and a reply-all reaches both of you. Two limits apply. Google says you can’t add a Cc when the recipients come from a spreadsheet. And a reader who presses plain Reply still reaches only you.

In Outlook with Word, Microsoft says “You cannot CC or BCC other recipients.” The cleaner route is to send the merge from the mailbox your colleague already watches, such as a shared billing address. Mail merge from a shared inbox covers how.

The answers split by client

Sometimes each client has their own person at your firm. Use the Owner column, and decide one of two routes.

  • Forward each reply to its owner. The owner answers from their own address and copies you. Their first line can make the handover easy: “Sam passed this to me, since I look after your account.”
  • Let the owners answer from your account. Gmail calls this delegation. A work or school account can add up to 1,000 delegates. Google notes that “When a delegate sends a message from your account, their email address appears,” so the client can see who wrote back.

Either way, settle it before the send. A client who asked a question deserves one answer, from one person.

Answer in the thread, one person at a time

Once someone replies, the merge is over for them. What’s left is an ordinary conversation.

  • Reply in the same thread. The client sees their own message under yours, and the history stays in one place.
  • Write to the one person. They asked about their invoice, so answer about their invoice. A second merge as the answer reads like a mailing, because it is one.
  • Take the dated questions first. A question about Friday’s deadline beats a question about next quarter.
  • Keep the thank-yous short, or let them go. “Glad it helped” is plenty, and silence is fine too.

If a reply turns into a task, like sending a revised invoice, note it on the row before you move on. The sheet then holds both who answered and what you owe them.

The people who didn’t reply

After a few days, filter the sheet for rows where Replied is blank. That’s your list of people to nudge.

Send any reminder only to those rows. A second merge to the whole list would land on people who already answered. How long to wait and what to say belong to the chasing guides. How long to wait before following up covers the timing. Following up without nagging covers the words.

Where Point comes in

Point doesn’t send mail merges. Gmail, Outlook or your add-on does that, and the sheet stays yours. Point’s part starts when the answers land in your inbox.

Point reads each reply as it arrives. The client asking whether the new rate covers March sits at the top of your feed. The out-of-office notes and the thank-yous wait further down. Under each question, a reply is drafted in your voice. By default it waits there until you’ve read it, changed what you want, and sent it. If a reply means work, like that revised invoice, Point can line it up as a task for you to approve. How Point sorts mail the moment it lands shows the sorting side, and the benefits page has the wider picture.

Common questions

Where do replies to a mail merge go?

They go to the address that sent the merge, as separate replies from each person. In Gmail, each reply arrives in its own thread. In Outlook, they arrive in the inbox of the account Word sent from. Nobody on the list sees anyone else’s reply.

How do I see who replied to my mail merge in Gmail?

Search for subject:"your subject" -from:me to list every reply in one view. Then mark each person in a Replied column in your sheet. Some add-ons, such as YAMM, mark replies in the sheet for you.

Can I make mail merge replies go to a different address?

In Gmail, yes. Give your sending address a different reply-to address, then switch it back once the merge has gone. In Outlook with Word, the simpler route is to send the merge from the mailbox that should get the replies.

What should I do with mail merge bounces?

Check the bounced address for a typo, a space or a stray dot, and fix it in the sheet. Then send that person their copy on its own. Don’t re-run the whole merge, or everyone else gets a second copy.

Can someone else answer the replies for me?

Yes. You can forward each reply to the right colleague, or give them delegate access to your Gmail. You can also send the merge from a shared mailbox they already watch. Decide before you send, so each person gets one answer from one person.

Ready for a calmer inbox?

Join the private beta

We're onboarding a few teams at a time. Leave your email, confirm it once, and we'll send an invitation the moment a place opens.

By joining you agree to our privacy policy.

Private beta

What you're joining

It runs on the mail you have

Point sits on top of Gmail or Outlook. Your address, your history and your contacts stay exactly as they are, so there is nothing to migrate.

You set how much Point does

Out of the box everything waits for your review, replies included. You hand over only what you trust, one kind of work at a time.

Join the private beta

We're onboarding a few teams at a time. Leave your email, confirm it once, and we'll send an invitation the moment a place opens.

By joining you agree to our privacy policy.