{"id":3125,"date":"2018-06-25T04:42:20","date_gmt":"2018-06-25T04:42:20","guid":{"rendered":"https:\/\/www.gmass.co\/blog\/?p=3125"},"modified":"2022-04-18T18:25:49","modified_gmt":"2022-04-18T18:25:49","slug":"personalize-entire-paragraph-mail-merge","status":"publish","type":"post","link":"https:\/\/www.gmass.co\/blog\/personalize-entire-paragraph-mail-merge\/","title":{"rendered":"How to personalize an entire paragraph in a mail merge"},"content":{"rendered":"<p>One of <strong>GMass&#8217;s<\/strong> most useful features is <a href=\"https:\/\/www.gmass.co\/blog\/mail-merge-personalization\/\">personalization<\/a>, in which any words in the email can be personalized to each recipient via a <a href=\"https:\/\/www.gmass.co\/gmail-mail-merge\">Gmail mail merge<\/a>. That could be, for example, the recipient&#8217;s first name (the difference between, &#8220;Hi Bob&#8221; instead of &#8220;Hi there&#8221;)&#8211;or any text you want to personalize.<\/p>\n<p>Recently, a few users have asked about taking personalization to the next level: <strong>putting a whole paragraph of text in a spreadsheet column, and using that in the main body of their message.<\/strong><\/p>\n<p>That is possible with <strong>GMass<\/strong>, but with an important caveat for those using <strong>HTML email campaigns <\/strong>(which most campaigns are). That caveat is this: <strong>The text in the spreadsheet must contain HTML tags.<\/strong> If not, the text will run all together, since <strong>GMass<\/strong> just replaces the %%FieldName%% with the cell&#8217;s value, and if it&#8217;s an HTML campaign, then the text runs together.<\/p>\n<p>So,\u00a0here&#8217;s how you can do it properly with <strong>GMass<\/strong>.<\/p>\n<h3>Overview<\/h3>\n<ol>\n<li><strong>Create a &#8220;{PersonalMessage}&#8221; column<\/strong> in\u00a0your\u00a0email contacts spreadsheet. This would work similarly to using a {FirstName} column, but with two differences: it will be quite a bit longer text, and it will contain HTML tags. You&#8217;ll also have to write each personal message, of course.<\/li>\n<li><strong>Create an HTML email.<\/strong> I&#8217;ve blogged <a href=\"https:\/\/www.gmass.co\/blog\/use-custom-html-in-gmail-compose-window\/\">about this<\/a> in detail before, so be sure you&#8217;re clear on how to do that by reading that email.<\/li>\n<li><strong>Modify the HTML email right in the Gmail compose window, inserting &#8220;{PersonalMessage}&#8221;<\/strong> at a location in the email that you want it to appear.<\/li>\n<li><strong>Send out using GMass!<\/strong><\/li>\n<\/ol>\n<h3>An Example: The Wedding Photographer<\/h3>\n<p>Let&#8217;s say Shelly Nguyen, a wedding photographer, wants to reach out to her customers to offer them a new selection of follow-up photography at each couple&#8217;s wedding anniversary celebration. She has a list of former customers, so needs to use GMass to do a campaign, but she also prides herself on making a personal connection with each bride and groom. She&#8217;d also love to include her lace wedding banner logo in an HTML email to the bride and\/or groom.<\/p>\n<p>Let&#8217;s look at that in detail with Shelly&#8217;s example:<\/p>\n<ol>\n<li>First, Shelly <strong>prepares her Google Docs spreadsheet.<\/strong> <strong>She adds a column called &#8220;PersonalMessage&#8221;, and then writes a personalized message<\/strong> for each customer in her spreadsheet. For simplicity&#8217;s sake, I&#8217;m just showing four customers, but there could be\u00a0essentially as many as contacts you&#8217;d like to send out to. These personal messages can be basically the same, with a few small touches to make it seem personalized.\u00a0<em>Note:\u00a0<\/em><em>She includes HTML tags, like &lt;p&gt; and &lt;\/p&gt; to\u00a0set off each paragraph, or &lt;i&gt; and &lt;\/i&gt; for italics to help control exactly how her personal message displays in the HTML email.<\/em>\n<p><figure id=\"attachment_3166\" aria-describedby=\"caption-attachment-3166\" style=\"width: 1030px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2018\/06\/fixed_shelly_smith_spreadsheet-1.gif\" data-rel=\"lightbox-image-0\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-3166 size-full\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2018\/06\/fixed_shelly_smith_spreadsheet-1.gif\" alt=\"A Google Docs spreadsheet showing some wedding photography clients.\" width=\"1030\" height=\"412\" \/><\/a><figcaption id=\"caption-attachment-3166\" class=\"wp-caption-text\">A Google Docs spreadsheet showing some wedding photography clients.<\/figcaption><\/figure><\/li>\n<li>Next, Shelly<strong> creates her HTML email<\/strong> <strong>by writing it in HTML and rendering it in a browser.<\/strong> For help with this, please see my previous blog post on <a href=\"https:\/\/www.gmass.co\/blog\/use-custom-html-in-gmail-compose-window\/\">How to use custom HTML in a Gmail compose window<\/a>. Here is her HTML email shown in a browser window&#8211;but\u00a0<em>without\u00a0<\/em>the personal message included yet.\n<p><figure id=\"attachment_3141\" aria-describedby=\"caption-attachment-3141\" style=\"width: 748px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2018\/06\/ShellyHTMLinBrowser-2.gif\" data-rel=\"lightbox-image-1\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-3141 size-full\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2018\/06\/ShellyHTMLinBrowser-2.gif\" alt=\"The HTML email, as rendered in browser. Note no personal message yet.\" width=\"748\" height=\"637\" \/><\/a><figcaption id=\"caption-attachment-3141\" class=\"wp-caption-text\">The HTML email, as rendered in browser. Note no personal message yet.<\/figcaption><\/figure><\/li>\n<li>She then <strong>starts to create a GMass campaign by clicking the spreadsheet button<\/strong>, which looks like this:\n<p><figure id=\"attachment_3130\" aria-describedby=\"caption-attachment-3130\" style=\"width: 391px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2018\/06\/spreadsheetButton_NewGmail.gif\" data-rel=\"lightbox-image-2\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-3130 size-full\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2018\/06\/spreadsheetButton_NewGmail.gif\" alt=\"GMass spreadsheet button, found at the top of Gmail page\" width=\"391\" height=\"92\" \/><\/a><figcaption id=\"caption-attachment-3130\" class=\"wp-caption-text\">GMass spreadsheet button, found at the top of Gmail page<\/figcaption><\/figure><\/li>\n<li><strong>She chooses the correct spreadsheet<\/strong>&#8211;in this case, the one associated with her photography business.\n<p><figure id=\"attachment_3131\" aria-describedby=\"caption-attachment-3131\" style=\"width: 521px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2018\/06\/ConnectingToShellySpreadsheet.gif\" data-rel=\"lightbox-image-3\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3131\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2018\/06\/ConnectingToShellySpreadsheet.gif\" alt=\"Choosing the correct Google Sheets spreadsheet.\" width=\"521\" height=\"365\" \/><\/a><figcaption id=\"caption-attachment-3131\" class=\"wp-caption-text\">Choosing the correct Google Sheets spreadsheet.<\/figcaption><\/figure><\/li>\n<li>Then she <strong>connects to that spreadsheet.<\/strong>\n<figure id=\"attachment_3132\" aria-describedby=\"caption-attachment-3132\" style=\"width: 521px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2018\/06\/ShellyReadyToConnectToSpreadsheet.gif\" data-rel=\"lightbox-image-4\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3132\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2018\/06\/ShellyReadyToConnectToSpreadsheet.gif\" alt=\"About to connect to the appropriate spreadsheet.\" width=\"521\" height=\"365\" \/><\/a><figcaption id=\"caption-attachment-3132\" class=\"wp-caption-text\">About to connect to the appropriate spreadsheet.<\/figcaption><\/figure>\n<p>A\u00a0<strong>Gmail Compose window\u00a0<\/strong>will be created.<strong>\u00a0<\/strong><\/li>\n<li>Now Shelly needs to copy the HTML email from the browser page. <strong>She goes to that browser window, clicks in it anywhere, hits Ctrl-A to select all (everything will be shaded blue), then Ctrl-C to copy into the clipboard.<\/strong><\/li>\n<li>She then immediately goes back Into the\u00a0<strong>Gmail Compose window\u00a0that is open and pastes in the HTML.<\/strong> Now the Gmail window looks like this (it&#8217;s still not quite done yet, though):\n<p><figure id=\"attachment_3143\" aria-describedby=\"caption-attachment-3143\" style=\"width: 1096px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2018\/06\/HTML_Email_beforePersonalMessage-3.gif\" data-rel=\"lightbox-image-5\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-3143 size-full\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2018\/06\/HTML_Email_beforePersonalMessage-3.gif\" alt=\"HTML email shown in Gmail compose window. Not quite done yet, though.\" width=\"1096\" height=\"699\" \/><\/a><figcaption id=\"caption-attachment-3143\" class=\"wp-caption-text\">HTML email shown in Gmail compose window. Not quite done yet, though.<\/figcaption><\/figure><\/li>\n<li>Now Shelly must modify this HTML email directly. To do so, she simply can <strong>click into the email to the left of the start of the first paragraph, and insert the &#8220;{PersonalMessage}&#8221; variable <\/strong>and then also add a blank line by hitting\u00a0&#8220;Enter&#8221; twice. You can either type &#8220;{PersonalMessage}&#8221; directly or use the personalization buttons in the <a href=\"https:\/\/www.gmass.co\/blog\/users-guide-to-the-gmass-settings-box\/\">GMass Settings box<\/a>.<em>Note:\u00a0Of course, in your own personalized emails, you can put the text wherever you want.<\/em>The resulting HTML email will look like this in the <strong>Gmail Compose window<\/strong>:\n<p><figure id=\"attachment_3170\" aria-describedby=\"caption-attachment-3170\" style=\"width: 1095px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2018\/06\/shelly_wedding_tag_highlighted.gif\" data-rel=\"lightbox-image-6\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-3170 size-full\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2018\/06\/shelly_wedding_tag_highlighted.gif\" alt=\"Gmail Compose Window now that Shelly has added {PersonalMessage} text.\" width=\"1095\" height=\"567\" \/><\/a><figcaption id=\"caption-attachment-3170\" class=\"wp-caption-text\">Gmail Compose Window now that Shelly has added {PersonalMessage} text.<\/figcaption><\/figure><\/li>\n<li>The HTML email is now ready to go&#8211;<strong>Shelly just hits the red <span style=\"color: #ff0000;\">GMass<\/span> button, as shown above.<\/strong><\/li>\n<li><strong>Now let&#8217;s see the result.<\/strong> Here is the email received by her customer, Tammy Bey as shown in Gmail.\n<figure id=\"attachment_3167\" aria-describedby=\"caption-attachment-3167\" style=\"width: 1278px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2018\/06\/shelly_wedding_highlighted_1.gif\" data-rel=\"lightbox-image-7\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-3167 size-full\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2018\/06\/shelly_wedding_highlighted_1.gif\" alt=\"The received multi-lined text personalized HTML email shown in the browser.\" width=\"1278\" height=\"765\" \/><\/a><figcaption id=\"caption-attachment-3167\" class=\"wp-caption-text\">The received multi-lined text personalized HTML email shown in the browser.<\/figcaption><\/figure>\n<p>And this is a close-up of the whole email that the recipient would read:<\/p>\n<p><figure id=\"attachment_3168\" aria-describedby=\"caption-attachment-3168\" style=\"width: 831px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2018\/06\/shelly_wedding_highlighted_2.gif\" data-rel=\"lightbox-image-8\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-3168 size-full\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2018\/06\/shelly_wedding_highlighted_2.gif\" alt=\"A detail of the email received.\" width=\"831\" height=\"851\" \/><\/a><figcaption id=\"caption-attachment-3168\" class=\"wp-caption-text\">A detail of the email received.<\/figcaption><\/figure><\/li>\n<\/ol>\n<p>That&#8217;s all there is to it!<\/p>\n<h3>Bonus: Two &#8220;Advanced&#8221; Techniques<\/h3>\n<ul>\n<li>There&#8217;s nothing preventing you from <strong>having an {OpeningPersonalizedMessage} as well as a {ClosingPersonalizedMessage},<\/strong> right? This may really work well to give a truer sense of personalization, and would not be hard to implement at all. Just add another column.<\/li>\n<li>If you want to get fancy<em>,<\/em>\u00a0remember that <strong>GMass will substitute <em>any<\/em> text (and HTML tags) that you put in a Google Sheets spreadsheet,<\/strong> as long as the tag with curly braces, like {PersonalMessage} or {FirstName}, is used. If you think about it, you could use this fact to build as complex and personalized an email you could want. So, in our wedding photographer example, you could have spreadsheet columns for {ShootingLocation}, {MothersName}, {DressDesigner}, {CakeType}, and whatever else the photographer might want to mention. Then, you could use these to do even more personalizing. However, do note that <em>you cannot put another GMass tag within a spreadsheet cell.<\/em>\u00a0Instead, you would have to use place various tags into the HTML email carefully yourself, send it to yourself as a test to work the kinks out of it, and then send it to the recipient. In most cases, this would get probably more complex than you would want to take on, but it&#8217;s good to note that option of building arbitrarily complex personalization is there if you want it.<\/li>\n<\/ul>\n<h3>Other Use Cases<\/h3>\n<p>In addition to wedding photographers, multi-line personalization is useful for many cases in which you want to make a personal connection with the recipient but wish to use a bit more than just their name. Here are some ideas for how use this feature:<\/p>\n<ul>\n<li><strong>Sales emails<\/strong> in which you know\u00a0some facts about the customer. That could be something as simple as a\u00a0suggestion from a mutual acquaintance to reach out to the potential customer.<\/li>\n<li><strong>Press releases<\/strong> to journalists, in which you might want to include a section of the email as the specific pitch to that publication, noting how your product or service fits into their publication niche.<\/li>\n<li><strong>Product notes<\/strong> to vendors you work with. In this case, you could update the vendor about what has changed with your product but also get in a quick\u00a0personal &#8220;hello&#8221; and inquiries about their own business. Everyone appreciates this kind of touch.<\/li>\n<li>The<strong> annual end-of-the-year email<\/strong> to family, friends, colleagues, or employees. You could include a nice personalized note at the start of your letter.<\/li>\n<li><strong>Quarterly emails to one&#8217;s employees.\u00a0<\/strong>You could include a brief note to the employee and remarks on his or her own performance and how it tied into the company&#8217;s quarter. Of course, employees may share these emails, revealing that it is partly a form letter and partly personalized, but this probably won&#8217;t seem inappropriate.<\/li>\n<li><strong>A teacher&#8217;s emails to parents.<\/strong>\u00a0The personalized portion can be about they and their child particularly, but the rest of the HTML email can be standardized content that talks about how the school year is going and includes some fun school-related images.<\/li>\n<li><strong>Letters to publishers or agents<\/strong>, shopping around a manuscript or other intellectual property. In this case, one could highlight how the author&#8217;s offering matches well to each particular publisher&#8217;s typical content.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>One of GMass&#8217;s most useful features is personalization, in which any words in the email can be personalized to each recipient via a Gmail mail merge. That could\u2026<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[4254,4263],"tags":[],"class_list":["post-3125","post","type-post","status-publish","format-standard","hentry","category-gmail-tips-and-tricks","category-personalization"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\r\n<title>How to personalize an entire paragraph in a mail merge<\/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\/personalize-entire-paragraph-mail-merge\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"How to personalize an entire paragraph in a mail merge\" \/>\r\n<meta property=\"og:description\" content=\"One of GMass&#8217;s most useful features is personalization, in which any words in the email can be personalized to each recipient via a Gmail mail merge. That could\u2026\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/www.gmass.co\/blog\/personalize-entire-paragraph-mail-merge\/\" \/>\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=\"2018-06-25T04:42:20+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2022-04-18T18:25:49+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2018\/06\/fixed_shelly_smith_spreadsheet-1.gif\" \/>\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=\"7 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\\\/personalize-entire-paragraph-mail-merge\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/personalize-entire-paragraph-mail-merge\\\/\"},\"author\":{\"name\":\"Ajay Goel\",\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/#\\\/schema\\\/person\\\/b5fa74f8765b860701158fd77162fff8\"},\"headline\":\"How to personalize an entire paragraph in a mail merge\",\"datePublished\":\"2018-06-25T04:42:20+00:00\",\"dateModified\":\"2022-04-18T18:25:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/personalize-entire-paragraph-mail-merge\\\/\"},\"wordCount\":1480,\"commentCount\":12,\"image\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/personalize-entire-paragraph-mail-merge\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/06\\\/fixed_shelly_smith_spreadsheet-1.gif\",\"articleSection\":[\"Gmail Tips and Tricks\",\"Personalization\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.gmass.co\\\/blog\\\/personalize-entire-paragraph-mail-merge\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/personalize-entire-paragraph-mail-merge\\\/\",\"url\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/personalize-entire-paragraph-mail-merge\\\/\",\"name\":\"How to personalize an entire paragraph in a mail merge\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/personalize-entire-paragraph-mail-merge\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/personalize-entire-paragraph-mail-merge\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/06\\\/fixed_shelly_smith_spreadsheet-1.gif\",\"datePublished\":\"2018-06-25T04:42:20+00:00\",\"dateModified\":\"2022-04-18T18:25:49+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/#\\\/schema\\\/person\\\/b5fa74f8765b860701158fd77162fff8\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/personalize-entire-paragraph-mail-merge\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.gmass.co\\\/blog\\\/personalize-entire-paragraph-mail-merge\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/personalize-entire-paragraph-mail-merge\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/06\\\/fixed_shelly_smith_spreadsheet-1.gif\",\"contentUrl\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/06\\\/fixed_shelly_smith_spreadsheet-1.gif\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/personalize-entire-paragraph-mail-merge\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to personalize an entire paragraph in a mail merge\"}]},{\"@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":"How to personalize an entire paragraph in a mail merge","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\/personalize-entire-paragraph-mail-merge\/","og_locale":"en_US","og_type":"article","og_title":"How to personalize an entire paragraph in a mail merge","og_description":"One of GMass&#8217;s most useful features is personalization, in which any words in the email can be personalized to each recipient via a Gmail mail merge. That could\u2026","og_url":"https:\/\/www.gmass.co\/blog\/personalize-entire-paragraph-mail-merge\/","og_site_name":"GMass Blog","article_publisher":"https:\/\/www.facebook.com\/GmailMailMerge\/","article_published_time":"2018-06-25T04:42:20+00:00","article_modified_time":"2022-04-18T18:25:49+00:00","og_image":[{"url":"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2018\/06\/fixed_shelly_smith_spreadsheet-1.gif","type":"","width":"","height":""}],"author":"Ajay Goel","twitter_card":"summary_large_image","twitter_creator":"@PartTimeSnob","twitter_site":"@GMassForGmail","twitter_misc":{"Written by":"Ajay Goel","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.gmass.co\/blog\/personalize-entire-paragraph-mail-merge\/#article","isPartOf":{"@id":"https:\/\/www.gmass.co\/blog\/personalize-entire-paragraph-mail-merge\/"},"author":{"name":"Ajay Goel","@id":"https:\/\/www.gmass.co\/blog\/#\/schema\/person\/b5fa74f8765b860701158fd77162fff8"},"headline":"How to personalize an entire paragraph in a mail merge","datePublished":"2018-06-25T04:42:20+00:00","dateModified":"2022-04-18T18:25:49+00:00","mainEntityOfPage":{"@id":"https:\/\/www.gmass.co\/blog\/personalize-entire-paragraph-mail-merge\/"},"wordCount":1480,"commentCount":12,"image":{"@id":"https:\/\/www.gmass.co\/blog\/personalize-entire-paragraph-mail-merge\/#primaryimage"},"thumbnailUrl":"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2018\/06\/fixed_shelly_smith_spreadsheet-1.gif","articleSection":["Gmail Tips and Tricks","Personalization"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.gmass.co\/blog\/personalize-entire-paragraph-mail-merge\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.gmass.co\/blog\/personalize-entire-paragraph-mail-merge\/","url":"https:\/\/www.gmass.co\/blog\/personalize-entire-paragraph-mail-merge\/","name":"How to personalize an entire paragraph in a mail merge","isPartOf":{"@id":"https:\/\/www.gmass.co\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.gmass.co\/blog\/personalize-entire-paragraph-mail-merge\/#primaryimage"},"image":{"@id":"https:\/\/www.gmass.co\/blog\/personalize-entire-paragraph-mail-merge\/#primaryimage"},"thumbnailUrl":"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2018\/06\/fixed_shelly_smith_spreadsheet-1.gif","datePublished":"2018-06-25T04:42:20+00:00","dateModified":"2022-04-18T18:25:49+00:00","author":{"@id":"https:\/\/www.gmass.co\/blog\/#\/schema\/person\/b5fa74f8765b860701158fd77162fff8"},"breadcrumb":{"@id":"https:\/\/www.gmass.co\/blog\/personalize-entire-paragraph-mail-merge\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.gmass.co\/blog\/personalize-entire-paragraph-mail-merge\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.gmass.co\/blog\/personalize-entire-paragraph-mail-merge\/#primaryimage","url":"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2018\/06\/fixed_shelly_smith_spreadsheet-1.gif","contentUrl":"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2018\/06\/fixed_shelly_smith_spreadsheet-1.gif"},{"@type":"BreadcrumbList","@id":"https:\/\/www.gmass.co\/blog\/personalize-entire-paragraph-mail-merge\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.gmass.co\/blog\/"},{"@type":"ListItem","position":2,"name":"How to personalize an entire paragraph in a mail merge"}]},{"@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\/3125","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=3125"}],"version-history":[{"count":21,"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/posts\/3125\/revisions"}],"predecessor-version":[{"id":20273,"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/posts\/3125\/revisions\/20273"}],"wp:attachment":[{"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/media?parent=3125"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/categories?post=3125"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/tags?post=3125"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}