{"id":1068,"date":"2017-06-20T15:32:52","date_gmt":"2017-06-20T20:32:52","guid":{"rendered":""},"modified":"2017-06-20T15:50:18","modified_gmt":"2017-06-20T20:50:18","slug":"mail-merge-tech-tune-ups","status":"publish","type":"post","link":"https:\/\/blogs.acu.edu\/innovation_foundry\/2017\/06\/20\/mail-merge-tech-tune-ups\/","title":{"rendered":"Mail Merge | Tech Tune-Ups"},"content":{"rendered":"<p>Today, <span style=\"color: #f47720\"><a style=\"color: #f47720\" href=\"http:\/\/blogs.acu.edu\/innovation_foundry\/experts\/our-team\/\">Stephen Rektenwald<\/a><\/span> talked to us about Mail Merge using Google G Suite and Microsoft Office. Both are powerful applications made available to ACU faculty and staff, with differences in their setup. Stephen walked our group through the various steps one will need to take in order to setup either application for their mail merge projects. Below are today&#8217;s presentation, as well as some links to help you get the most out of your mail merge workflows and resources. Thanks for helping these sessions become a great addition to our ever growing relationship with ACU and the technologies they provide.<\/p>\n<p><span style=\"color: #f47720\"><a style=\"color: #f47720\" href=\"https:\/\/docs.google.com\/presentation\/d\/1YKxkCfwKFN7UpvkRUkZxbzWRXym4LZAmUmkZXXN-fmY\/pub?start=false&amp;loop=false&amp;delayms=3000\" target=\"_blank\" rel=\"noopener noreferrer\">Google Slides Presentation<\/a><\/span><\/p>\n<p><span style=\"color: #f47720\"><a style=\"color: #f47720\" href=\"http:\/\/lynda.com\" target=\"_blank\" rel=\"noopener noreferrer\">Lynda.com<\/a><\/span> has some great videos on their site:<\/p>\n<ul>\n<li><span style=\"color: #f47720\"><a style=\"color: #f47720\" href=\"https:\/\/www.lynda.com\/search?q=Mail+merge+word\" target=\"_blank\" rel=\"noopener noreferrer\">Microsoft Word<\/a>&nbsp;<span style=\"color: #000000\">on Lynda.com<\/span><\/span><\/li>\n<li><span style=\"color: #f47720\"><a style=\"color: #f47720\" href=\"https:\/\/www.lynda.com\/iOS-tutorials\/Using-add-ons-Google-Docs-mail-merge\/114903\/452513-4.html\" target=\"_blank\" rel=\"noopener noreferrer\">Google Sheets<\/a>&nbsp;<span style=\"color: #000000\">on Lynda.com<\/span><\/span><\/li>\n<\/ul>\n<p>Also, Google has a great resources with their Add-ons:<\/p>\n<ol>\n<li>Open <span style=\"color: #f47720\"><a style=\"color: #f47720\" href=\"https:\/\/docs.google.com\/spreadsheets\/\" target=\"_blank\" rel=\"noopener noreferrer\">Google Sheets<\/a><\/span><\/li>\n<li>Open one of &nbsp;your Google Sheets, or create a new one<\/li>\n<li>In the dropdown menu, on the top left of your screen, click on &#8220;Add-ons&#8221;<\/li>\n<li>Click on &#8220;Get Add-ons&#8221; from the dropdown menu<\/li>\n<li>A new window will open with all of the various tools you can incorporate into Google Sheets. If you want to restrict the add-ons to mail merge, type &#8220;Mail Merge&#8221; into the&nbsp;&#8220;Search add-ons&#8221; box<\/li>\n<li>If you know what you are looking for, choose the best &#8220;add on&#8221; to fit your need. If you are unsure what you might need, take some time to read the descriptions of all the available add-ons.&nbsp;<\/li>\n<\/ol>\n<p>The Add-on Stephen used today was called &#8220;<em><strong>autoCrat<\/strong><\/em>.&#8221; Another mail merge add-on we have used is &#8220;<em><strong>Yet Another Mail Merge<\/strong><\/em>&#8221; &#8211; which is the one that will tell you who has opened or viewed the email you sent out using it, as well as the ability to personalize each email.<\/p>\n<p>As always, the best way to troubleshoot or ask your technical questions is to seek out the following helps:<\/p>\n<ul>\n<li>Helpdesk&nbsp;|&nbsp;<span style=\"color: #f47720\"><a style=\"color: #f47720\" href=\"mailto:helpdesk@acu.edu\" target=\"_blank\" rel=\"noopener noreferrer\">helpdesk@acu.edu<\/a><\/span>&nbsp;or dial ext.&nbsp;4357<\/li>\n<li><span style=\"color: #f47720\"><a style=\"color: #f47720\" href=\"https:\/\/www.lynda.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">Lynda.com<\/a><\/span><\/li>\n<li><span style=\"color: #f47720\"><a style=\"color: #f47720\" href=\"https:\/\/gsuite.google.com\/learning-center\/\" target=\"_blank\" rel=\"noopener noreferrer\">G Suite Learning Center<\/a><\/span><\/li>\n<li><span style=\"color: #f47720\"><a style=\"color: #f47720\" href=\"http:\/\/blogs.acu.edu\/innovation_foundry\/experts\/our-team\/\" target=\"_blank\" rel=\"noopener noreferrer\">The Innovation Foundry<\/a><\/span><\/li>\n<\/ul>\n<p style=\"text-align: center\"><a href=\"http:\/\/blogs.acu.edu\/innovation_foundry\/files\/2017\/06\/autocrat-mailmerge.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-1069\" src=\"http:\/\/blogs.acu.edu\/innovation_foundry\/files\/2017\/06\/autocrat-mailmerge-490x303.jpg\" alt=\"\" width=\"490\" height=\"303\" srcset=\"https:\/\/blogs.acu.edu\/innovation_foundry\/files\/2017\/06\/autocrat-mailmerge-490x303.jpg 490w, https:\/\/blogs.acu.edu\/innovation_foundry\/files\/2017\/06\/autocrat-mailmerge-150x93.jpg 150w, https:\/\/blogs.acu.edu\/innovation_foundry\/files\/2017\/06\/autocrat-mailmerge-300x185.jpg 300w, https:\/\/blogs.acu.edu\/innovation_foundry\/files\/2017\/06\/autocrat-mailmerge.jpg 500w\" sizes=\"(max-width: 490px) 100vw, 490px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Today, Stephen Rektenwald talked to us about Mail Merge using Google G Suite and Microsoft Office. Both are powerful applications made available to ACU faculty and staff, with differences in [&hellip;]<\/p>\n","protected":false},"author":3441,"featured_media":1071,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[152823],"tags":[],"post_folder":[],"class_list":["post-1068","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-innovation-foundry"],"_links":{"self":[{"href":"https:\/\/blogs.acu.edu\/innovation_foundry\/wp-json\/wp\/v2\/posts\/1068","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.acu.edu\/innovation_foundry\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.acu.edu\/innovation_foundry\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.acu.edu\/innovation_foundry\/wp-json\/wp\/v2\/users\/3441"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.acu.edu\/innovation_foundry\/wp-json\/wp\/v2\/comments?post=1068"}],"version-history":[{"count":1,"href":"https:\/\/blogs.acu.edu\/innovation_foundry\/wp-json\/wp\/v2\/posts\/1068\/revisions"}],"predecessor-version":[{"id":1070,"href":"https:\/\/blogs.acu.edu\/innovation_foundry\/wp-json\/wp\/v2\/posts\/1068\/revisions\/1070"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blogs.acu.edu\/innovation_foundry\/wp-json\/wp\/v2\/media\/1071"}],"wp:attachment":[{"href":"https:\/\/blogs.acu.edu\/innovation_foundry\/wp-json\/wp\/v2\/media?parent=1068"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.acu.edu\/innovation_foundry\/wp-json\/wp\/v2\/categories?post=1068"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.acu.edu\/innovation_foundry\/wp-json\/wp\/v2\/tags?post=1068"},{"taxonomy":"post_folder","embeddable":true,"href":"https:\/\/blogs.acu.edu\/innovation_foundry\/wp-json\/wp\/v2\/post_folder?post=1068"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}