Add Output of two Powershell commands into an Array

Question

I've been trying to figure out if this is even possible in Powershell. I'm trying to pull a list of all users and their email addresses into an array from the Outlook Global Address List so the resulting output would look like this:

Alice Peters [email protected]
Bob Jackson [email protected]
etc

I'm currently able to pull the information using:

[Microsoft.Office.Interop.Outlook.Application] $galSearch = New-Object -ComObject Outlook.Application

$search = @($galSearch.Session.GetGlobalAddressList().AddressEntries | ForEach-Object {$_.GetExchangeUser().Name; $_.GetExchangeUser().PrimarySmtpAddress})

$search

As you might expect the result is formatted like this:

Alice Peters
[email protected]
Bob Jackson
[email protected]
etc

Is there a way to have them be in pairs and not one above the other?

$galSearch.Session.GetGlobalAddressList().AddressEntries | ForEach-Object GetExchangeUser |Select Name,PrimarySmtpAddress — Mathias R. Jessen
– Mathias R. Jessen, Commented Aug 24, 2021 at 14:26

Dennis · Accepted Answer · 2021-08-24 16:49:18Z

0

My Outlook doesn't have any content in the GAL so I can't verify my suggestion.

If the object types supports string handling, just joint the two results into one string.

ForEach-Object {
    $_.GetExchangeUser().Name + ' ' +  
    $_.GetExchangeUser().PrimarySmtpAddress
}

Otherwise, try converting to strings first.

ForEach-Object {
    ($_.GetExchangeUser().Name).ToString() + ' ' +  
    ($_.GetExchangeUser().PrimarySmtpAddress).ToString()
}

Or you could go for creating hashtables instead.

Or, the simplest solution as Mathias pointed out in his comment, go for just selecting the properties. That will return an object instead of arrays.

edited Aug 24, 2021 at 16:49

answered Aug 24, 2021 at 14:32

Dennis

2,1282 gold badges20 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Add Output of two Powershell commands into an Array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related