🎉 Our Office 365 Reporting Tool is now available in Azure Marketplace 🚀
This website uses cookies to improve your experience. We'll assume you're ok with this. Know more.
Azure AD

How to Get Microsoft 365 Contacts Report

Managing Microsoft 365 external contacts is crucial for facilitating partnerships and enhancing collaboration. Yet, without regular updates of contact information, the Global Address List can become cluttered, hindering communication efficiency. This guide will show you how to streamline Microsoft 365 contacts, ensuring your contact list remains a powerful asset for seamless collaboration.

Using Microsoft 365 Admin Center

Microsoft 365 Permission Required
Global Admin or an Exchange Admin.
  • Login to the Microsoft 365 admin center.
  • Navigate to Users»Contacts. Here, you can view all Microsoft 365 contacts within your organization.
Using Microsoft 365 Admin Center
  • You can click on the "Choose columns" icon highlighted above to view only the necessary Microsoft 365 contact information.

Using Exchange Online Admin Center

Microsoft 365 Permission Required
Global Admin or an Exchange Admin.
Using Exchange Online Admin Center
  • This page displays both mail contacts and mail users within your Microsoft 365 organization.

Using Windows PowerShell

Microsoft 365 Permission Required
Global Admin or an Exchange Admin.
  • Connect to the MS Graph PowerShell using the below cmdlet.
  • Windows PowerShell Windows PowerShell
     Connect-MgGraph
  • Run the below cmdlet to get all Microsoft 365 contacts using PowerShell.
  • Windows PowerShell Windows PowerShell
     Get-MgContact
Using Windows PowerShell
  • With this cmdlet, you can obtain the email addresses and contact IDs of Microsoft 365 contacts.

Mitigate communication gaps by updating Microsoft 365 contact properties!

The AdminDroid Azure AD reporting tool provides extensive reports on Microsoft 365 contacts. With these reports, you can easily maintain an organized and accessible directory of contacts with whom users frequently communicate. Moreover, you can monitor the emails sent to these external contacts to prevent the loss of sensitive information.

Track Exchange Online External Emails

Microsoft 365 outbound external email report from AdminDroid helps you monitor emails sent to external domains, thereby safeguarding against sensitive data leaks.

Monitor DLP in your Exchange Online

Check the events of Exchange Online DLP rule matches to prevent unauthorized sharing of sensitive information to mail contacts.

Visualize Email Analytics Reporting

Access the Microsoft 365 email analytics dashboard for detailed insights into emails sent to external contacts in your Exchange Online organization.

Manage Mail Users’ Licenses

Track Microsoft 365 users' license changes to stay informed about assigned licenses for Exchange mail users and revoke any unnecessary licenses.

Audit External Spoof Emails in EXO

Examine Microsoft 365 external spoof emails and delete their mail contacts if they appear suspicious in your organization.

Review Microsoft 365 Distribution Lists

Retrieve all Microsoft 365 distribution groups within your organization and include mail contacts in relevant groups for effective communication.

In summary, AdminDroid helps your organization to optimize interactions with Microsoft 365 contacts. It ensures that individuals within your organization can communicate with appropriate external contacts from their Global Address List.

Explore a full range of reporting options

Important Tips

Monitor Microsoft 365 spam emails from external senders and delete their contacts if they appear suspicious.

Tag external emails in Microsoft 365 to help your users pay closer attention when responding to mail contacts.

Review mail flow rules in Exchange Online to detect any excessively permissive rules applied to Microsoft 365 contacts in your organization.

Common Errors and Resolution Steps

The following are the possible errors and troubleshooting hints while dealing with Microsoft 365 Contacts.

Error Write-ErrorMessage : Cannot process argument transformation on parameter 'Alias'. Cannot convert value "<Alias>" to type "System.String". Error: "Alias: Property expression "<Alias>" isn't valid.

This error occurs when you add a space while specifying an alias for a mail contact.

Fix Use alphabets, numbers, and other characters without a space.

Error Get-MgContact : One or more errors occured.

This error occurs when you use older versions of Microsoft Graph module.

Fix Uninstall all the older versions and install the required version of Microsoft Graph module.
// Run the below cmdlet to uninstall all the older versions of Microsoft Graph module.
Uninstall-Module Microsoft.Graph -AllVersions
// Run the below cmdlet to install the required latest version of the Microsoft Graph module.
Install-Module -Name "Microsoft.Graph" -RequiredVersion <LatestVersion> -Force

