Скачать или смотреть How to Replace Display Names with Full Email Addresses in Powershell for Outlook

Learn how to modify your Powershell script to retrieve full email addresses instead of display names for required attendees in Outlook Calendar.
---
This video is based on the question https://stackoverflow.com/q/63996184/ asked by the user 'user1550159' ( https://stackoverflow.com/u/1550159/ ) and on the answer https://stackoverflow.com/a/63997166/ provided by the user 'Dmitry Streblechenko' ( https://stackoverflow.com/u/332059/ ) at 'Stack Overflow' website. Thanks to these great users and Stackexchange community for their contributions.

Visit these links for original content and any more details, such as alternate solutions, latest updates/developments on topic, comments, revision history etc. For example, the original title of the Question was: Powershell outlook replace display name with full email address

Also, Content (except music) licensed under CC BY-SA https://meta.stackexchange.com/help/l...
The original Question post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license, and the original Answer post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license.

If anything seems off to you, please feel free to write me at vlogize [AT] gmail [DOT] com.
---
How to Replace Display Names with Full Email Addresses in Powershell for Outlook

Managing your Outlook calendar using Powershell can save a lot of time and effort, especially when it comes to retrieving attendee information. However, a common hurdle many users encounter is that the script displays required attendees by their display names instead of their full email addresses. In this guide, we will explore how to modify your Powershell script to get the full email addresses of the required attendees in your Outlook calendar.

The Challenge

When you run a Powershell script intended to pull required attendees, you might find the output looks something like this:

[[See Video to Reveal this Text or Code Snippet]]

This is not very helpful if you're looking for their email addresses. Instead, what you want to achieve is an output that looks like:

[[See Video to Reveal this Text or Code Snippet]]

So, how can you adjust your script to display full email addresses rather than just display names? Let's break down the solution.

Understanding the Problem

The issue arises from the use of the RequiredAttendees property. This property returns display names corresponding to the PR_DISPLAY_TO MAPI property. In order to access the email addresses we need, we must change our approach and utilize the Recipients collection associated with an AppointmentItem in Powershell.

The Solution

To get the required email addresses instead of display names, follow these steps:

Access the Recipients Collection: Instead of using the RequiredAttendees property, you'll want to access the Recipients property of the AppointmentItem object.

Iterate Through Recipients: Loop through the Recipients collection and check if the recipient type equals olTo (which has a value of 1). This ensures you're only working with primary invitees.

Retrieve the Email Address:

Use the Recipient.Address property for most recipients.

For recipients found in the Global Address List (GAL) where the address is of type EX, you'll need to use the GetExchangeUser().PrimarySmtpAddress method to extract the email.

Modified Powershell Code

Here’s how the adjusted code should look:

[[See Video to Reveal this Text or Code Snippet]]

Conclusion

With the modified Powershell script provided above, you can now efficiently retrieve the full email addresses of required attendees within your Outlook calendar. This will not only ensure your data is presentable but also make it more useful for any follow-up actions you intend to carry out.

By utilizing the Recipients collection, you have expanded your script’s capabilities and improved its functionality. Happy scripting!