From basics, we know how to:

• read CSV file
• write CSV file with new columns
• test email format from one column

Now let's discover how to query one Active Directory. First one new PowerShell module is required to deal with AD.

# once per server
Install-Module ActiveDirectory

Let's start from the same input we managed into basics part.