O365-Report-Excel-COM-Interface

Blog Link

YouTube Link

.Description

Generate an Excel workbook report based on infromation gathered from your Office 365 tenant.

Report Goals

For my report, I wanted to make sure it could do at least the following:

1. Make a separate WorkSheet for each report
2. Each WorkSheet will have a nice, clean heading 1.Report the following:
   1. Licensed Mailboxes
      1. Users with licenses
      2. Display Name
      3. Friendly License Name
         1. If no friendly name found, just use the AccountSkuID
      4. Primary E-Mail Addresses
      5. Alias E-Mail Addresses
   2. Groups
      1. Group Name
      2. Group Type
         1. Distribution
         2. Office 365 Group
         3. Security Group
         4. etc...
      3. Group E-Mail Address (if its got one!)
   3. Shared Mailboxes
      1. Shared Mailbox Name
      2. E-Mail Address
   4. Contacts
      1. Name
      2. E-Mail Address
   5. Public Folders
      1. Name
      2. If It's Mail-Enabled
      3. E-Mail Address
   6. Domains
      1. Domain Name
      2. If its fully verified
      3. If its default
         1. If it's default, highlight it
3. Make the report good looking, and easy to read
4. Show the data in alphabetical order
5. Auto-Format Excel rows and columns