Create a text file :Users.txt

FirstName,LastName,Password,DN,OU,Office,Organization,DG,Title,Phone
Ben,Lankowski,Vista2006,Adatum.com,TestOU,Room601,vanarts,GG27,Student,6046822787
Greg,Werner,Vista2006,Adatum.com,TestOU,Room601,vanarts,GG27,Student,6048994567
Angela,Cheng,Vista2006,Adatum.com,Testou,Room602,vanarts,GG28,Student,6053458900
Emily,Merl,Vista2006,Adatum.com,TestOU,Room602,vanarts,GG28,Student,7789008998

Create a script: userimport.ps1

##Assuming the mail-enabled distribution group GG27 and GG28 are created
##Assuming the Active Directory Organizational Unit:TestOU is created.

$Data=import-csv $args[0]
$currentdate="created on "+ (get-date)

foreach ($i in $data)
{
$PW=ConvertTo-SecureString $i.Password -AsPlaintext -Force
$UPN=$i.FirstName+"."+$i.Lastname+"@"+$i.DN
$FullName=$i.LastName+","+$i.FirstName
$Alias=$i.Lastname+$i.FirstName
$DisplayName=$i.Lastname+" "+$i.FirstName
$FirstName=$i.firstName
$Lastname=$i.Lastname
$OU=$i.OU

New-Mailbox -UserPrincipalName $UPN -Alias $alias -Name $FullName -OrganizationalUnit $OU -Password $PW -FirstName $FirstName -LastName $Lastname -DisplayName $DisplayName


Add-distributiongroupMember -Identity $i.DG -Member $UPN
Set-User -Identity $UPN -Office $i.Office -Company $i.Organization -Phone $i.Phone -Title $i.Title -Notes $currentDate
}

Run the script in EMS: