How to send a mail merge to TWO people per row
Posted: Mon Dec 09, 2024 7:24 am
What 99% of users need to do is send a personalized email to a few hundred people where each of those few hundred people get their own email, using only their email address in the To line and having the message addressed to them by their first name (e.g., “Dear John,”).
There are certain situations, however, where you may want each of your emails to go to two people instead of one, such as when a school is emailing both parents of a child. The school might want to send one email to both parents rather than two individual emails. I recently worked with a cold emailer who was emailing the athletic dominican republic phone number material departments at schools and who wanted each email to go to both the Head Coach and the Athletic Director of each school. The goal behind sending one email to two people, rather than two emails to two people, is so that each of the two people know that you’ve also emailed the other person, and so that a Reply All by either of the two would go to all three parties.
Two addresses on one mass email
This can be easily accomplished by having one person’s address in the To line and the other person’s address in the Cc line.
To send a mail merge like this, you’ll need:
A Google Sheet containing your email list
Your Gmail account
GMass installed and ready to go
Format your Google Sheet
Your spreadsheet should have at least two columns containing email addresses, since each email will go to two people, and you can think of each row of your spreadsheet as one email that will go out. The primary column, the address that will go in the To line can be named anything you like, such as “email,” “emailaddress,” or whatever you like. The second column, however, should be named “cc” or “Cc” (it’s case insensitive). That is a special keyword for a column that will instruct GMass to include the address in that column in the Cc line of every sent email.
Here’s an example spreadsheet:
Google Sheet for Two Email Addresses Per Mass Email
Now just merge as normal
Now send your mail merge just like you normally would. Click the “spreadsheet” icon butto
There are certain situations, however, where you may want each of your emails to go to two people instead of one, such as when a school is emailing both parents of a child. The school might want to send one email to both parents rather than two individual emails. I recently worked with a cold emailer who was emailing the athletic dominican republic phone number material departments at schools and who wanted each email to go to both the Head Coach and the Athletic Director of each school. The goal behind sending one email to two people, rather than two emails to two people, is so that each of the two people know that you’ve also emailed the other person, and so that a Reply All by either of the two would go to all three parties.
Two addresses on one mass email
This can be easily accomplished by having one person’s address in the To line and the other person’s address in the Cc line.
To send a mail merge like this, you’ll need:
A Google Sheet containing your email list
Your Gmail account
GMass installed and ready to go
Format your Google Sheet
Your spreadsheet should have at least two columns containing email addresses, since each email will go to two people, and you can think of each row of your spreadsheet as one email that will go out. The primary column, the address that will go in the To line can be named anything you like, such as “email,” “emailaddress,” or whatever you like. The second column, however, should be named “cc” or “Cc” (it’s case insensitive). That is a special keyword for a column that will instruct GMass to include the address in that column in the Cc line of every sent email.
Here’s an example spreadsheet:
Google Sheet for Two Email Addresses Per Mass Email
Now just merge as normal
Now send your mail merge just like you normally would. Click the “spreadsheet” icon butto