Secret Feature: Set the Cc and Bcc fields in a mail merge from a spreadsheet column

Most GMass users know that you can send a personalized mail merge campaign using GMass and your Gmail account with a Google Sheets spreadsheet. Any of the columns in the spreadsheet can be used to personalize the Subject and Message.

Did you know you can also personalize the Cc and Bcc fields? Meaning, you can have each individual email message Cc’d or Bcc’d to an email address associated with the address you’re sending to.

An example: You’re sending 100 emails to 100 of your customers, but you want each email to be Cc’d to each individual customer’s account manager. Each of the 100 customers has a different account manager, so you can’t just enter a single email address in the Cc field of the Gmail Compose window. Instead, create a column called “cc” in the spreadsheet you’re using, and specify the account manager’s email address in the “cc” column.

Your spreadsheet might look like this:

A spreadsheet with a “cc” column. The email address in the “cc” column will be used as the Cc for each email sent to the “EmailAddress” column. Note that the “cc” column comes after the “EmailAddress” column.

Make sure that the “cc” column comes after the column with the actual recipient email addresses so that GMass doesn’t accidentally use the “cc” column as the recipient To addresses (since GMass auto-detects the column containing recipient email addresses).

When you connect to the spreadsheet inside Gmail, the Compose window will be launched with the recipient addresses in the To field.

The Cc field will show as blank, but as long as you have a “cc” column in your spreadsheet, each email message will be Cc’d to the address from the spreadsheet.

The “Cc” field in the Gmail Compose window will remain blank.

Similarly, you can set a personalized Bcc address by creating a column called “bcc” in your spreadsheet. Again, make sure the “bcc” column is to the right of the column containing the actual recipient email addresses.

4 Replies to “Secret Feature: Set the Cc and Bcc fields in a mail merge from a spreadsheet column”

Leave a Reply

Your email address will not be published. Required fields are marked *