{"id":562,"date":"2016-02-24T21:41:17","date_gmt":"2016-02-24T21:41:17","guid":{"rendered":"https:\/\/regroove.ca\/stellark\/?p=562"},"modified":"2023-02-24T18:52:37","modified_gmt":"2023-02-24T18:52:37","slug":"get-all-office-365-email-addresses","status":"publish","type":"post","link":"https:\/\/regroove.ca\/stellark\/2016\/02\/24\/get-all-office-365-email-addresses\/","title":{"rendered":"Get All Office 365 Email Addresses"},"content":{"rendered":"<h3>Why would this be helpful?<\/h3>\n<p>If you have a tenancy where mail has always existed in Office365 and they now want to implement Directory Synchronization you will need to extract all user email addresses (proxy addresses) in order to import them into on-premises AD.<\/p>\n<p>Failure to update AD objects prior to Initial Sync will result in AD overwriting the user\u2019s alias\u2019s in Office 365.<\/p>\n<p>&nbsp;<\/p>\n<p>1) Connect to Office 365 Tenancy<\/p>\n<p>$Usercredential = Get-Credential <a href=\"mailto:someone@somewhere.com\">someone@somewhere.com<\/a><br \/>\nConnect-MSOLService -Credential $Usercredential<\/p>\n<p>&nbsp;<\/p>\n<p>2) Get all user email addresses<\/p>\n<p>Get-Mailbox | FT -Wrap Name, DisplayName,PrimarySmtpAddress,EmailAddresses<\/p>\n<p>&nbsp;<\/p>\n<p>3) Get all user email addresses to .csv<\/p>\n<p>Get-Mailbox -ResultSize Unlimited | Where {$_.name -NotLike &#8216;*DiscoverySearchMailbox*&#8217;} | Sort Alias | Select UserPrincipalName, DisplayName,Name, Alias,RecipientTypeDetails, EmailAddresses, PrimarySmtpAddress, MicrosoftOnlineServicesID, WindowsLiveID, WindowsEmailAddress | Export-CSV&nbsp; c:\\O365Info\\GetMailbox.csv \u2013NoTypeInformation<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Why would this be helpful? If you have a tenancy where mail has always existed in Office365 and they now want to implement Directory Synchronization you will need to extract all user email addresses (proxy addresses) in order to import them into on-premises AD. Failure to update AD objects prior to Initial Sync will result &hellip; <a href=\"https:\/\/regroove.ca\/stellark\/2016\/02\/24\/get-all-office-365-email-addresses\/\"><\/a><\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[47,60],"tags":[102,137,173,191],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Get All Office 365 Email Addresses - Stephanie Kahlam<\/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:\/\/regroove.ca\/stellark\/2016\/02\/24\/get-all-office-365-email-addresses\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Get All Office 365 Email Addresses - Stephanie Kahlam\" \/>\n<meta property=\"og:description\" content=\"Why would this be helpful? If you have a tenancy where mail has always existed in Office365 and they now want to implement Directory Synchronization you will need to extract all user email addresses (proxy addresses) in order to import them into on-premises AD. Failure to update AD objects prior to Initial Sync will result &hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/regroove.ca\/stellark\/2016\/02\/24\/get-all-office-365-email-addresses\/\" \/>\n<meta property=\"og:site_name\" content=\"Stephanie Kahlam\" \/>\n<meta property=\"article:published_time\" content=\"2016-02-24T21:41:17+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-02-24T18:52:37+00:00\" \/>\n<meta name=\"author\" content=\"Stephanie Kahlam\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Stephanie Kahlam\" \/>\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\":\"WebPage\",\"@id\":\"https:\/\/regroove.ca\/stellark\/2016\/02\/24\/get-all-office-365-email-addresses\/\",\"url\":\"https:\/\/regroove.ca\/stellark\/2016\/02\/24\/get-all-office-365-email-addresses\/\",\"name\":\"Get All Office 365 Email Addresses - Stephanie Kahlam\",\"isPartOf\":{\"@id\":\"https:\/\/regroove.ca\/stellark\/#website\"},\"datePublished\":\"2016-02-24T21:41:17+00:00\",\"dateModified\":\"2023-02-24T18:52:37+00:00\",\"author\":{\"@id\":\"https:\/\/regroove.ca\/stellark\/#\/schema\/person\/175e89cb69612178b2ac838c0bab6149\"},\"breadcrumb\":{\"@id\":\"https:\/\/regroove.ca\/stellark\/2016\/02\/24\/get-all-office-365-email-addresses\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/regroove.ca\/stellark\/2016\/02\/24\/get-all-office-365-email-addresses\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/regroove.ca\/stellark\/2016\/02\/24\/get-all-office-365-email-addresses\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Stellark Home\",\"item\":\"https:\/\/regroove.ca\/stellark\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Get All Office 365 Email Addresses\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/regroove.ca\/stellark\/#website\",\"url\":\"https:\/\/regroove.ca\/stellark\/\",\"name\":\"Stephanie Kahlam\",\"description\":\"Microsoft 365 and SMB.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/regroove.ca\/stellark\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/regroove.ca\/stellark\/#\/schema\/person\/175e89cb69612178b2ac838c0bab6149\",\"name\":\"Stephanie Kahlam\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/regroove.ca\/stellark\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/398b95e23dc9eaf37a780b86a239b485?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/398b95e23dc9eaf37a780b86a239b485?s=96&d=mm&r=g\",\"caption\":\"Stephanie Kahlam\"},\"url\":\"https:\/\/regroove.ca\/stellark\/author\/skahlam\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Get All Office 365 Email Addresses - Stephanie Kahlam","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:\/\/regroove.ca\/stellark\/2016\/02\/24\/get-all-office-365-email-addresses\/","og_locale":"en_US","og_type":"article","og_title":"Get All Office 365 Email Addresses - Stephanie Kahlam","og_description":"Why would this be helpful? If you have a tenancy where mail has always existed in Office365 and they now want to implement Directory Synchronization you will need to extract all user email addresses (proxy addresses) in order to import them into on-premises AD. Failure to update AD objects prior to Initial Sync will result &hellip;","og_url":"https:\/\/regroove.ca\/stellark\/2016\/02\/24\/get-all-office-365-email-addresses\/","og_site_name":"Stephanie Kahlam","article_published_time":"2016-02-24T21:41:17+00:00","article_modified_time":"2023-02-24T18:52:37+00:00","author":"Stephanie Kahlam","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Stephanie Kahlam","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/regroove.ca\/stellark\/2016\/02\/24\/get-all-office-365-email-addresses\/","url":"https:\/\/regroove.ca\/stellark\/2016\/02\/24\/get-all-office-365-email-addresses\/","name":"Get All Office 365 Email Addresses - Stephanie Kahlam","isPartOf":{"@id":"https:\/\/regroove.ca\/stellark\/#website"},"datePublished":"2016-02-24T21:41:17+00:00","dateModified":"2023-02-24T18:52:37+00:00","author":{"@id":"https:\/\/regroove.ca\/stellark\/#\/schema\/person\/175e89cb69612178b2ac838c0bab6149"},"breadcrumb":{"@id":"https:\/\/regroove.ca\/stellark\/2016\/02\/24\/get-all-office-365-email-addresses\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/regroove.ca\/stellark\/2016\/02\/24\/get-all-office-365-email-addresses\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/regroove.ca\/stellark\/2016\/02\/24\/get-all-office-365-email-addresses\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Stellark Home","item":"https:\/\/regroove.ca\/stellark\/"},{"@type":"ListItem","position":2,"name":"Get All Office 365 Email Addresses"}]},{"@type":"WebSite","@id":"https:\/\/regroove.ca\/stellark\/#website","url":"https:\/\/regroove.ca\/stellark\/","name":"Stephanie Kahlam","description":"Microsoft 365 and SMB.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/regroove.ca\/stellark\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/regroove.ca\/stellark\/#\/schema\/person\/175e89cb69612178b2ac838c0bab6149","name":"Stephanie Kahlam","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/regroove.ca\/stellark\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/398b95e23dc9eaf37a780b86a239b485?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/398b95e23dc9eaf37a780b86a239b485?s=96&d=mm&r=g","caption":"Stephanie Kahlam"},"url":"https:\/\/regroove.ca\/stellark\/author\/skahlam\/"}]}},"_links":{"self":[{"href":"https:\/\/regroove.ca\/stellark\/wp-json\/wp\/v2\/posts\/562"}],"collection":[{"href":"https:\/\/regroove.ca\/stellark\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/regroove.ca\/stellark\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/regroove.ca\/stellark\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/regroove.ca\/stellark\/wp-json\/wp\/v2\/comments?post=562"}],"version-history":[{"count":1,"href":"https:\/\/regroove.ca\/stellark\/wp-json\/wp\/v2\/posts\/562\/revisions"}],"predecessor-version":[{"id":1430,"href":"https:\/\/regroove.ca\/stellark\/wp-json\/wp\/v2\/posts\/562\/revisions\/1430"}],"wp:attachment":[{"href":"https:\/\/regroove.ca\/stellark\/wp-json\/wp\/v2\/media?parent=562"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/regroove.ca\/stellark\/wp-json\/wp\/v2\/categories?post=562"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/regroove.ca\/stellark\/wp-json\/wp\/v2\/tags?post=562"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}