AideXchange

$a = New-Object -comobject Excel.Application
 
$a.Visible = $True
 
$b = $a.Workbooks.Add()
$c = $b.Worksheets.Item(1)
 
$col = 1
$ligne = 1
 
$c.Cells.Item(1,1) = "DisplayName"
$c.Cells.Item(1,2) = "Alias"
$c.Cells.Item(1,3) = "Database"
 
$ligne++
 
Get-Mailbox -Identity *christophe* | foreach {
	$displayname = $_.displayname
	$alias = $_.alias
	$database = $_.database
	$col = 1
	$c.Cells.Item($ligne,$col) = [string]$displayname
	$col++
	$c.Cells.Item($ligne,$col) = [string]$alias
	$col++
	$c.Cells.Item($ligne,$col) = [string]$database
	$ligne++
}

$b.SaveAs("C:\Resultats\Result_Christophe.xls")
$a.Quit()