{"id":1149,"date":"2013-03-26T21:12:49","date_gmt":"2013-03-26T21:12:49","guid":{"rendered":"http:\/\/blogs.goucher.edu\/knowledgebase\/?p=1149"},"modified":"2019-01-02T19:15:50","modified_gmt":"2019-01-02T19:15:50","slug":"convert-email-addresses-in-excel-to-outlook-email-list","status":"publish","type":"post","link":"https:\/\/blogs.goucher.edu\/knowledgebase\/2013\/03\/26\/convert-email-addresses-in-excel-to-outlook-email-list\/","title":{"rendered":"Convert Email Addresses in Excel to Outlook Email List"},"content":{"rendered":"

How do I convert a column of email address in Excel to a useable list in Outlook?<\/em><\/p>\n

Notes<\/strong>:<\/p>\n

These instructions work for both PC and Mac computers, using Outlook or Outlook Web Access.
\nThe email addresses must be complete (name@server.xxx) and listed in a single Excel column to use these instructions successfully.<\/p>\n

Steps<\/strong>:<\/p>\n

    \n
  1. Copy and paste the column of email addresses into a blank Microsoft Word document.<\/li>\n
  2. A small clipboard appears to the right of the data. Click on this once and select Keep Text Only.<\/li>\n
  3. Click the REPLACE button on the Home tab (sometimes found under Edit > Replace).<\/li>\n
  4. Click inside the \u201cFind\u201d box and enter ^p. (Hint: The carat symbol \u201c^\u201d is typed using Shift-6.)<\/li>\n
  5. Click inside the \u201cReplace\u201d box and type in a semi-colon. (Hint: The semi-colon key on most keyboards is to the immediate right of the letter L.)<\/li>\n
  6. Click the REPLACE ALL button. When the process is finished, hit OK and close the Find\/Replace window.<\/li>\n<\/ol>\n

    You now have a list that can be copy and pasted into the TO,CC,or BCC sections of an Outlook email message.<\/p>\n","protected":false},"excerpt":{"rendered":"

    How do I convert a column of email address in Excel to a useable list in Outlook? Notes: These instructions work for both PC and Mac computers, using Outlook or Outlook Web Access. The email addresses must be complete (name@server.xxx) and listed in a single Excel column to use these instructions successfully. Steps: Copy and […]<\/p>\n","protected":false},"author":236,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[486,7638,5],"tags":[491,20038],"class_list":["post-1149","post","type-post","status-publish","format-standard","hentry","category-email","category-email-faculty-and-staff","category-faculty","tag-excel","tag-outlook"],"yoast_head":"\nConvert Email Addresses in Excel to Outlook Email List - Goucher College Technology Knowledgebase<\/title>\n<meta name=\"robots\" content=\"noindex, follow\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Convert Email Addresses in Excel to Outlook Email List - Goucher College Technology Knowledgebase\" \/>\n<meta property=\"og:description\" content=\"How do I convert a column of email address in Excel to a useable list in Outlook? Notes: These instructions work for both PC and Mac computers, using Outlook or Outlook Web Access. The email addresses must be complete (name@server.xxx) and listed in a single Excel column to use these instructions successfully. Steps: Copy and […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blogs.goucher.edu\/knowledgebase\/2013\/03\/26\/convert-email-addresses-in-excel-to-outlook-email-list\/\" \/>\n<meta property=\"og:site_name\" content=\"Goucher College Technology Knowledgebase\" \/>\n<meta property=\"article:published_time\" content=\"2013-03-26T21:12:49+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-01-02T19:15:50+00:00\" \/>\n<meta name=\"author\" content=\"frmci001\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"frmci001\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/blogs.goucher.edu\\\/knowledgebase\\\/2013\\\/03\\\/26\\\/convert-email-addresses-in-excel-to-outlook-email-list\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/blogs.goucher.edu\\\/knowledgebase\\\/2013\\\/03\\\/26\\\/convert-email-addresses-in-excel-to-outlook-email-list\\\/\"},\"author\":{\"name\":\"frmci001\",\"@id\":\"https:\\\/\\\/blogs.goucher.edu\\\/knowledgebase\\\/#\\\/schema\\\/person\\\/0bb82d06b6b36a79589402823383aedf\"},\"headline\":\"Convert Email Addresses in Excel to Outlook Email List\",\"datePublished\":\"2013-03-26T21:12:49+00:00\",\"dateModified\":\"2019-01-02T19:15:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/blogs.goucher.edu\\\/knowledgebase\\\/2013\\\/03\\\/26\\\/convert-email-addresses-in-excel-to-outlook-email-list\\\/\"},\"wordCount\":194,\"keywords\":[\"excel\",\"Outlook\"],\"articleSection\":[\"email\",\"email-faculty and staff\",\"Faculty\\\/Staff\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/blogs.goucher.edu\\\/knowledgebase\\\/2013\\\/03\\\/26\\\/convert-email-addresses-in-excel-to-outlook-email-list\\\/\",\"url\":\"https:\\\/\\\/blogs.goucher.edu\\\/knowledgebase\\\/2013\\\/03\\\/26\\\/convert-email-addresses-in-excel-to-outlook-email-list\\\/\",\"name\":\"Convert Email Addresses in Excel to Outlook Email List - Goucher College Technology Knowledgebase\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/blogs.goucher.edu\\\/knowledgebase\\\/#website\"},\"datePublished\":\"2013-03-26T21:12:49+00:00\",\"dateModified\":\"2019-01-02T19:15:50+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/blogs.goucher.edu\\\/knowledgebase\\\/#\\\/schema\\\/person\\\/0bb82d06b6b36a79589402823383aedf\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/blogs.goucher.edu\\\/knowledgebase\\\/2013\\\/03\\\/26\\\/convert-email-addresses-in-excel-to-outlook-email-list\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/blogs.goucher.edu\\\/knowledgebase\\\/2013\\\/03\\\/26\\\/convert-email-addresses-in-excel-to-outlook-email-list\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/blogs.goucher.edu\\\/knowledgebase\\\/2013\\\/03\\\/26\\\/convert-email-addresses-in-excel-to-outlook-email-list\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/blogs.goucher.edu\\\/knowledgebase\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Convert Email Addresses in Excel to Outlook Email List\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/blogs.goucher.edu\\\/knowledgebase\\\/#website\",\"url\":\"https:\\\/\\\/blogs.goucher.edu\\\/knowledgebase\\\/\",\"name\":\"Goucher College Technology Knowledgebase\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/blogs.goucher.edu\\\/knowledgebase\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/blogs.goucher.edu\\\/knowledgebase\\\/#\\\/schema\\\/person\\\/0bb82d06b6b36a79589402823383aedf\",\"name\":\"frmci001\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4db71a58edaa3881d3b19f97940f40f9d679d3cb1221d5261eec883e463dd45d?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4db71a58edaa3881d3b19f97940f40f9d679d3cb1221d5261eec883e463dd45d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4db71a58edaa3881d3b19f97940f40f9d679d3cb1221d5261eec883e463dd45d?s=96&d=mm&r=g\",\"caption\":\"frmci001\"},\"url\":\"https:\\\/\\\/blogs.goucher.edu\\\/knowledgebase\\\/author\\\/frmci001\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Convert Email Addresses in Excel to Outlook Email List - Goucher College Technology Knowledgebase","robots":{"index":"noindex","follow":"follow"},"og_locale":"en_US","og_type":"article","og_title":"Convert Email Addresses in Excel to Outlook Email List - Goucher College Technology Knowledgebase","og_description":"How do I convert a column of email address in Excel to a useable list in Outlook? Notes: These instructions work for both PC and Mac computers, using Outlook or Outlook Web Access. The email addresses must be complete (name@server.xxx) and listed in a single Excel column to use these instructions successfully. Steps: Copy and […]","og_url":"https:\/\/blogs.goucher.edu\/knowledgebase\/2013\/03\/26\/convert-email-addresses-in-excel-to-outlook-email-list\/","og_site_name":"Goucher College Technology Knowledgebase","article_published_time":"2013-03-26T21:12:49+00:00","article_modified_time":"2019-01-02T19:15:50+00:00","author":"frmci001","twitter_card":"summary_large_image","twitter_misc":{"Written by":"frmci001","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/blogs.goucher.edu\/knowledgebase\/2013\/03\/26\/convert-email-addresses-in-excel-to-outlook-email-list\/#article","isPartOf":{"@id":"https:\/\/blogs.goucher.edu\/knowledgebase\/2013\/03\/26\/convert-email-addresses-in-excel-to-outlook-email-list\/"},"author":{"name":"frmci001","@id":"https:\/\/blogs.goucher.edu\/knowledgebase\/#\/schema\/person\/0bb82d06b6b36a79589402823383aedf"},"headline":"Convert Email Addresses in Excel to Outlook Email List","datePublished":"2013-03-26T21:12:49+00:00","dateModified":"2019-01-02T19:15:50+00:00","mainEntityOfPage":{"@id":"https:\/\/blogs.goucher.edu\/knowledgebase\/2013\/03\/26\/convert-email-addresses-in-excel-to-outlook-email-list\/"},"wordCount":194,"keywords":["excel","Outlook"],"articleSection":["email","email-faculty and staff","Faculty\/Staff"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/blogs.goucher.edu\/knowledgebase\/2013\/03\/26\/convert-email-addresses-in-excel-to-outlook-email-list\/","url":"https:\/\/blogs.goucher.edu\/knowledgebase\/2013\/03\/26\/convert-email-addresses-in-excel-to-outlook-email-list\/","name":"Convert Email Addresses in Excel to Outlook Email List - Goucher College Technology Knowledgebase","isPartOf":{"@id":"https:\/\/blogs.goucher.edu\/knowledgebase\/#website"},"datePublished":"2013-03-26T21:12:49+00:00","dateModified":"2019-01-02T19:15:50+00:00","author":{"@id":"https:\/\/blogs.goucher.edu\/knowledgebase\/#\/schema\/person\/0bb82d06b6b36a79589402823383aedf"},"breadcrumb":{"@id":"https:\/\/blogs.goucher.edu\/knowledgebase\/2013\/03\/26\/convert-email-addresses-in-excel-to-outlook-email-list\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blogs.goucher.edu\/knowledgebase\/2013\/03\/26\/convert-email-addresses-in-excel-to-outlook-email-list\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/blogs.goucher.edu\/knowledgebase\/2013\/03\/26\/convert-email-addresses-in-excel-to-outlook-email-list\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/blogs.goucher.edu\/knowledgebase\/"},{"@type":"ListItem","position":2,"name":"Convert Email Addresses in Excel to Outlook Email List"}]},{"@type":"WebSite","@id":"https:\/\/blogs.goucher.edu\/knowledgebase\/#website","url":"https:\/\/blogs.goucher.edu\/knowledgebase\/","name":"Goucher College Technology Knowledgebase","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blogs.goucher.edu\/knowledgebase\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/blogs.goucher.edu\/knowledgebase\/#\/schema\/person\/0bb82d06b6b36a79589402823383aedf","name":"frmci001","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4db71a58edaa3881d3b19f97940f40f9d679d3cb1221d5261eec883e463dd45d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4db71a58edaa3881d3b19f97940f40f9d679d3cb1221d5261eec883e463dd45d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4db71a58edaa3881d3b19f97940f40f9d679d3cb1221d5261eec883e463dd45d?s=96&d=mm&r=g","caption":"frmci001"},"url":"https:\/\/blogs.goucher.edu\/knowledgebase\/author\/frmci001\/"}]}},"_links":{"self":[{"href":"https:\/\/blogs.goucher.edu\/knowledgebase\/wp-json\/wp\/v2\/posts\/1149","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.goucher.edu\/knowledgebase\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.goucher.edu\/knowledgebase\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.goucher.edu\/knowledgebase\/wp-json\/wp\/v2\/users\/236"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.goucher.edu\/knowledgebase\/wp-json\/wp\/v2\/comments?post=1149"}],"version-history":[{"count":7,"href":"https:\/\/blogs.goucher.edu\/knowledgebase\/wp-json\/wp\/v2\/posts\/1149\/revisions"}],"predecessor-version":[{"id":1156,"href":"https:\/\/blogs.goucher.edu\/knowledgebase\/wp-json\/wp\/v2\/posts\/1149\/revisions\/1156"}],"wp:attachment":[{"href":"https:\/\/blogs.goucher.edu\/knowledgebase\/wp-json\/wp\/v2\/media?parent=1149"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.goucher.edu\/knowledgebase\/wp-json\/wp\/v2\/categories?post=1149"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.goucher.edu\/knowledgebase\/wp-json\/wp\/v2\/tags?post=1149"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}