Generate a list of all mailboxes, with their SMTP addresses and other attributes
You may regularly need to produce lists of mailboxes containing a number of other pieces of information, for example their SMTP addresses, user location (Office) and their Employee Type.
You can easily achieve that by using Selected Attributes From Mailboxes, that you will find on the Templates > Inventory menu.
You simply need to select all mailboxes in the organization, or a group of mailboxes you wish to focus on, and then select the attributes you need to report on (First name, Last name, Email address, Office, Employee Type).
Finally, export your report as a CSV file, and then open that file in Excel.