Error Exception of type Microsoft.Online.Box.Util.Exceptions.InternalException.

This error occurs when you don’t have the necessary permission to create contacts in Microsoft 365.

Fix Ask your global admin to grant the Mail Recipient Creation permission under the Organization Management role group.

Error The term 'Get-MailContact' is not recognized as the name of a cmdlet, function, script file, or operable program.

This error occurs when you run the Get-MailContact cmdlet without connecting to the Exchange Online PowerShell.

Fix Run the below cmdlet to connect to the Exchange Online PowerShell.
Connect-ExchangeOnline

Error Write-ErrorMessage : Ex94914C|Microsoft.Exchange.Configuration.Tasks.ManagementObjectNotFoundException|Couldn't find object "<EmailID>".

This error occurs when you specify a wrong email ID of the mail contact while adding them to a distribution group.

Fix Run the below cmdlet to get the email address of the mail contact.
Get-MailContact -Identity "<ContactName>" | Select-Object ExternalEmailAddress

Frequently Asked Questions

Manage External Contacts for Efficient Communication in Microsoft 365

How to create an external contact in Microsoft 365?

How to create an external contact in Microsoft 365? +

Microsoft 365 contacts refer to individuals both within and outside your organization, including external colleagues, clients, and partners. They are added as contacts within your organization to communicate efficiently for your business needs.

Follow the steps below to create a new contact in Microsoft 365.

Using Microsoft 365 Admin Center

  • Login to the Microsoft 365 admin center. Navigate to Users»Contacts.
  • Select the "Add a contact" option. Enter the required information for a contact and click on Add.
  • You can use the MailTip section to include a notification that alerts users before they send a message to this contact. It is displayed when this contact is added to the To, Cc, or Bcc fields of a new email.

Using Exchange Online Admin Center

  • Login to the Exchange Online admin center. Navigate to Recipients»Contacts.
  • Select the "Add a mail contact" option. Enter the basic and contact information and click on Add.

After a contact has been created, it will be automatically added to your organization’s default global address list.

How to bulk import external contacts in Microsoft 365 using PowerShell?

How to bulk import external contacts in Microsoft 365 using PowerShell? +

Creating bulk Microsoft 365 contacts can be a time-consuming process. To streamline this task, you can create a CSV file containing all the necessary contact information and then import it using PowerShell.

Follow the steps below to bulk import external contacts to Exchange Online.

  • Create a CSV file with contact Name and ExternalEmailAddress info. You can also add other properties like FirstName, LastName, StreetAddress, City, Phone, Company, Title, etc.

    Note: Mention the column names exactly as mentioned above.
  • Run the below cmdlet to create bulk mail contacts in Office 365 using PowerShell.
    Import-Csv .\ExternalContacts.csv|%{New-MailContact -Name $_.Name -DisplayName $_.Name -ExternalEmailAddress $_.ExternalEmailAddress -FirstName $_.FirstName -LastName $_.LastName}

How to export contacts from the Microsoft 365 admin portal?

How to export contacts from the Microsoft 365 admin portal? +

Monitor your Microsoft 365 contacts to ensure seamless collaboration with external colleagues, clients, and partners. You can update the necessary contact properties and eliminate unwanted clients who may not be needed for your organization.

You can export contacts from Office 365 using the methods below.

Using Microsoft 365 Admin Center

Navigate to Users»Contacts. You can export Microsoft 365 contacts to CSV by clicking on the "Export contacts" icon.

Microsoft PowerShell

The following cmdlets are used to export Microsoft 365 contacts in the Exchange Online PowerShell.

Get-Contact | Select-Object DisplayName, EmailAddresses, Phone, MobilePhone, Company | Export-Csv -Path 'C:\contacts.csv' -NoTypeInformation
Get-MailContact | Export-Csv -Path 'C:\contacts1.csv' -NoTypeInformation

The Get-Contact cmdlet retrieves non-mail properties for contacts, whereas the Get-MailContact cmdlet fetches all mail-related properties.

If you’re an organization with bulk contacts, managing them through the Microsoft 365 admin center can be challenging. Additionally, specifying required attributes in the PowerShell cmdlet to obtain comprehensive details is a time-consuming process.

