{"id":14582,"date":"2019-08-31T16:26:21","date_gmt":"2019-08-31T16:26:21","guid":{"rendered":"https:\/\/www.saleshandy.com\/blog\/?p=14582"},"modified":"2023-01-18T11:44:07","modified_gmt":"2023-01-18T11:44:07","slug":"create-mail-merge-gmail","status":"publish","type":"post","link":"https:\/\/www.saleshandy.com\/blog\/create-mail-merge-gmail\/","title":{"rendered":"How to Create Mail Merge in Gmail"},"content":{"rendered":"<div id=\"toc_container\" class=\"toc_wrap_right toc_transparent no_bullets\"><p class=\"toc_title\">Contents<\/p><ul class=\"toc_list\"><li><a href=\"#Steps-to-setup-mail-merge-in-Gmail\"><strong class=\"Steps-to-setup-mail-merge-in-Gmail\"><span class=\"toc_number toc_depth_1\">1<\/span> Steps to setup mail merge in Gmail<\/strong><\/a><\/li><li><a href=\"#Benefits-of-setup-and-send-mail-merge-from-Gmail\"><strong class=\"Benefits-of-setup-and-send-mail-merge-from-Gmail\"><span class=\"toc_number toc_depth_1\">2<\/span> Benefits of setup and send mail merge from Gmail<\/strong><\/a><ul><li><a href=\"#Data-and-Reports\"><strong class=\"Data-and-Reports\"><span class=\"toc_number toc_depth_2\">2.1<\/span> Data and Reports<\/strong><\/a><\/li><li><a href=\"#Save-time-and-boost-your-productivity\"><strong class=\"Save-time-and-boost-your-productivity\"><span class=\"toc_number toc_depth_2\">2.2<\/span> Save time and boost your productivity<\/strong><\/a><\/li><li><a href=\"#Send-mail-merge-with-an-attachment-from-Gmail\"><strong class=\"Send-mail-merge-with-an-attachment-from-Gmail\"><span class=\"toc_number toc_depth_2\">2.3<\/span> Send mail merge with an attachment from Gmail<\/strong><\/a><\/li><li><a href=\"#Send-personalized-email-using-advanced-features\"><strong class=\"Send-personalized-email-using-advanced-features\"><span class=\"toc_number toc_depth_2\">2.4<\/span> Send personalized email using advanced features <\/strong><\/a><\/li><\/ul><\/li><li><a href=\"#Limitations-of-Mail-merge-from-Gmail\"><strong class=\"Limitations-of-Mail-merge-from-Gmail\"><span class=\"toc_number toc_depth_1\">3<\/span> Limitations of Mail merge from Gmail<\/strong><\/a><ul><li><a href=\"#Building-a-Mailing-list-is-a-long-process\"><strong class=\"Building-a-Mailing-list-is-a-long-process\"><span class=\"toc_number toc_depth_2\">3.1<\/span> Building a Mailing list is a long process<\/strong><\/a><\/li><li><a href=\"#Sending-Limits\"><strong class=\"Sending-Limits\"><span class=\"toc_number toc_depth_2\">3.2<\/span> Sending Limits<\/strong><\/a><\/li><\/ul><\/li><li><a href=\"#Video-guide-on-setup-mail-merge-in-Gmail\"><strong class=\"Video-guide-on-setup-mail-merge-in-Gmail\"><span class=\"toc_number toc_depth_1\">4<\/span> Video guide on setup mail merge in Gmail<\/strong><\/a><\/li><li><a href=\"#Conclusion\"><strong class=\"Conclusion\"><span class=\"toc_number toc_depth_1\">5<\/span> Conclusion<\/strong><\/a><\/li><\/ul><\/div>\n\n<p>Personalization is extremely important while sending an email. If you send multiple emails per day, it becomes difficult to personalize each and every email that you send. To solve this problem and automate the personalization, you can send a mail merge campaign (sequence) from Gmail. It will make sure that your open rate (the number of opens every email sent) increases and so does your reply rate. <\/p>\n\n\n\n<p>You need to give your recipients a feeling of belongingness with your email. This is necessary because it makes your leads, prospects, candidates, and customers feel an important part of your conversation.<\/p>\n\n\n\n<!--more-->\n\n\n\n<p>In this blog, we will explain a step-by-step method of sending a mail merge email in Gmail. So, without any further ado, let&#8217;s get into it.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"Steps\"><span id=\"Steps-to-setup-mail-merge-in-Gmail\">Steps to setup mail merge in Gmail<\/span><\/h2>\n\n\n\n<p><strong>Step 1: Connect your Gmail account with Saleshandy.<\/strong><\/p>\n\n\n\n<p>We have a free trial period of 7 days. You do not require to give any credit card or payment details. You can give it a try for free <a href=\"https:\/\/www.saleshandy.com\/signup\/?p=v3\" target=\"_blank\" rel=\"noreferrer noopener\">here.<\/a><\/p>\n\n\n\n<p><strong>Step 2: Create a New Sequence&nbsp;<\/strong><\/p>\n\n\n\n<p>Now, from the main dashboard, head to Sequences &gt; Create Sequence<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img fetchpriority=\"high\" decoding=\"async\" width=\"2915\" height=\"747\" src=\"https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2018\/09\/create-sequence-1.png\" alt=\"Create your email sequence \" class=\"wp-image-31758\" srcset=\"https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2018\/09\/create-sequence-1.png 2915w, https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2018\/09\/create-sequence-1-475x122.png 475w, https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2018\/09\/create-sequence-1-900x231.png 900w, https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2018\/09\/create-sequence-1-768x197.png 768w, https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2018\/09\/create-sequence-1-1536x394.png 1536w, https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2018\/09\/create-sequence-1-2048x525.png 2048w, https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2018\/09\/create-sequence-1-1200x308.png 1200w, https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2018\/09\/create-sequence-1-1980x507.png 1980w, https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2018\/09\/create-sequence-1-150x38.png 150w\" sizes=\"(max-width: 2915px) 100vw, 2915px\" \/><\/figure>\n\n\n\n<p><strong>Step 3: Start composing your email using mail merge&nbsp;<\/strong><\/p>\n\n\n\n<p>Here click on the +Add step and start composing your email. Write your email, subject line, and pre-header using the merge tags. Add a good mix of personalized tags, and to ensure you don&#8217;t go overboard, we give you a personalization score.&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"900\" height=\"499\" src=\"https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2022\/09\/Email-personalization-using-Saleshandy-merge-tags.jpg\" alt=\"Personalizing cold email using Saleshandy merge tag feature\" class=\"wp-image-29986\" srcset=\"https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2022\/09\/Email-personalization-using-Saleshandy-merge-tags.jpg 900w, https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2022\/09\/Email-personalization-using-Saleshandy-merge-tags-361x200.jpg 361w, https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2022\/09\/Email-personalization-using-Saleshandy-merge-tags-768x426.jpg 768w, https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2022\/09\/Email-personalization-using-Saleshandy-merge-tags-150x83.jpg 150w\" sizes=\"(max-width: 900px) 100vw, 900px\" \/><\/figure>\n\n\n\n<p><strong>Step 4: Upload your recipient\u2019s list.<\/strong><\/p>\n\n\n\n<p>This list is a very vital part of your sequence. This list will help you send an effective mail merge campaign (sequence). You need to make sure that you put effort into building this list.&nbsp; Move to the prospects tab from the sequence to upload your CSV list, or you can add prospects manually.<\/p>\n\n\n\n<p>If you are uploading a CSV list, make sure to include merge tags in it. It might be confusing for you, so download this sample CSV. You will easily understand how to make a CSV file to send a mail merge campaign (sequence) in Gmail. <a href=\"https:\/\/shpermalink.s3.amazonaws.com\/app.sh.com\/saleshandy-campaign-sample-csv-file.csv\" target=\"_blank\" rel=\"noreferrer noopener\">Download a sample CSV from here.<\/a><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1920\" height=\"593\" src=\"https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2018\/09\/Add-prospects-1.png\" alt=\"Add prospects\" class=\"wp-image-31748\" srcset=\"https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2018\/09\/Add-prospects-1.png 1920w, https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2018\/09\/Add-prospects-1-475x147.png 475w, https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2018\/09\/Add-prospects-1-900x278.png 900w, https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2018\/09\/Add-prospects-1-768x237.png 768w, https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2018\/09\/Add-prospects-1-1536x474.png 1536w, https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2018\/09\/Add-prospects-1-1200x371.png 1200w, https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2018\/09\/Add-prospects-1-150x46.png 150w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/figure>\n\n\n\n<p><strong>Step 5:<\/strong> <strong>Schedule your sequence.<\/strong><\/p>\n\n\n\n<p>It is necessary to schedule your sequence at the time you think your recipients would be most active. If your recipients receive a business email at 10 PM, there are chances they will ignore it. Make sure you know the best time to send your email, and you schedule your emails according to the time zone of your recipients. Saleshandy gives you the option to schedule it according to different time zones.<\/p>\n\n\n\n<p>Head to Settings &gt; Schedules &gt;Add new schedule.&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1543\" height=\"684\" src=\"https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2018\/09\/Schedule-your-email.png\" alt=\"Schedule your email\" class=\"wp-image-31747\" srcset=\"https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2018\/09\/Schedule-your-email.png 1543w, https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2018\/09\/Schedule-your-email-451x200.png 451w, https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2018\/09\/Schedule-your-email-900x399.png 900w, https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2018\/09\/Schedule-your-email-768x340.png 768w, https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2018\/09\/Schedule-your-email-1536x681.png 1536w, https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2018\/09\/Schedule-your-email-1200x532.png 1200w, https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2018\/09\/Schedule-your-email-150x66.png 150w\" sizes=\"(max-width: 1543px) 100vw, 1543px\" \/><\/figure>\n\n\n\n<p><strong>Step 6 &#8211; Activate your sequence<\/strong><\/p>\n\n\n\n<p>Now the last step, head back to your sequence and activate it. It would be draft mode, just turn on the toggle, and Saleshandy will start sending your email at the scheduled time.&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1912\" height=\"458\" src=\"https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2018\/09\/activate-your-sequence.png\" alt=\"Activate your sequence\" class=\"wp-image-31743\" srcset=\"https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2018\/09\/activate-your-sequence.png 1912w, https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2018\/09\/activate-your-sequence-475x114.png 475w, https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2018\/09\/activate-your-sequence-900x216.png 900w, https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2018\/09\/activate-your-sequence-768x184.png 768w, https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2018\/09\/activate-your-sequence-1536x368.png 1536w, https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2018\/09\/activate-your-sequence-1200x287.png 1200w, https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2018\/09\/activate-your-sequence-150x36.png 150w\" sizes=\"(max-width: 1912px) 100vw, 1912px\" \/><\/figure>\n\n\n\n<div class=\"wp-block-buttons is-content-justification-center is-layout-flex wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link\" href=\"https:\/\/www.saleshandy.com\/signup\/?p=v3\">Send your first sequence for free!<\/a><\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"Benefits\"><span id=\"Benefits-of-setup-and-send-mail-merge-from-Gmail\">Benefits of setup and send mail merge from Gmail<\/span><\/h2>\n\n\n\n<p>After understanding how exactly you are supposed to send a mail merge campaign (sequence) with Gmail, let\u2019s understand what are the benefits of sending it.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span id=\"Data-and-Reports\">Data and Reports<\/span><\/h3>\n\n\n\n<p>After your campaign (sequence) has been successfully sent, you will get a detailed report on it. This includes the information regarding total open rates, link open rates, attachment open rates, reply rate, and more. You can analyze and understand which type of emails work more and which type of emails don\u2019t. You will start receiving 100% effective results once you do a little trial and error with your emails.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span id=\"Save-time-and-boost-your-productivity\">Save time and boost your productivity<\/span><\/h3>\n\n\n\n<p>In this era of information technology, time is money and the more time you have the better edge you get. With mail merge email campaigns (sequences), you are saving hours of your time. We automate the emails for you and you can work on something more productive while all your email work is being done by us. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span id=\"Send-mail-merge-with-an-attachment-from-Gmail\">Send mail merge with an attachment from Gmail<\/span><\/h3>\n\n\n\n<p>You will not just be able to send personalized emails to multiple people at the same time, but you will also be able to send attachments in this mail merge campaign (sequence). <\/p>\n\n\n\n<p>We will track the attachment for you and let you know exact details of the recipient\u2019s engagement on it. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span id=\"Send-personalized-email-using-advanced-features\">Send personalized email using advanced features <\/span><\/h3>\n\n\n\n<p>Imagine receiving these two emails today.<\/p>\n\n\n\n<p><strong>One from ABC company \u2013<\/strong><\/p>\n\n\n\n<p>Hey prospect,<\/p>\n\n\n\n<p>I saw you visiting our site, would you like to take a tour of our dashboard for free?&nbsp;<\/p>\n\n\n\n<p>Let me know if you would be interested.<\/p>\n\n\n\n<p>Thanks,<\/p>\n\n\n\n<p>ABC Company<\/p>\n\n\n\n<p><strong>One from XYZ company \u2013<\/strong><\/p>\n\n\n\n<p>&nbsp;Hey John,<\/p>\n\n\n\n<p>I am Terry from XYZ company, and I noticed you visited our site. Would you like to take a tour of our dashboard for free?<\/p>\n\n\n\n<p>Let me know if you would be interested.<\/p>\n\n\n\n<p>Thanks,<\/p>\n\n\n\n<p>XYZ Company.<\/p>\n\n\n\n<p>Of course, the XYZ company email would attract more eyeballs. It is just human nature to have a biased toward the personalized touch.&nbsp;&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"Limitations\"><span id=\"Limitations-of-Mail-merge-from-Gmail\">Limitations of Mail merge from Gmail<\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span id=\"Building-a-Mailing-list-is-a-long-process\">Building a Mailing list is a long process<\/span><\/h3>\n\n\n\n<p>This is one of the two limitations that you will have of sending a mail merge campaign from Gmail. It will take a little time to build a mailing list. Few people rent third party list in order to send emails. We suggest you build your own list of people who have opted-in to receive your emails. This will help you in the long run.<\/p>\n\n\n\n<p>This limitation is in a way benefit in disguise. It helps you develop a pool of your email addresses. You will be in contact with and developing a network with your audience. That\u2019s not at all a limitation, right?<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span id=\"Sending-Limits\">Sending Limits<\/span><\/h3>\n\n\n\n<p>You can not send an unlimited amount of emails from one account. Gmail limits people who send more than a certain number of emails in a day in order to stop spammers. If you have a long list of recipients ready to receive your emails, you should know&nbsp;<a href=\"https:\/\/www.saleshandy.com\/blog\/send-10000-emails-using-gmail\/\">how to send 10000 emails in a day<\/a>. If you have a smaller mailing list, there is nothing to be worried about.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"video\"><span id=\"Video-guide-on-setup-mail-merge-in-Gmail\">Video guide on setup mail merge in Gmail<\/span><\/h2>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"Saleshandy 3.0 \ud83d\ude80 | How To Create Email Sequences in Saleshandy 3.0 \ud83d\udce7\" width=\"580\" height=\"326\" src=\"https:\/\/www.youtube.com\/embed\/E80d03dIXkI?start=1&#038;feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"Conclusion\"><span id=\"Conclusion\">Conclusion<\/span><\/h2>\n\n\n\n<p>Sending an email campaign (sequence) with mail merge is easy, effective and productive. It helps you to make sure that all your emails have a personalized touch and a feeling of belongingness in it. <\/p>\n\n\n\n<p>It has proven to generate more open rates and it also helps you automate all your work while you work on something even more important. It is an absolute win. Make sure you start your 7-day free trial now.<\/p>\n\n\n\n<div class=\"wp-block-button aligncenter\"><a class=\"wp-block-button__link\" href=\"https:\/\/www.saleshandy.com\/signup\/?p=v3\">Start the Free Trial!<\/a><\/div>\n\n\n\n<p>I hope you got the exact idea on how to send a mail merge campaign (sequence) from Gmail. Thanks for reading. Until next time.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Personalization is extremely important while sending an email. If you send multiple emails per day, it becomes difficult to personalize each and every email that you send. To solve this problem and automate the personalization, you can send a mail merge campaign (sequence) from Gmail. It will make sure that your open rate (the number [&hellip;]<\/p>\n","protected":false},"author":47,"featured_media":31901,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_eb_attr":"","is_display_hero_banner_button1":"","is_display_hero_banner_button2":"","hero_banner_button1_text":"","hero_banner_button2_text":"","hero_banner_button1_url":"","hero_banner_button2_url":"","footnotes":""},"categories":[987],"tags":[],"class_list":["post-14582","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cold-emailing"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to create Mail merge in Gmail |Saleshandy<\/title>\n<meta name=\"description\" content=\"Send personalized emails with mail merge in Gmail with just a few clicks. Automate personalization with Saleshandy to send bulk emails.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.saleshandy.com\/blog\/create-mail-merge-gmail\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to create Mail merge in Gmail |Saleshandy\" \/>\n<meta property=\"og:description\" content=\"Send personalized emails with mail merge in Gmail with just a few clicks. Automate personalization with Saleshandy to send bulk emails.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.saleshandy.com\/blog\/create-mail-merge-gmail\/\" \/>\n<meta property=\"og:site_name\" content=\"SalesHandy\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/Saleshandy-455345097971262\/\" \/>\n<meta property=\"article:published_time\" content=\"2019-08-31T16:26:21+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-01-18T11:44:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2019\/08\/Create-Mail-Merge-in-Gmail.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"675\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Anil Salvi\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/Anilsalvi265\" \/>\n<meta name=\"twitter:site\" content=\"@sales_handy\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Anil Salvi\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.saleshandy.com\/blog\/create-mail-merge-gmail\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.saleshandy.com\/blog\/create-mail-merge-gmail\/\"},\"author\":{\"name\":\"Anil Salvi\",\"@id\":\"https:\/\/www.saleshandy.com\/blog\/#\/schema\/person\/ad677aec679ba564cc7a8398f7116be0\"},\"headline\":\"How to Create Mail Merge in Gmail\",\"datePublished\":\"2019-08-31T16:26:21+00:00\",\"dateModified\":\"2023-01-18T11:44:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.saleshandy.com\/blog\/create-mail-merge-gmail\/\"},\"wordCount\":1146,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.saleshandy.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.saleshandy.com\/blog\/create-mail-merge-gmail\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2019\/08\/Create-Mail-Merge-in-Gmail.png\",\"articleSection\":[\"Cold Emailing\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.saleshandy.com\/blog\/create-mail-merge-gmail\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.saleshandy.com\/blog\/create-mail-merge-gmail\/\",\"url\":\"https:\/\/www.saleshandy.com\/blog\/create-mail-merge-gmail\/\",\"name\":\"How to create Mail merge in Gmail |Saleshandy\",\"isPartOf\":{\"@id\":\"https:\/\/www.saleshandy.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.saleshandy.com\/blog\/create-mail-merge-gmail\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.saleshandy.com\/blog\/create-mail-merge-gmail\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2019\/08\/Create-Mail-Merge-in-Gmail.png\",\"datePublished\":\"2019-08-31T16:26:21+00:00\",\"dateModified\":\"2023-01-18T11:44:07+00:00\",\"description\":\"Send personalized emails with mail merge in Gmail with just a few clicks. Automate personalization with Saleshandy to send bulk emails.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.saleshandy.com\/blog\/create-mail-merge-gmail\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.saleshandy.com\/blog\/create-mail-merge-gmail\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.saleshandy.com\/blog\/create-mail-merge-gmail\/#primaryimage\",\"url\":\"https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2019\/08\/Create-Mail-Merge-in-Gmail.png\",\"contentUrl\":\"https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2019\/08\/Create-Mail-Merge-in-Gmail.png\",\"width\":1200,\"height\":675,\"caption\":\"Create mail merge in Gmail\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.saleshandy.com\/blog\/create-mail-merge-gmail\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.saleshandy.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Create Mail Merge in Gmail\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.saleshandy.com\/blog\/#website\",\"url\":\"https:\/\/www.saleshandy.com\/blog\/\",\"name\":\"SalesHandy\",\"description\":\"A sales engagement platform that helps to book more meetings\",\"publisher\":{\"@id\":\"https:\/\/www.saleshandy.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.saleshandy.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.saleshandy.com\/blog\/#organization\",\"name\":\"Saleshandy\",\"url\":\"https:\/\/www.saleshandy.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.saleshandy.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2021\/10\/Saleshandy-Logo-320x132px.png\",\"contentUrl\":\"https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2021\/10\/Saleshandy-Logo-320x132px.png\",\"width\":320,\"height\":132,\"caption\":\"Saleshandy\"},\"image\":{\"@id\":\"https:\/\/www.saleshandy.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/Saleshandy-455345097971262\/\",\"https:\/\/x.com\/sales_handy\",\"https:\/\/www.linkedin.com\/company\/saleshandy?trk=biz-companies-cym\",\"https:\/\/www.pinterest.com\/saleshandy\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.saleshandy.com\/blog\/#\/schema\/person\/ad677aec679ba564cc7a8398f7116be0\",\"name\":\"Anil Salvi\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.saleshandy.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2025\/01\/Anil_Salvi-96x96.png\",\"contentUrl\":\"https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2025\/01\/Anil_Salvi-96x96.png\",\"caption\":\"Anil Salvi\"},\"description\":\"Anil is a lead generation and outreach expert with over 10 years of experience in the SaaS industry. As the Chief Marketing Officer at Saleshandy, he has played a crucial role in revenue generation. Anil\u2019s expertise lies in creating data-driven sales and marketing strategies that align with customer needs to drive results. He is also deeply passionate about fostering collaboration between marketing, sales, and product teams to achieve unified business goals. Anil\u2019s insights bring immense value to every blog he contributes, helping readers enhance their lead-generation efforts.\",\"sameAs\":[\"http:\/\/www.saleshandy.com\",\"https:\/\/www.linkedin.com\/in\/anilsalvi\/\",\"https:\/\/x.com\/https:\/\/twitter.com\/Anilsalvi265\"],\"url\":\"https:\/\/www.saleshandy.com\/blog\/author\/anil\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to create Mail merge in Gmail |Saleshandy","description":"Send personalized emails with mail merge in Gmail with just a few clicks. Automate personalization with Saleshandy to send bulk emails.","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.saleshandy.com\/blog\/create-mail-merge-gmail\/","og_locale":"en_US","og_type":"article","og_title":"How to create Mail merge in Gmail |Saleshandy","og_description":"Send personalized emails with mail merge in Gmail with just a few clicks. Automate personalization with Saleshandy to send bulk emails.","og_url":"https:\/\/www.saleshandy.com\/blog\/create-mail-merge-gmail\/","og_site_name":"SalesHandy","article_publisher":"https:\/\/www.facebook.com\/Saleshandy-455345097971262\/","article_published_time":"2019-08-31T16:26:21+00:00","article_modified_time":"2023-01-18T11:44:07+00:00","og_image":[{"width":1200,"height":675,"url":"https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2019\/08\/Create-Mail-Merge-in-Gmail.png","type":"image\/png"}],"author":"Anil Salvi","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/Anilsalvi265","twitter_site":"@sales_handy","twitter_misc":{"Written by":"Anil Salvi","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.saleshandy.com\/blog\/create-mail-merge-gmail\/#article","isPartOf":{"@id":"https:\/\/www.saleshandy.com\/blog\/create-mail-merge-gmail\/"},"author":{"name":"Anil Salvi","@id":"https:\/\/www.saleshandy.com\/blog\/#\/schema\/person\/ad677aec679ba564cc7a8398f7116be0"},"headline":"How to Create Mail Merge in Gmail","datePublished":"2019-08-31T16:26:21+00:00","dateModified":"2023-01-18T11:44:07+00:00","mainEntityOfPage":{"@id":"https:\/\/www.saleshandy.com\/blog\/create-mail-merge-gmail\/"},"wordCount":1146,"commentCount":0,"publisher":{"@id":"https:\/\/www.saleshandy.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.saleshandy.com\/blog\/create-mail-merge-gmail\/#primaryimage"},"thumbnailUrl":"https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2019\/08\/Create-Mail-Merge-in-Gmail.png","articleSection":["Cold Emailing"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.saleshandy.com\/blog\/create-mail-merge-gmail\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.saleshandy.com\/blog\/create-mail-merge-gmail\/","url":"https:\/\/www.saleshandy.com\/blog\/create-mail-merge-gmail\/","name":"How to create Mail merge in Gmail |Saleshandy","isPartOf":{"@id":"https:\/\/www.saleshandy.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.saleshandy.com\/blog\/create-mail-merge-gmail\/#primaryimage"},"image":{"@id":"https:\/\/www.saleshandy.com\/blog\/create-mail-merge-gmail\/#primaryimage"},"thumbnailUrl":"https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2019\/08\/Create-Mail-Merge-in-Gmail.png","datePublished":"2019-08-31T16:26:21+00:00","dateModified":"2023-01-18T11:44:07+00:00","description":"Send personalized emails with mail merge in Gmail with just a few clicks. Automate personalization with Saleshandy to send bulk emails.","breadcrumb":{"@id":"https:\/\/www.saleshandy.com\/blog\/create-mail-merge-gmail\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.saleshandy.com\/blog\/create-mail-merge-gmail\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.saleshandy.com\/blog\/create-mail-merge-gmail\/#primaryimage","url":"https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2019\/08\/Create-Mail-Merge-in-Gmail.png","contentUrl":"https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2019\/08\/Create-Mail-Merge-in-Gmail.png","width":1200,"height":675,"caption":"Create mail merge in Gmail"},{"@type":"BreadcrumbList","@id":"https:\/\/www.saleshandy.com\/blog\/create-mail-merge-gmail\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.saleshandy.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Create Mail Merge in Gmail"}]},{"@type":"WebSite","@id":"https:\/\/www.saleshandy.com\/blog\/#website","url":"https:\/\/www.saleshandy.com\/blog\/","name":"SalesHandy","description":"A sales engagement platform that helps to book more meetings","publisher":{"@id":"https:\/\/www.saleshandy.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.saleshandy.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.saleshandy.com\/blog\/#organization","name":"Saleshandy","url":"https:\/\/www.saleshandy.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.saleshandy.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2021\/10\/Saleshandy-Logo-320x132px.png","contentUrl":"https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2021\/10\/Saleshandy-Logo-320x132px.png","width":320,"height":132,"caption":"Saleshandy"},"image":{"@id":"https:\/\/www.saleshandy.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/Saleshandy-455345097971262\/","https:\/\/x.com\/sales_handy","https:\/\/www.linkedin.com\/company\/saleshandy?trk=biz-companies-cym","https:\/\/www.pinterest.com\/saleshandy\/"]},{"@type":"Person","@id":"https:\/\/www.saleshandy.com\/blog\/#\/schema\/person\/ad677aec679ba564cc7a8398f7116be0","name":"Anil Salvi","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.saleshandy.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2025\/01\/Anil_Salvi-96x96.png","contentUrl":"https:\/\/www.saleshandy.com\/blog\/wp-content\/uploads\/2025\/01\/Anil_Salvi-96x96.png","caption":"Anil Salvi"},"description":"Anil is a lead generation and outreach expert with over 10 years of experience in the SaaS industry. As the Chief Marketing Officer at Saleshandy, he has played a crucial role in revenue generation. Anil\u2019s expertise lies in creating data-driven sales and marketing strategies that align with customer needs to drive results. He is also deeply passionate about fostering collaboration between marketing, sales, and product teams to achieve unified business goals. Anil\u2019s insights bring immense value to every blog he contributes, helping readers enhance their lead-generation efforts.","sameAs":["http:\/\/www.saleshandy.com","https:\/\/www.linkedin.com\/in\/anilsalvi\/","https:\/\/x.com\/https:\/\/twitter.com\/Anilsalvi265"],"url":"https:\/\/www.saleshandy.com\/blog\/author\/anil\/"}]}},"_links":{"self":[{"href":"https:\/\/www.saleshandy.com\/blog\/wp-json\/wp\/v2\/posts\/14582"}],"collection":[{"href":"https:\/\/www.saleshandy.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.saleshandy.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.saleshandy.com\/blog\/wp-json\/wp\/v2\/users\/47"}],"replies":[{"embeddable":true,"href":"https:\/\/www.saleshandy.com\/blog\/wp-json\/wp\/v2\/comments?post=14582"}],"version-history":[{"count":0,"href":"https:\/\/www.saleshandy.com\/blog\/wp-json\/wp\/v2\/posts\/14582\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.saleshandy.com\/blog\/wp-json\/wp\/v2\/media\/31901"}],"wp:attachment":[{"href":"https:\/\/www.saleshandy.com\/blog\/wp-json\/wp\/v2\/media?parent=14582"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.saleshandy.com\/blog\/wp-json\/wp\/v2\/categories?post=14582"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.saleshandy.com\/blog\/wp-json\/wp\/v2\/tags?post=14582"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}