{"id":3827,"date":"2025-05-22T17:58:25","date_gmt":"2025-05-22T12:28:25","guid":{"rendered":"https:\/\/www.navohosting.com\/blog\/?p=3827"},"modified":"2025-05-22T16:33:54","modified_gmt":"2025-05-22T11:03:54","slug":"send-personalized-mail-merge-e-mails","status":"publish","type":"post","link":"https:\/\/www.navohosting.com\/blog\/send-personalized-mail-merge-e-mails\/","title":{"rendered":"How to Enable Mail Merge in Gmail \/ Google Workspace? [Steps]"},"content":{"rendered":"<h3>Send Personalized Mail Merge in Gmail<\/h3>\n<p>Mail Merge in Gmail: Business organizations send business emails to their clients. <a href=\"https:\/\/en.wikipedia.org\/wiki\/Google_Workspace\" target=\"_blank\" rel=\"noopener\">Gmail is included in the Google Workspace suite<\/a>. The same content is sent to many clients. Send the same content to many clients is difficult. Mail Merge has applications for sending personalized email messages, newsletters, and announcements. When sending a message each recipient gets a unique copy of the mail. The mail merge option replaces multi-send mail. Mail merge personalizes messages with merge tags. One can also link a spreadsheet that contains the contact information to send messages to large recipients.<\/p>\n<h3><strong><span data-preserver-spaces=\"true\">Working on Mail Merge in Gmail<\/span><\/strong><\/h3>\n<p><span data-preserver-spaces=\"true\">Turn on the mail merge to send messages to many clients. Gmail sends a unique copy to each recipient individually. When the recipients open the message they can\u2019t check who sent it. If anyone replies to the message, you get the replies in separate threads. If you need to send emails to multi-users, link a spreadsheet. Mail merge consists of unsubscribe links for each recipient by default. Users unsubscribed from your e-mails will be removed from your future merge emails.<\/span><\/p>\n<h4><strong><span data-preserver-spaces=\"true\">How to add recipients directly to your message?<\/span><\/strong><\/h4>\n<p><span data-preserver-spaces=\"true\">Use the below steps to add the recipients directly to your email message. Include recipients individually in this option.\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0<\/span><\/p>\n<ul>\n<li><span data-preserver-spaces=\"true\">Open Gmail on your computer.<\/span><\/li>\n<li><span data-preserver-spaces=\"true\">Click Compose.<\/span><\/li>\n<li>(<span data-preserver-spaces=\"true\">You can also open an existing draft).<\/span><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter wp-image-3830 size-large\" src=\"https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2023\/07\/08-25-1024x597.jpg\" alt=\"add recipients directly to your message\" width=\"800\" height=\"466\" srcset=\"https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2023\/07\/08-25-1024x597.jpg 1024w, https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2023\/07\/08-25-300x175.jpg 300w, https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2023\/07\/08-25-768x448.jpg 768w, https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2023\/07\/08-25-1536x895.jpg 1536w, https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2023\/07\/08-25.jpg 1920w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li><span data-preserver-spaces=\"true\">Go to the &#8220;To:&#8221; line in the inbox.<\/span><\/li>\n<li>Enter the mail address.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-3831 size-large\" src=\"https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2023\/07\/01-80-1024x975.jpg\" alt=\"Recipient mail address\" width=\"800\" height=\"762\" srcset=\"https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2023\/07\/01-80-1024x975.jpg 1024w, https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2023\/07\/01-80-300x286.jpg 300w, https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2023\/07\/01-80-768x731.jpg 768w, https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2023\/07\/01-80.jpg 1260w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li><span data-preserver-spaces=\"true\">Hit the Use Mail merge icon.<\/span><\/li>\n<li>Select the Mail merge option.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-3832 size-large\" src=\"https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2023\/07\/02-79-1024x978.jpg\" alt=\"mail merge\" width=\"800\" height=\"764\" srcset=\"https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2023\/07\/02-79-1024x978.jpg 1024w, https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2023\/07\/02-79-300x286.jpg 300w, https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2023\/07\/02-79-768x733.jpg 768w, https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2023\/07\/02-79.jpg 1257w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li><span data-preserver-spaces=\"true\">Turn on the Mail merge tickbox.<\/span><\/li>\n<li>Add a subject and content in the inbox.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3833 size-large\" src=\"https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2023\/07\/03-73-1024x971.jpg\" alt=\"select mail merge\" width=\"800\" height=\"759\" srcset=\"https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2023\/07\/03-73-1024x971.jpg 1024w, https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2023\/07\/03-73-300x284.jpg 300w, https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2023\/07\/03-73-768x728.jpg 768w, https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2023\/07\/03-73.jpg 1266w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li><span data-preserver-spaces=\"true\">In your message, enter \u201c@.\u201d<\/span><\/li>\n<li>Mail merge tags appear.<\/li>\n<li><span data-preserver-spaces=\"true\">Select a merge tag from the list.<\/span><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3834 size-large\" src=\"https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2023\/07\/05-52-1024x987.jpg\" alt=\"mail merge tags\" width=\"800\" height=\"771\" srcset=\"https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2023\/07\/05-52-1024x987.jpg 1024w, https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2023\/07\/05-52-300x289.jpg 300w, https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2023\/07\/05-52-768x741.jpg 768w, https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2023\/07\/05-52.jpg 1092w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li><span data-preserver-spaces=\"true\">To filter the list, enter the name of a supported merge tag:<\/span><\/li>\n<li><span data-preserver-spaces=\"true\">For the first name, enter \u201c@firstname\u201d, enter \u201c@lastname\u201d For, Full name, enter \u201c@fullname\u201d, Email address, and enter \u201c@email\u201d<\/span><\/li>\n<li><span data-preserver-spaces=\"true\">To select a merge tag press Enter.<\/span><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3835 size-large\" src=\"https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2023\/07\/06-44-1024x997.jpg\" alt=\"first name\" width=\"800\" height=\"779\" srcset=\"https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2023\/07\/06-44-1024x997.jpg 1024w, https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2023\/07\/06-44-300x292.jpg 300w, https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2023\/07\/06-44-768x747.jpg 768w, https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2023\/07\/06-44.jpg 1233w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h4><strong><span data-preserver-spaces=\"true\">Steps to Add Recipients from a Spreadsheet<\/span><\/strong><\/h4>\n<ul>\n<li><span data-preserver-spaces=\"true\">On your computer, open Gmail.<\/span><\/li>\n<li><span data-preserver-spaces=\"true\">Hit Compose. (You can also open an existing draft)<\/span><\/li>\n<li><span data-preserver-spaces=\"true\">Go to the &#8220;To:&#8221; line.<\/span><\/li>\n<li><span data-preserver-spaces=\"true\">Click Use Mail merge.<\/span><\/li>\n<li><span data-preserver-spaces=\"true\">Turn on Mail merge.<\/span><\/li>\n<li><span data-preserver-spaces=\"true\">Hit Add from a spreadsheet.<\/span><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3838 size-large\" src=\"https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2023\/07\/07-33-1024x980.jpg\" alt=\"Date joined\" width=\"800\" height=\"766\" srcset=\"https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2023\/07\/07-33-1024x980.jpg 1024w, https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2023\/07\/07-33-300x287.jpg 300w, https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2023\/07\/07-33-768x735.jpg 768w, https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2023\/07\/07-33.jpg 1254w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li><span data-preserver-spaces=\"true\">Select a spreadsheet, then click Link.<\/span><\/li>\n<li><span data-preserver-spaces=\"true\">(Use the dropdown menus to select the columns from the spreadsheet to determine each recipient address)<\/span><\/li>\n<\/ul>\n<p><span data-preserver-spaces=\"true\">Choose the following contact information from your spreadsheet:<\/span><\/p>\n<ul>\n<li><span data-preserver-spaces=\"true\">e-mail<\/span><\/li>\n<li><span data-preserver-spaces=\"true\">First name<\/span><\/li>\n<li><span data-preserver-spaces=\"true\">Last name (optional)<\/span><\/li>\n<li><span data-preserver-spaces=\"true\">Click Finish<\/span><\/li>\n<\/ul>\n<p><span data-preserver-spaces=\"true\">Your spreadsheet is added to the \u201cTo:\u201d line in the message.<\/span><\/p>\n<ul>\n<li><span data-preserver-spaces=\"true\">In your message, enter \u201c@.\u201d<\/span><\/li>\n<li><span data-preserver-spaces=\"true\">Select a merge tag.<\/span><\/li>\n<li><span data-preserver-spaces=\"true\">The column headers in your spreadsheet determine merge tags.<\/span><\/li>\n<li><span data-preserver-spaces=\"true\">To select a merge tag, press Enter.<\/span><\/li>\n<\/ul>\n<h4><strong><span data-preserver-spaces=\"true\">Mail merge in Gmail availability<\/span><\/strong><\/h4>\n<p><span data-preserver-spaces=\"true\">Google Workspace updates now the mail merge supports Google Sheets in the web version. Google Sheets integrated with Mail merge in Gmail. This feature is available to Google <a href=\"https:\/\/www.navohosting.com\/blog\/business-standard-plan-workspace\/\">Workspace Business Standard<\/a>, Business Plus, Enterprise Standard, Enterprise Plus, Education Standard, Education Plus customers, and Non-profits. Now this integration allows linking sheets to up to 1,500 recipients. Use any data column from the Google sheet as a mail merge tag. The mail merge icons shifted to the top right corner of the composer window.<\/span><\/p>\n<h4><strong><span data-preserver-spaces=\"true\">Send limits and Mail merge limitation<\/span><\/strong><\/h4>\n<p><span data-preserver-spaces=\"true\">You can send up daily 1500 recipients daily using Mail Merge. Still, you can send 500 normal messages for standard Gmail accounts and a 2000 per day limit for work, school, and workspace individual limits. Mail merge is not used with the following types of messages.<\/span><\/p>\n<ul>\n<li><span data-preserver-spaces=\"true\">Reply<\/span><\/li>\n<li><span data-preserver-spaces=\"true\">Forward<\/span><\/li>\n<li><span data-preserver-spaces=\"true\">Scheduled send<\/span><\/li>\n<li><span data-preserver-spaces=\"true\">Confidential mode<\/span><\/li>\n<\/ul>\n<p>Hope you learned about how to enable mail merge in google workspace. Follow the steps to turn on mail merge in google workspace.<\/p>\n<p><span data-preserver-spaces=\"true\">Navohosting is one of the premium Google Workspace resellers and Google Cloud partners offer many services to clients. Google Workspace offers business apps for clients. Get the workspace at the offer price.<\/span><\/p>\n<p><strong>Our Services<\/strong><\/p>\n<ul>\n<li><span data-preserver-spaces=\"true\">Google workspace<\/span><\/li>\n<li><span data-preserver-spaces=\"true\">Website Design<\/span><\/li>\n<li><span data-preserver-spaces=\"true\">Domain &amp; Web hosting<\/span><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p style=\"text-align: center;\"><strong><a href=\"https:\/\/www.navohosting.com\/blog\/google-workspace-business-features\/\">Google Workspace business features<\/a><\/strong><\/p>\n<p style=\"text-align: center;\"><strong><a href=\"https:\/\/www.navohosting.com\/blog\/google-workspace-transfer-token-creation\/\">How to create Google Workspace Transfer Token?<\/a><\/strong><\/p>\n<p style=\"text-align: center;\"><strong><a href=\"https:\/\/www.navohosting.com\/blog\/google-workspace-education-features\/\">Check Google Workspace Education Features\u00a0<\/a><\/strong><\/p>\n<p>&nbsp;<\/p>\n<p>For more troubleshooting and tips check out our blogs. Learn more about our <a href=\"https:\/\/www.navohosting.com\/blog\/google-workspace\/\">digital infrastructure and other services here<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Send Personalized Mail Merge in Gmail Mail Merge in Gmail: Business organizations send business emails to their clients. Gmail is included in the Google Workspace suite. The same content is sent to many clients. Send the same content to many clients is difficult. Mail Merge has applications for sending personalized email messages, newsletters, and announcements. [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":3829,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[245,17,150,39,246],"class_list":["post-3827","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-g-suite","tag-e-mail","tag-g-suite","tag-gmail","tag-google-workspace","tag-mail-merge"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.navohosting.com\/blog\/wp-json\/wp\/v2\/posts\/3827","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.navohosting.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.navohosting.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.navohosting.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.navohosting.com\/blog\/wp-json\/wp\/v2\/comments?post=3827"}],"version-history":[{"count":0,"href":"https:\/\/www.navohosting.com\/blog\/wp-json\/wp\/v2\/posts\/3827\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.navohosting.com\/blog\/wp-json\/wp\/v2\/media\/3829"}],"wp:attachment":[{"href":"https:\/\/www.navohosting.com\/blog\/wp-json\/wp\/v2\/media?parent=3827"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.navohosting.com\/blog\/wp-json\/wp\/v2\/categories?post=3827"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.navohosting.com\/blog\/wp-json\/wp\/v2\/tags?post=3827"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}