{"id":13765,"date":"2022-04-04T18:26:35","date_gmt":"2022-04-04T22:26:35","guid":{"rendered":"https:\/\/certek.com\/kb4\/?p=13765"},"modified":"2023-06-15T13:02:58","modified_gmt":"2023-06-15T17:02:58","slug":"how-to-export-customer-emails","status":"publish","type":"ht_kb","link":"https:\/\/certek.com\/kb4\/knowledge-base\/how-to-export-customer-emails\/","title":{"rendered":"How to Export Customer Emails"},"content":{"rendered":"\n<p>Having a customer&#8217;s email address is a great way to send them information about their orders and keep them up-to-date on what&#8217;s going on at your store.<\/p>\n<p>Though you can email customers directly through Artisan, we recommend <strong>mass-emailing<\/strong> customers using a service like Constant Contact. To do so, you&#8217;ll need to export your customer emails from Artisan and import them into your program of choice.<\/p>\n<ul>\n<li><a href=\"#export-from-artisan\"><strong>Export from Artisan<\/strong><\/a><\/li>\n<li><strong><a href=\"#importing-email-contacts-intoo-constant-contact\">Import into Constant Contact<\/a><\/strong><\/li>\n<li><a href=\"#importing-email-contacts-into-gmail\"><strong>Import into Gmail<\/strong><\/a><\/li>\n<\/ul>\n<h3><strong><a id=\"export-from-artisan\"><\/a>Export from Artisan<\/strong><\/h3>\n<p>Exporting customer emails is easy. Click on &#8220;<strong>Reports<\/strong>,&#8221; &#8220;<strong>Customer Reports<\/strong>,&#8221; and &#8220;<strong>Customer Email Export Report<\/strong>.&#8221;<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h09_08.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-15280 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h09_08.png\" alt=\"\" width=\"538\" height=\"357\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h09_08.png 538w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h09_08-300x199.png 300w\" sizes=\"auto, (max-width: 538px) 100vw, 538px\" \/><\/a><\/p>\n<p>You may leave the fields blank to pull up your emails using Artisan&#8217;s default settings. Or, you may narrow down your selection by filtering through the fields. When you&#8217;re finished, press &#8220;<strong>View Report<\/strong>.&#8221;<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h04_21.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-15278 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h04_21.png\" alt=\"\" width=\"772\" height=\"508\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h04_21.png 772w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h04_21-300x197.png 300w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h04_21-768x505.png 768w\" sizes=\"auto, (max-width: 772px) 100vw, 772px\" \/><\/a><\/p>\n<p>Artisan will open a list of your customer emails. Navigate to the export icon.<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h08_04.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-15279 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h08_04.png\" alt=\"\" width=\"534\" height=\"160\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h08_04.png 534w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h08_04-300x90.png 300w\" sizes=\"auto, (max-width: 534px) 100vw, 534px\" \/><\/a><\/p>\n<p>Determine the file type. Most email applications require CSV (Comma-Separated Value) or XLS.<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h10_36.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-15281 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h10_36.png\" alt=\"\" width=\"209\" height=\"267\" \/><\/a><\/p>\n<p>Save the file.<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-04_14h20_03.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13782 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-04_14h20_03.png\" alt=\"\" width=\"490\" height=\"340\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-04_14h20_03.png 490w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-04_14h20_03-300x208.png 300w\" sizes=\"auto, (max-width: 490px) 100vw, 490px\" \/><\/a><\/p>\n<p>\u00a0<\/p>\n<p>Artisan will display this message.<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h12_00.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-15282 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h12_00.png\" alt=\"\" width=\"264\" height=\"146\" \/><\/a><\/p>\n<h3><a id=\"importing-email-contacts-intoo-constant-contact\"><\/a>Importing Email Contacts into Constant Contact<\/h3>\n<p>Click on the &#8220;<strong>Contacts<\/strong>&#8221; tab.<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h19_46.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-15291 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h19_46.png\" alt=\"\" width=\"620\" height=\"404\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h19_46.png 620w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h19_46-300x195.png 300w\" sizes=\"auto, (max-width: 620px) 100vw, 620px\" \/><\/a><\/p>\n<p>Click &#8220;<strong>Add Contacts<\/strong>.&#8221;<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h20_18.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-15292\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h20_18-1024x276.png\" alt=\"\" width=\"1024\" height=\"276\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h20_18-1024x276.png 1024w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h20_18-300x81.png 300w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h20_18-768x207.png 768w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h20_18.png 1256w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p>Select &#8220;<strong>Upload from file<\/strong>.&#8221;<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h20_52.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-15293 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h20_52.png\" alt=\"\" width=\"720\" height=\"592\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h20_52.png 957w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h20_52-300x247.png 300w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h20_52-768x632.png 768w\" sizes=\"auto, (max-width: 720px) 100vw, 720px\" \/><\/a><\/p>\n<p>Upload your .CSV or .XLS file.<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h21_47.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-15294\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h21_47-1024x427.png\" alt=\"\" width=\"1024\" height=\"427\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h21_47-1024x427.png 1024w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h21_47-300x125.png 300w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h21_47-768x320.png 768w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h21_47.png 1250w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h23_43.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-15295\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h23_43-1024x532.png\" alt=\"\" width=\"1024\" height=\"532\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h23_43-1024x532.png 1024w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h23_43-300x156.png 300w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h23_43-768x399.png 768w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h23_43.png 1306w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p>Confirm you have permission to email these contacts.<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h24_14.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-15296\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h24_14-1024x305.png\" alt=\"\" width=\"1024\" height=\"305\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h24_14-1024x305.png 1024w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h24_14-300x89.png 300w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h24_14-768x229.png 768w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h24_14-1536x458.png 1536w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h24_14.png 1814w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p>Make sure they are a part of a list by clicking on the checkbox next to the list&#8217;s name. You may add a new list if you wish by clicking on &#8220;<strong>Create a new list<\/strong>.&#8221;<\/p>\n<p>Click &#8220;<strong>Upload<\/strong>.&#8221;<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h24_26.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-15297\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h24_26-1024x382.png\" alt=\"\" width=\"1024\" height=\"382\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h24_26-1024x382.png 1024w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h24_26-300x112.png 300w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h24_26-768x286.png 768w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-08-03_13h24_26.png 1271w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<h3><strong><a id=\"importing-email-contacts-into-gmail\"><\/a>Importing Email Contacts into Gmail<\/strong><\/h3>\n<p>To import this data into Gmail, follow these steps.<\/p>\n<p>Head to <strong>https:\/\/contacts.google.com<\/strong>.<\/p>\n<p>Click on &#8220;<strong>Import Contacts<\/strong>.&#8221;<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-04_14h18_26.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13780 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-04_14h18_26.png\" alt=\"\" width=\"492\" height=\"456\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-04_14h18_26.png 492w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-04_14h18_26-300x278.png 300w\" sizes=\"auto, (max-width: 492px) 100vw, 492px\" \/><\/a><\/p>\n<p>Click on &#8220;<strong>Select File<\/strong>&#8221; and locate your CSV file.<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-04_14h21_07.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13783 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-04_14h21_07.png\" alt=\"\" width=\"511\" height=\"311\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-04_14h21_07.png 511w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-04_14h21_07-300x183.png 300w\" sizes=\"auto, (max-width: 511px) 100vw, 511px\" \/><\/a><\/p>\n<p>Your contacts will start uploading.<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-04_14h23_44.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13784 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-04_14h23_44.png\" alt=\"\" width=\"325\" height=\"109\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-04_14h23_44.png 325w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-04_14h23_44-300x101.png 300w\" sizes=\"auto, (max-width: 325px) 100vw, 325px\" \/><\/a><\/p>\n<p>Once finished, you should see a screen with your contacts listed.<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-04_14h23_59.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-13785\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-04_14h23_59-1024x653.png\" alt=\"\" width=\"940\" height=\"599\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-04_14h23_59-1024x653.png 1024w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-04_14h23_59-300x191.png 300w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-04_14h23_59-768x490.png 768w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/04\/2022-04-04_14h23_59.png 1277w\" sizes=\"auto, (max-width: 940px) 100vw, 940px\" \/><\/a><\/p>\n<p><em>Outlook and other email application instructions coming soon.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Having a customer&#8217;s email address is a great way to send them information about their orders and keep them up-to-date on what&#8217;s going on at your store. Though you can email customers directly through Artisan, we recommend mass-emailing customers using a service like Constant Contact. To do so, you&#8217;ll need&#8230;<\/p>\n","protected":false},"author":17,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_eb_attr":"","_monsterinsights_skip_tracking":false,"footnotes":"","_members_access_role":[],"_members_access_error":""},"ht-kb-category":[339],"ht-kb-tag":[],"class_list":["post-13765","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-customer-reports"],"_links":{"self":[{"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb\/13765","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/users\/17"}],"replies":[{"embeddable":true,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/comments?post=13765"}],"version-history":[{"count":24,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb\/13765\/revisions"}],"predecessor-version":[{"id":15300,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb\/13765\/revisions\/15300"}],"wp:attachment":[{"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/media?parent=13765"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb-category?post=13765"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb-tag?post=13765"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}