With AdminDroid, you can easily export Microsoft 365 contacts in various formats such as HTML, PDF, CSV, XLS, and XLSX.

  • You can access in-depth information on Microsoft 365 contacts, such as display name, company name, email ID, department, job title, mobile number, and more.
  • Click on the Download/Export icon to download the report in your desired format.
contacts-export

Pro Tip: Make use of the "Company Name" easy filter to view mail contacts from specified companies.

How to add external contacts to a distribution group in Microsoft 365?

How to add external contacts to a distribution group in Microsoft 365? +

You can add external contacts to distribution lists to facilitate effective communication on shared projects.

Follow the steps below to add a user or contact to a Microsoft 365 distribution group.

  • Login to the Microsoft 365 admin center. Navigate to Teams & groups»Active teams & groups.
  • Select the desired group under the Distribution list section. Under the Members tab, click on the "View all and manage members" link.
  • Tap on the +Add members option to add the required contact.

However, inappropriate group memberships for these external contacts can lead to loss of sensitive information. Thus, it is crucial to monitor their group memberships to avoid potential issues.

Run the PowerShell script below to get the group membership of Microsoft 365 contacts.

$contacts= Get-MgContact

$output = foreach ($contact in $contacts) { 

foreach ($group in (Get-MgContactTransitiveMemberOf -OrgContactId $contact.Id)) { 

$groupName = (Get-MgGroup -Filter "id eq '$($group.Id)'").DisplayName 

[pscustomobject]@{ 

'Contact Display Name' = $contact.DisplayName 

'Distribution Group Name'= $groupName 

'Contact ID'= $contact.Id 

} 

} 

 } 

$output | Export-Csv -Path "D:\GroupMembershipofContacts.csv" -NoTypeInformation 

Using AdminDroid, you can find the external contacts in distribution groups and remove any unwanted group membership in your organization.

  • Explore complete details including group name, contact name, email ID, company, job title, sign-in status, and other relevant information.
  • Pro Tip: Leverage the graphical representation functionality to visually get all groups a mail contact belongs to.
contact-group-memberships

How to manage contacts in Microsoft 365?

How to manage contacts in Microsoft 365? +

Effective management of Microsoft 365 contacts is essential for enhancing interactions with external partners. By maintaining up-to-date contact information, your users can easily reach out to the right individuals for specific tasks or updates.

Follow the ways below to manage mail contacts in Exchange Online.

Change Microsoft 365 contact information

Run the below PowerShell cmdlet to update contact information in Exchange Online.

Set-Contact "<ContactName>" -Title "<JobTitle>" -Department "<DepartmentName>" -Company "<CompanyName>" -Manager "<ManagerName>"

You can use the below cmdlet to modify mail-related properties of Microsoft 365 contacts.

Set-MailContact -Identity "<ContactName>" -ExternalEmailAddress "<EmailID>"

Remove contacts from Microsoft 365

Run the below cmdlet in Exchange Online PowerShell to remove a Microsoft 365 contact from your organization.

Remove-MailContact -Identity "<MailContactIdentity>"

With AdminDroid, you can easily monitor activities related to updating Microsoft 365 contact information that helps you to verify the accuracy of the modified property.

  • Acquire detailed records like event time, performed operation, performed user, contact name, and modified parameters.
  • Pro Tip: Apply the "Performed Operation" easy filter to retrieve events related to specific operations such as removing contacts, creating new contacts, and updating contact information.
mail-contact-changes

How to manage mail users in Exchange Online?

How to manage mail users in Exchange Online? +

Exchange Online mail users are similar to mail contacts. They are people outside your organization and have an external email address. However, mail users can have a user account in your organization with login credentials similar to an unlicensed user.

Follow the steps below to create a mail user in Microsoft 365.

  • Login to the Exchange Online admin center. Navigate to Recipients»Contacts.
  • Select the "Add a mail user" option. Enter the basic information of the user. You must also give a User ID and a Password. Click on Add.

Once created, they will be displayed on the Contacts page of your Exchange Online admin center as well as the Active users page of your Microsoft 365 admin center.

Convert mail user to a mailbox user in Microsoft 365

If the mail user doesn't have a mailbox in their organization, you can convert them to a mailbox user. To convert a mail user to a mailbox user, simply assign an Exchange Online license to the mail user by navigating to the Active users page of your Microsoft 365 admin portal.

