{"id":3686,"date":"2022-09-28T11:25:34","date_gmt":"2022-09-28T16:25:34","guid":{"rendered":"https:\/\/donorsnap.com\/support\/?post_type=epkb_post_type_1&#038;p=3686"},"modified":"2022-09-28T12:11:59","modified_gmt":"2022-09-28T17:11:59","slug":"mail-merge-with-microsoft-word","status":"publish","type":"epkb_post_type_1","link":"https:\/\/donorsnap.com\/support\/docs\/mail-merge-with-microsoft-word\/","title":{"rendered":"Mail Merge with Microsoft Word"},"content":{"rendered":"<p>&#8220;How do I make the letter put in their first name instead of using\u00a0<em>Dear Friend<\/em>?&#8221;<br \/>This is the essence of Mail Merge.\u00a0<\/p>\n<p>Insert &#8220;merge fields&#8221; in to your Word Document: your appeal mailing, mailing labels, membership cards, newsletter, etc., so that Microsoft Word will insert their Name, Address, YTD Donation amount, so on and so forth.\u00a0<\/p>\n<p>Where does DonorSnap come in?\u00a0 This is where you will create the <strong>Mailing List<\/strong> you need for the people you are mailing.\u00a0<\/p>\n<ol>\n<li>Create your mailing list in <strong>DataMiner Platinum<\/strong> of WHO. Include all of the fields (on the Field Export Selection tab) you will want to insert in to your Word document.\u00a0<\/li>\n<li>Export your DMP report to your computer where you can find it later.\u00a0<\/li>\n<li>Create your Word document. Insert place holders for the address block, the Dear line, etc., where you will want to insert your merge fields.\u00a0<\/li>\n<li><strong>In Word<\/strong>, use the <strong>Mailings Tab<\/strong> to Select Recipients &gt; Use an Existing list. Find your DMP Excel file that you&#8217;ve just downloaded.\u00a0<\/li>\n<li>Click the <strong>Insert Merge Field<\/strong> button to insert your fields into your document. Preview results, Finish &amp; Merge.\u00a0<\/li>\n<\/ol>\n<p>**If you are looking to Mail Merge your Acknowledgement Letters (Thank you letters) in DonorSnap, use <a href=\"https:\/\/donorsnap.com\/support\/docs\/donation-acknowledgement-letters\/\" target=\"_blank\" rel=\"noreferrer noopener\">THIS video<\/a> instead.\u00a0<\/p>\n<p><iframe loading=\"lazy\" class=\"embeddedObject shadow resizable\" style=\"overflow: hidden;\" src=\"https:\/\/www.screencast.com\/users\/DennisMueller\/folders\/DonorSnap%20Help%20Videos\/media\/c1d96834-6695-449d-bdef-f714af860420\/embed\" name=\"embedded_content\" width=\"800\" height=\"448\" frameborder=\"0\" scrolling=\"no\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;How do I make the letter put in their first name instead of using\u00a0Dear Friend?&#8221;This is the essence of Mail Merge.\u00a0 Insert &#8220;merge fields&#8221; in to your Word Document: your appeal mailing, mailing labels, membership cards, newsletter, etc., so that Microsoft Word will insert their Name, Address, YTD Donation amount, so on and so forth.\u00a0 &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/donorsnap.com\/support\/docs\/mail-merge-with-microsoft-word\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Mail Merge with Microsoft Word&#8221;<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"epkb_post_type_1_category":[8],"epkb_post_type_1_tag":[],"class_list":["post-3686","epkb_post_type_1","type-epkb_post_type_1","status-publish","hentry","epkb_post_type_1_category-communication-tools"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Mail Merge with Microsoft Word - DonorSnap Support<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/donorsnap.com\/support\/docs\/mail-merge-with-microsoft-word\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Mail Merge with Microsoft Word - DonorSnap Support\" \/>\n<meta property=\"og:description\" content=\"&#8220;How do I make the letter put in their first name instead of using\u00a0Dear Friend?&#8221;This is the essence of Mail Merge.\u00a0 Insert &#8220;merge fields&#8221; in to your Word Document: your appeal mailing, mailing labels, membership cards, newsletter, etc., so that Microsoft Word will insert their Name, Address, YTD Donation amount, so on and so forth.\u00a0 &hellip; Continue reading &quot;Mail Merge with Microsoft Word&quot;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/donorsnap.com\/support\/docs\/mail-merge-with-microsoft-word\/\" \/>\n<meta property=\"og:site_name\" content=\"DonorSnap Support\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DonorSnap\/\" \/>\n<meta property=\"article:modified_time\" content=\"2022-09-28T17:11:59+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@DonorSnap\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/donorsnap.com\/support\/docs\/mail-merge-with-microsoft-word\/\",\"url\":\"https:\/\/donorsnap.com\/support\/docs\/mail-merge-with-microsoft-word\/\",\"name\":\"Mail Merge with Microsoft Word - DonorSnap Support\",\"isPartOf\":{\"@id\":\"https:\/\/donorsnap.com\/support\/#website\"},\"datePublished\":\"2022-09-28T16:25:34+00:00\",\"dateModified\":\"2022-09-28T17:11:59+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/donorsnap.com\/support\/docs\/mail-merge-with-microsoft-word\/#breadcrumb\"},\"inLanguage\":\"en\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/donorsnap.com\/support\/docs\/mail-merge-with-microsoft-word\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/donorsnap.com\/support\/docs\/mail-merge-with-microsoft-word\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/donorsnap.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Mail Merge with Microsoft Word\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/donorsnap.com\/support\/#website\",\"url\":\"https:\/\/donorsnap.com\/support\/\",\"name\":\"DonorSnap Support\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/donorsnap.com\/support\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/donorsnap.com\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/donorsnap.com\/support\/#organization\",\"name\":\"DonorSnap\",\"url\":\"https:\/\/donorsnap.com\/support\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"https:\/\/donorsnap.com\/support\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/donorsnap.com\/support\/wp-content\/uploads\/2019\/01\/cropped-donorsnap-online-help-1200px.png\",\"contentUrl\":\"https:\/\/donorsnap.com\/support\/wp-content\/uploads\/2019\/01\/cropped-donorsnap-online-help-1200px.png\",\"width\":892,\"height\":250,\"caption\":\"DonorSnap\"},\"image\":{\"@id\":\"https:\/\/donorsnap.com\/support\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/DonorSnap\/\",\"https:\/\/x.com\/DonorSnap\",\"https:\/\/www.linkedin.com\/company\/donorsnap\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Mail Merge with Microsoft Word - DonorSnap Support","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:\/\/donorsnap.com\/support\/docs\/mail-merge-with-microsoft-word\/","og_locale":"en_US","og_type":"article","og_title":"Mail Merge with Microsoft Word - DonorSnap Support","og_description":"&#8220;How do I make the letter put in their first name instead of using\u00a0Dear Friend?&#8221;This is the essence of Mail Merge.\u00a0 Insert &#8220;merge fields&#8221; in to your Word Document: your appeal mailing, mailing labels, membership cards, newsletter, etc., so that Microsoft Word will insert their Name, Address, YTD Donation amount, so on and so forth.\u00a0 &hellip; Continue reading \"Mail Merge with Microsoft Word\"","og_url":"https:\/\/donorsnap.com\/support\/docs\/mail-merge-with-microsoft-word\/","og_site_name":"DonorSnap Support","article_publisher":"https:\/\/www.facebook.com\/DonorSnap\/","article_modified_time":"2022-09-28T17:11:59+00:00","twitter_card":"summary_large_image","twitter_site":"@DonorSnap","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/donorsnap.com\/support\/docs\/mail-merge-with-microsoft-word\/","url":"https:\/\/donorsnap.com\/support\/docs\/mail-merge-with-microsoft-word\/","name":"Mail Merge with Microsoft Word - DonorSnap Support","isPartOf":{"@id":"https:\/\/donorsnap.com\/support\/#website"},"datePublished":"2022-09-28T16:25:34+00:00","dateModified":"2022-09-28T17:11:59+00:00","breadcrumb":{"@id":"https:\/\/donorsnap.com\/support\/docs\/mail-merge-with-microsoft-word\/#breadcrumb"},"inLanguage":"en","potentialAction":[{"@type":"ReadAction","target":["https:\/\/donorsnap.com\/support\/docs\/mail-merge-with-microsoft-word\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/donorsnap.com\/support\/docs\/mail-merge-with-microsoft-word\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/donorsnap.com\/support\/"},{"@type":"ListItem","position":2,"name":"Mail Merge with Microsoft Word"}]},{"@type":"WebSite","@id":"https:\/\/donorsnap.com\/support\/#website","url":"https:\/\/donorsnap.com\/support\/","name":"DonorSnap Support","description":"","publisher":{"@id":"https:\/\/donorsnap.com\/support\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/donorsnap.com\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en"},{"@type":"Organization","@id":"https:\/\/donorsnap.com\/support\/#organization","name":"DonorSnap","url":"https:\/\/donorsnap.com\/support\/","logo":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/donorsnap.com\/support\/#\/schema\/logo\/image\/","url":"https:\/\/donorsnap.com\/support\/wp-content\/uploads\/2019\/01\/cropped-donorsnap-online-help-1200px.png","contentUrl":"https:\/\/donorsnap.com\/support\/wp-content\/uploads\/2019\/01\/cropped-donorsnap-online-help-1200px.png","width":892,"height":250,"caption":"DonorSnap"},"image":{"@id":"https:\/\/donorsnap.com\/support\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DonorSnap\/","https:\/\/x.com\/DonorSnap","https:\/\/www.linkedin.com\/company\/donorsnap\/"]}]}},"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/donorsnap.com\/support\/wp-json\/wp\/v2\/epkb_post_type_1\/3686","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/donorsnap.com\/support\/wp-json\/wp\/v2\/epkb_post_type_1"}],"about":[{"href":"https:\/\/donorsnap.com\/support\/wp-json\/wp\/v2\/types\/epkb_post_type_1"}],"author":[{"embeddable":true,"href":"https:\/\/donorsnap.com\/support\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/donorsnap.com\/support\/wp-json\/wp\/v2\/comments?post=3686"}],"version-history":[{"count":8,"href":"https:\/\/donorsnap.com\/support\/wp-json\/wp\/v2\/epkb_post_type_1\/3686\/revisions"}],"predecessor-version":[{"id":3702,"href":"https:\/\/donorsnap.com\/support\/wp-json\/wp\/v2\/epkb_post_type_1\/3686\/revisions\/3702"}],"wp:attachment":[{"href":"https:\/\/donorsnap.com\/support\/wp-json\/wp\/v2\/media?parent=3686"}],"wp:term":[{"taxonomy":"epkb_post_type_1_category","embeddable":true,"href":"https:\/\/donorsnap.com\/support\/wp-json\/wp\/v2\/epkb_post_type_1_category?post=3686"},{"taxonomy":"epkb_post_type_1_tag","embeddable":true,"href":"https:\/\/donorsnap.com\/support\/wp-json\/wp\/v2\/epkb_post_type_1_tag?post=3686"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}