How to Fix {{Variables}} in your Mail Merge Email Template?

Mail Merge lets you send the same email message to a group of recipients. You can use {{variables}} in your email template that are directly mapped to columns of the Google Spreadsheet.

For instance, if you have a column in the spreadsheet as First Name, you can put {{First Name}} in the Gmail draft (variable enclosed in double curly braces) and it will be dynamically substituted with the actual value of the first name in the outgoing email messages.

Mail Merge will show an error when it cannot substitute the variable name with actual values from the sheet. This happens in few situations:

  1. The variable name used in the Gmail template does not exactly match the column title in the Google Spreadsheet.
  2. There’s no corresponding column in the Google sheet for the {{variable}} used in your Gmail template.
  3. The variable name in the Gmail template is formatted with multiple styles. For instance, if the variable name is {{Postal Address}}, you cannot have Postal using one style and Address using another formatting style.

Fix the Gmail Formatting Issue

The fix is relatively simple.

Open the corresponding draft in your Gmail Account, select the variable name with your mouse and click the Remove Formatting icon as show in the screenshot below.

Alternatively, you can manually remove the variable and type it again. This will ensure that the entire variable is formatted in a single style.