Emails sent to mail users are directed to their specified external email address. However, if you've allocated an Exchange Online license to the mail user, the emails will be routed to the Exchange Online mailbox given by your organization.


Note: After assigning licenses to mail users, they will no longer be displayed in the Contacts page of your Exchange Online admin center. You can manage them from the Active users page of your Microsoft 365 admin center.

With AdminDroid, you can audit the Exchange mail user changes and remove unnecessary modifications in your Microsoft 365 organization.

  • Here, you get entire details on event time, performed operation, who performed, mail username, and updated information.
  • Pro Tip: Utilize the "Modified Rule" column to obtain comprehensive information about all the properties of an Exchange Online mail user.
mail-user-changes
+

Kickstart Your Journey With
AdminDroid

Your Microsoft 365 Companion with Enormous Reporting Capabilities

Download Now
User Help Manuals Compliance Docs
x
Delivering Reports on Time
Want a desired Microsoft 365 reports every Monday morning? Ensure automated report distribution and timely delivery with AdminDroid's Scheduling to your email anytime you need.
Delivering Reports on Time
Schedule tailored reports to execute automatically at the time you set and deliver straight to the emails you choose. In addition, you can customize report columns and add inteligent filtering to the activities just from the previous day to suit your Microsoft 365 report requirements.
Set It, Schedule It, See Results- Your Reports, Your Way, On Your Time!
Time Saving
Automation
Customization
Intelligent Filtering
Give Just the Right Access to the Right People
Grant fine-tuned access to any Microsoft 365 user with AdminDroid’s Granular Delegation and meet your organization’s security and compliance requirements.
Give Just the Right Access to the Right People
Create custom roles loaded with just the right permissions and give access to admins or normal users within AdminDroid. The result? A streamlined Microsoft 365 management experience that aligns your organization's security protocols and saves your invaluable time and effort.
Align, Define, Simplify: AdminDroid's Granular Delegation
Smart Organizational Control
Effortless M365 Management
Simplified Access
Advanced Alerts at a Glance
Receive quick notifications for malicious Microsoft 365 activities. Engage with the AdminDroid’s real-time alert policies crafted to streamline your security investigations.
Advanced Alerts at a Glance
Stay informed of critical activities like suspicious emails and high-risk logins, bulk file sharing, etc. Through creating and validating ideal alert policies, AdminDroid provides a comprehensive approach to real-time monitoring and management of potential threats within your organization.
AdminDroid Keeps You Always Vigilant, Never Vulnerable!
Proactive Protection
Real-time Monitoring
Security Intelligence
Threat Detection
Merge the Required Data to One Place
Combine multiple required columns into one comprehensive report and prioritize the information that matters most to you with AdminDroid’s Advanced Column Customization.
Merge the Required Data to One Place
This column merging capability offers a flexible way to add different columns from various reports and collate all the essential data in one place. Want to revisit the customized report? Save it as a 'View’, and your unique report is ready whenever you need it.
Merge with Ease and Save as Views!
Custom Reporting
Unique View
Desired Columns
Easy Data Interpretation
Insightful Charts and Exclusive Dashboards
Get a quick and easy overview of your tenant's activity, identify potential problems, and take action to protect your data with AdminDroid’s Charts and Dashboards.
Insightful Charts and Exclusive Dashboards
With AdminDroid charts and dashboards, visualize your Microsoft 365 tenant in ways you've never thought possible. It's not just about viewing; it's about understanding, controlling, and transforming your Microsoft 365 environment.
Explore Your Microsoft 365 Tenant in a Whole New Way!
Executive overviews
Interactive insights
Decision-making
Data Visualization
Efficient Report Exporting for Microsoft 365
Downloading your reports in the right file format shouldn’t be a hassle with AdminDroid’s Report Export. Experience seamless report exporting in various formats that cater to your needs.
Efficient Report Exporting for Microsoft 365
Navigate through diverse options and export Microsoft 365 reports flawlessly in your desired file format. Tailor your reports precisely as you need them and save them directly to your computer.
Take Control, Customize and Deliver- Your Office 365 Data, Exported in Your Way!
Easy Export
Seamless Downloading
Data Control
Manage Microsoft 365

Get AdminDroid Office 365 Reporter Now!