2014response.ps1

$list = ipcsv '.\2014respond.csv';

#$list | ForEach-Object { Write-Host ($_.LastName)($_.FirstName.Substring(0,1)) }

$process = ForEach ($user in $list)
{
    
    $user3 = $user.LastName +""+ $user.FirstName.Substring(0,1)
    try{
        $user2 = Get-ADUser $user3 -Properties mail
    }
    catch{
        $user2.mail = "ERROR"
    }

    [PSCustomObject]@{RespondantID=$user.RespondentID;FirstName=$user.FirstName;LastName=$user.LastName;Email=$user2.mail}
}

$process | export-csv -Path '.\emails.csv'