Issue scripting:
Import-CSV address BulkuserMailboxes.csv | ForEach {New-Mailbox -Alias
$ .alias -Name $.name -userPrincipalName $.UPN -Database “Mailbox Database 2091411052” -OrganizationalUnit Users -Password $Password}
csv text:
Alias Name UPN
Bulkuser_1 Bulkuser1 bulkuser1@extraining.com
Bulkuser_2 Bulkuser2 bulkuser2@extraining.com
errorr:
Without knowing what problem you're having it's impossible to tell you how to fix it!
I don't see where you assign a value to the variable $password. Could that be the problem? Or maybe that the CSV doesn't use a comma as the separator character?
Also, when you post code, please use the "Code Sample" editor. It's the 5th icon from the left on the Format Bar (it has the graphic "101 010"). The normal editor mangles the code.
This screenshot is not visible.
So, I provide a script which could work in my lab:
CSV file:
Script:
$users = Import-CSV c:\temp\users.csv
$PassWord = ConvertTo-SecureString -String "Password123" -AsPlainText -Force
ForEach($user in $users){
New-Mailbox -Alias $user.alias -Name $user.name -userPrincipalName $user.UPN -Database "DB16" -OrganizationalUnit Users -Password $Password -ResetPasswordOnNextLogon $true
}
Run this script(.PS1 file) in EMS:
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
thank you guys, for some strange reason , excel worked notepad did not. Was prop the PS mode
25 people are following this question.
