{"id":277,"date":"2017-02-25T17:31:55","date_gmt":"2017-02-25T17:31:55","guid":{"rendered":"http:\/\/www.gmass.co\/blog\/?p=277"},"modified":"2022-04-18T18:04:55","modified_gmt":"2022-04-18T18:04:55","slug":"why-your-gmail-mail-merge-personalization-failed","status":"publish","type":"post","link":"https:\/\/www.gmass.co\/blog\/why-your-gmail-mail-merge-personalization-failed\/","title":{"rendered":"Why your Gmail mail merge personalization failed"},"content":{"rendered":"

If you’re sending mail merge campaigns in Gmail<\/a> with GMass, or even a different mail merge\u00a0service, there are several reasons why personalization may fail. If you find that the right values aren’t being substituted for your mail merge tags<\/strong>, see if any of the below reasons are the cause.<\/p>\n

1. You sent yourself a test email, but your email address isn’t in the spreadsheet or the To field.<\/h3>\n

GMass, like many mail merge services, has a Send Test Email<\/strong> button.<\/p>\n

<\/a><\/p>\n

You can enter any email address<\/strong> and have a test email sent to that address. If, however, your campaign is set up to merge with a Google Sheets<\/strong> spreadsheet, and that spreadsheet has columns that you’re using throughout your Subject<\/strong> and Body<\/strong> for personalization, and your test email address isn’t also in the spreadsheet<\/span>, GMass won’t know what values to use<\/span> for the mail merge. Therefore, the mail merge tags will be replaced with blank values, or fallback values if you’re using fallback syntax. This is the most common reason why personalization fails.<\/strong><\/p>\n

2.<\/strong> You hit the Send<\/strong><\/span> button instead of the GMass<\/strong><\/span> button.<\/h3>\n

Despite a recent usability enhancement that hides the regular Gmail Send button<\/a> when you have many email addresses in the To<\/strong> field, there are certain situations where the Send<\/strong> button isn’t hidden and still gets clicked accidentally when the intention is to click the GMass<\/strong><\/span> button. If you do this, not only will your email not be personalized, but one single email will go to everyone in the To<\/strong> field, exposing your list to everyone on it.<\/p>\n

3. You connected to a spreadsheet but used the standard merge tags of {FirstName} and {LastName} instead of the ones specific to your spreadsheet.<\/strong><\/h3>\n

If you are attempting to personalize a mail merge campaign with the recipient’s first name, and you notice that some emails are personalized while others aren’t<\/strong>, you likely made the mistake of using {FirstName}<\/strong> as the merge tag when the column in your spreadsheet containing first names was not “FirstName”. When you do this, the first name personalization will work for email addresses that are Gmail Contacts<\/strong> where Gmail has stored the first name along with the email address, but will fail for all other email addresses<\/strong>.<\/p>\n

4. You connected to a spreadsheet, scheduled a campaign, and then deleted the spreadsheet rows before the campaign was scheduled to send.<\/h3>\n

GMass never stores the data from your spreadsheet internally. Anytime GMass needs personalization data for an email address, it queries it from your Google Sheet. If you delete the spreadsheet rows or delete the entire spreadsheet itself, GMass can’t pull the personalization data for an email address.<\/p>\n

5. Some extra HTML snuck inside your curly brackets.<\/h3>\n

If you insert a merge tag and then use the Bold<\/strong> or Italics<\/em> option, occasionally, that can mangle the HTML behind your campaign.<\/p>\n

\"Remove<\/a><\/p>\n

Behind the scenes, a bolded merge tag should look like:<\/p>\n

<b>{FirstName}<\/b><\/pre>\n
But sometimes, if it gets mangled, behind the scenes it might end up being:<\/p>\n
{<b>FirstName<\/b>}<\/pre>\n
even though on screen it looks normal.<\/p>\n
That breaks our personalization engine because GMass expects the part between the curly brackets to exactly match<\/strong> your spreadsheet column.<\/del><\/p>\n
The easiest way to fix this is to highlight the text<\/strong> and use the Gmail “Remove formatting” icon<\/strong> to remove any bold, italics, or special text styling. That will rid you of the HTML tags inside the curly brackets. Then, you can try re-styling once again.<\/del><\/p>\n
11\/18\/20 Update:<\/strong><\/span> GMass will now automatically correct situations where the HTML tags are inside the curly brackets. GMass will now move them to the outside and treat what’s left inside the curly brackets as the merge tag.<\/p>\n
6. You had an extra space before or after the curly bracket.<\/strong><\/h3>\n
<\/a>When you insert personalization tags, make sure they are inserted accurately. In most cases GMass will provide you with one-click buttons to insert your mail merge tags.<\/p>\n
The buttons will correspond to either the columns in your Google Sheets spreadsheet<\/strong> or they will be the standard personalization buttons of FirstName<\/strong>, LastName<\/strong>, and EmailAddress<\/strong>. The buttons, however, can only be used to insert the mail merge tag\u00a0into the Body<\/strong>. If you wish to personalize the Subject<\/strong>, you’ll need to copy\/paste<\/strong> the tag into the Subject<\/strong>.<\/p>\n
Resources:<\/h3>\n
For a comprehensive guide to personalization in GMass, see the Complete Guide to Mail Merge Personalization in Gmail<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"
If you’re sending mail merge campaigns in Gmail with GMass, or even a different mail merge\u00a0service, there are several reasons why personalization may fail. If you find that\u2026<\/p>\n","protected":false},"author":2,"featured_media":12946,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[8,4254,4263,4265],"tags":[],"class_list":["post-277","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-email-marketing","category-gmail-tips-and-tricks","category-personalization","category-troubleshooting"],"acf":[],"yoast_head":"\r\nWhy your Gmail mail merge personalization failed<\/title>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/www.gmass.co\/blog\/why-your-gmail-mail-merge-personalization-failed\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"Why your Gmail mail merge personalization failed\" \/>\r\n<meta property=\"og:description\" content=\"If you’re sending mail merge campaigns in Gmail with GMass, or even a different mail merge\u00a0service, there are several reasons why personalization may fail. If you find that\u2026\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/www.gmass.co\/blog\/why-your-gmail-mail-merge-personalization-failed\/\" \/>\r\n<meta property=\"og:site_name\" content=\"GMass Blog\" \/>\r\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/GmailMailMerge\/\" \/>\r\n<meta property=\"article:published_time\" content=\"2017-02-25T17:31:55+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2022-04-18T18:04:55+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2017\/02\/why-personalization-fails-featured-image-264kb.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"1001\" \/>\r\n\t<meta property=\"og:image:height\" content=\"467\" \/>\r\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\r\n<meta name=\"author\" content=\"Ajay Goel\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:creator\" content=\"@PartTimeSnob\" \/>\r\n<meta name=\"twitter:site\" content=\"@GMassForGmail\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ajay Goel\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/why-your-gmail-mail-merge-personalization-failed\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/why-your-gmail-mail-merge-personalization-failed\\\/\"},\"author\":{\"name\":\"Ajay Goel\",\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/#\\\/schema\\\/person\\\/b5fa74f8765b860701158fd77162fff8\"},\"headline\":\"Why your Gmail mail merge personalization failed\",\"datePublished\":\"2017-02-25T17:31:55+00:00\",\"dateModified\":\"2022-04-18T18:04:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/why-your-gmail-mail-merge-personalization-failed\\\/\"},\"wordCount\":738,\"commentCount\":64,\"image\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/why-your-gmail-mail-merge-personalization-failed\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/02\\\/why-personalization-fails-featured-image-264kb.png\",\"articleSection\":[\"Email Marketing\",\"Gmail Tips and Tricks\",\"Personalization\",\"Troubleshooting\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.gmass.co\\\/blog\\\/why-your-gmail-mail-merge-personalization-failed\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/why-your-gmail-mail-merge-personalization-failed\\\/\",\"url\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/why-your-gmail-mail-merge-personalization-failed\\\/\",\"name\":\"Why your Gmail mail merge personalization failed\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/why-your-gmail-mail-merge-personalization-failed\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/why-your-gmail-mail-merge-personalization-failed\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/02\\\/why-personalization-fails-featured-image-264kb.png\",\"datePublished\":\"2017-02-25T17:31:55+00:00\",\"dateModified\":\"2022-04-18T18:04:55+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/#\\\/schema\\\/person\\\/b5fa74f8765b860701158fd77162fff8\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/why-your-gmail-mail-merge-personalization-failed\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.gmass.co\\\/blog\\\/why-your-gmail-mail-merge-personalization-failed\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/why-your-gmail-mail-merge-personalization-failed\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/02\\\/why-personalization-fails-featured-image-264kb.png\",\"contentUrl\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/02\\\/why-personalization-fails-featured-image-264kb.png\",\"width\":1001,\"height\":467,\"caption\":\"why personalization fails\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/why-your-gmail-mail-merge-personalization-failed\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Why your Gmail mail merge personalization failed\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/\",\"name\":\"GMass Blog\",\"description\":\"Tips and tricks for sending mail merge and mass email campaigns directly from Gmail\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/#\\\/schema\\\/person\\\/b5fa74f8765b860701158fd77162fff8\",\"name\":\"Ajay Goel\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f3a70af05bbabe47925150d5a1320540e801b78055a74da20658fc97cd0706a2?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f3a70af05bbabe47925150d5a1320540e801b78055a74da20658fc97cd0706a2?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f3a70af05bbabe47925150d5a1320540e801b78055a74da20658fc97cd0706a2?s=96&d=mm&r=g\",\"caption\":\"Ajay Goel\"},\"description\":\"Ajay is the founder of GMass and has been developing email sending software for 20 years.\",\"sameAs\":[\"https:\\\/\\\/twitter.com\\\/PartTimeSnob\",\"https:\\\/\\\/x.com\\\/PartTimeSnob\"],\"url\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/author\\\/ajay-goel\\\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Why your Gmail mail merge personalization failed","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.gmass.co\/blog\/why-your-gmail-mail-merge-personalization-failed\/","og_locale":"en_US","og_type":"article","og_title":"Why your Gmail mail merge personalization failed","og_description":"If you’re sending mail merge campaigns in Gmail with GMass, or even a different mail merge\u00a0service, there are several reasons why personalization may fail. If you find that\u2026","og_url":"https:\/\/www.gmass.co\/blog\/why-your-gmail-mail-merge-personalization-failed\/","og_site_name":"GMass Blog","article_publisher":"https:\/\/www.facebook.com\/GmailMailMerge\/","article_published_time":"2017-02-25T17:31:55+00:00","article_modified_time":"2022-04-18T18:04:55+00:00","og_image":[{"width":1001,"height":467,"url":"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2017\/02\/why-personalization-fails-featured-image-264kb.png","type":"image\/png"}],"author":"Ajay Goel","twitter_card":"summary_large_image","twitter_creator":"@PartTimeSnob","twitter_site":"@GMassForGmail","twitter_misc":{"Written by":"Ajay Goel","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.gmass.co\/blog\/why-your-gmail-mail-merge-personalization-failed\/#article","isPartOf":{"@id":"https:\/\/www.gmass.co\/blog\/why-your-gmail-mail-merge-personalization-failed\/"},"author":{"name":"Ajay Goel","@id":"https:\/\/www.gmass.co\/blog\/#\/schema\/person\/b5fa74f8765b860701158fd77162fff8"},"headline":"Why your Gmail mail merge personalization failed","datePublished":"2017-02-25T17:31:55+00:00","dateModified":"2022-04-18T18:04:55+00:00","mainEntityOfPage":{"@id":"https:\/\/www.gmass.co\/blog\/why-your-gmail-mail-merge-personalization-failed\/"},"wordCount":738,"commentCount":64,"image":{"@id":"https:\/\/www.gmass.co\/blog\/why-your-gmail-mail-merge-personalization-failed\/#primaryimage"},"thumbnailUrl":"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2017\/02\/why-personalization-fails-featured-image-264kb.png","articleSection":["Email Marketing","Gmail Tips and Tricks","Personalization","Troubleshooting"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.gmass.co\/blog\/why-your-gmail-mail-merge-personalization-failed\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.gmass.co\/blog\/why-your-gmail-mail-merge-personalization-failed\/","url":"https:\/\/www.gmass.co\/blog\/why-your-gmail-mail-merge-personalization-failed\/","name":"Why your Gmail mail merge personalization failed","isPartOf":{"@id":"https:\/\/www.gmass.co\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.gmass.co\/blog\/why-your-gmail-mail-merge-personalization-failed\/#primaryimage"},"image":{"@id":"https:\/\/www.gmass.co\/blog\/why-your-gmail-mail-merge-personalization-failed\/#primaryimage"},"thumbnailUrl":"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2017\/02\/why-personalization-fails-featured-image-264kb.png","datePublished":"2017-02-25T17:31:55+00:00","dateModified":"2022-04-18T18:04:55+00:00","author":{"@id":"https:\/\/www.gmass.co\/blog\/#\/schema\/person\/b5fa74f8765b860701158fd77162fff8"},"breadcrumb":{"@id":"https:\/\/www.gmass.co\/blog\/why-your-gmail-mail-merge-personalization-failed\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.gmass.co\/blog\/why-your-gmail-mail-merge-personalization-failed\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.gmass.co\/blog\/why-your-gmail-mail-merge-personalization-failed\/#primaryimage","url":"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2017\/02\/why-personalization-fails-featured-image-264kb.png","contentUrl":"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2017\/02\/why-personalization-fails-featured-image-264kb.png","width":1001,"height":467,"caption":"why personalization fails"},{"@type":"BreadcrumbList","@id":"https:\/\/www.gmass.co\/blog\/why-your-gmail-mail-merge-personalization-failed\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.gmass.co\/blog\/"},{"@type":"ListItem","position":2,"name":"Why your Gmail mail merge personalization failed"}]},{"@type":"WebSite","@id":"https:\/\/www.gmass.co\/blog\/#website","url":"https:\/\/www.gmass.co\/blog\/","name":"GMass Blog","description":"Tips and tricks for sending mail merge and mass email campaigns directly from Gmail","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.gmass.co\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.gmass.co\/blog\/#\/schema\/person\/b5fa74f8765b860701158fd77162fff8","name":"Ajay Goel","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f3a70af05bbabe47925150d5a1320540e801b78055a74da20658fc97cd0706a2?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f3a70af05bbabe47925150d5a1320540e801b78055a74da20658fc97cd0706a2?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f3a70af05bbabe47925150d5a1320540e801b78055a74da20658fc97cd0706a2?s=96&d=mm&r=g","caption":"Ajay Goel"},"description":"Ajay is the founder of GMass and has been developing email sending software for 20 years.","sameAs":["https:\/\/twitter.com\/PartTimeSnob","https:\/\/x.com\/PartTimeSnob"],"url":"https:\/\/www.gmass.co\/blog\/author\/ajay-goel\/"}]}},"_links":{"self":[{"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/posts\/277","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/comments?post=277"}],"version-history":[{"count":15,"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/posts\/277\/revisions"}],"predecessor-version":[{"id":20260,"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/posts\/277\/revisions\/20260"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/media\/12946"}],"wp:attachment":[{"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/media?parent=277"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/categories?post=277"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/tags?post=277"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}