Import-Module ActiveDirectory
$Users = Import-Csv -Delimiter "`t" -Path "C:\Users\Administrator\Desktop\AnnexA.csv"
$password = "p@$$w0rd"
$domain = "PDDF.local"
$OU="OU=Customers,OU=All Users,DC=PDDF,DC=local, DC=PDDF0"

foreach ($User in $Users)

{

$Firstname = $User.SURNAME
$Surname = $User.FORENAMES
$Fullname = $Firstname + " " + $Surname
$Address = $User.ADDRESS
$PostalCode = $User.POSTCODE
$email = $User.EMAIL
$town = $user.TOWN
$username = $user.EMAIL
$fqdn = $Firstname +"@"+ $domain

try {

New-ADUser -Name $Fullname -SamAccountName $username -UserPrincipalName $fqdn `
-DisplayName $Fullname -GivenName $Firstname -Surname $Surname -StreetAddress $Address `
-City $town -PostalCode $PostalCode -EmailAddress $email `
-AccountPassword (ConvertTo-SecureString $password -AsPlainText -Force) -enabled $false `
-Path $OU

}
catch {

$ErrorMessage = $_.Exception.Message
$FailedItem = $_.Exception.ItemName
echo $ErrorMessage
echo $FailedItem

}


}