{"id":897,"date":"2014-07-27T13:24:50","date_gmt":"2014-07-27T05:24:50","guid":{"rendered":"http:\/\/www.ssedro.com\/blog\/?p=897"},"modified":"2014-07-27T13:26:07","modified_gmt":"2014-07-27T05:26:07","slug":"basic-mail-merge-template-for-google-docs","status":"publish","type":"post","link":"https:\/\/www.ssedro.com\/blog\/2014\/07\/27\/basic-mail-merge-template-for-google-docs\/","title":{"rendered":"Basic Mail Merge Template for Google Docs"},"content":{"rendered":"<p><span style=\"color: #37404e;\">Finally played with <a title=\"mail merge template\" href=\"https:\/\/docs.google.com\/spreadsheet\/ccc?key=0Ao4zmLMBvdyddGZmYkxfWlNjV0dtWXFROUVRcF9kR0E&amp;hl=en&amp;pli=1#gid=0\" target=\"_blank\">this basic mail merge template for Google Docs<\/a>. I like it. It&#8217;s a great tool for teachers.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-898\" src=\"http:\/\/www.ssedro.com\/blog\/wp-content\/uploads\/2014\/07\/monosnap-window-title-1-300x126.jpg\" alt=\"monosnap-window title-1\" width=\"300\" height=\"126\" srcset=\"https:\/\/www.ssedro.com\/blog\/wp-content\/uploads\/2014\/07\/monosnap-window-title-1-300x126.jpg 300w, https:\/\/www.ssedro.com\/blog\/wp-content\/uploads\/2014\/07\/monosnap-window-title-1-1024x431.jpg 1024w, https:\/\/www.ssedro.com\/blog\/wp-content\/uploads\/2014\/07\/monosnap-window-title-1.jpg 1076w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>In the data tab create a spreadsheet of your class with the following information:<\/p>\n<ul>\n<li><span style=\"color: #37404e;\">student first <\/span><\/li>\n<li><span style=\"color: #37404e;\">student last name<\/span><\/li>\n<li><span style=\"color: #37404e;\">the correct pronouns (he\/she, him\/her, his\/he<\/span><span class=\"text_exposed_show\" style=\"color: #37404e;\">r)<\/span><\/li>\n<li><span class=\"text_exposed_show\" style=\"color: #37404e;\">email of each parent<\/span><\/li>\n<li><span class=\"text_exposed_show\" style=\"color: #37404e;\"> parent names.<\/span><\/li>\n<\/ul>\n<p>Set that up once and you are in mail merge Nirvana for the rest of the school year. Easily send personalized info to parents all year long. It should work for mailings of less than 100, so secondary teachers may need to organize it by day of the schedule.<\/p>\n<p>Check out this LifeHacker post for directions and the link to the template:<\/p>\n<p><span class=\"text_exposed_show\" style=\"color: #37404e;\"><a style=\"color: #3b5998;\" href=\"http:\/\/lifehacker.com\/5863338\/get-mail-merge-in-gmail-with-this-google-docs-template\" target=\"_blank\" rel=\"nofollow nofollow\">http:\/\/lifehacker.com\/5863338\/get-mail-merge-in-gmail-with-this-google-docs-templat<\/a><\/span><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Finally played with this basic mail merge template for Google Docs. I like it. It&#8217;s a great tool for teachers.<\/p>\n<p>&nbsp;<\/p>\n<\/p>\n<p>&nbsp;<\/p>\n<p>In the data tab create a spreadsheet of your class with the following information:<\/p>\n<p> student first student last name the correct pronouns (he\/she, him\/her, his\/her) email of each parent parent names. <\/p>\n<p>Set [&#8230;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[87],"tags":[],"class_list":["post-897","post","type-post","status-publish","format-standard","hentry","category-google_apps","odd"],"_links":{"self":[{"href":"https:\/\/www.ssedro.com\/blog\/wp-json\/wp\/v2\/posts\/897","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ssedro.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ssedro.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ssedro.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ssedro.com\/blog\/wp-json\/wp\/v2\/comments?post=897"}],"version-history":[{"count":3,"href":"https:\/\/www.ssedro.com\/blog\/wp-json\/wp\/v2\/posts\/897\/revisions"}],"predecessor-version":[{"id":901,"href":"https:\/\/www.ssedro.com\/blog\/wp-json\/wp\/v2\/posts\/897\/revisions\/901"}],"wp:attachment":[{"href":"https:\/\/www.ssedro.com\/blog\/wp-json\/wp\/v2\/media?parent=897"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ssedro.com\/blog\/wp-json\/wp\/v2\/categories?post=897"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ssedro.com\/blog\/wp-json\/wp\/v2\/tags?post=897"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}