Create emailadresses for webmail

nvtnvt9030 · 2021-04-15T15:59:14.000Z

We want to create about 100 emailaddresses in our domain so these 100 users can login to the webmail. They do not have domain computers so don’t need domain access but do need an emailadress for webmail.

No i do have 2 options:

make a csv file with titles in the csv which are the same as in the get-aduser list. (firstname and lastname is not important, only the displayname.)

then importing the csv and the command to maken the fields for the adusers, but i do not know how also make an emailaccount in Exchange which they need for webmail login.

OR

new-mailbox

Something Like this:

$bulk = Import-CSV test.csv
foreach ($_ in $bulk)
{
$name=$.name
$alias=$.alias
$upn=$.UserPrincipalName
$db=$.Database
$ou=$.organizationalunit
$encryptedpass = convertto-securestring $.password -asplaintext -force
$resetpass = $false
new-mailbox -Name $name -Alias $alias -UserPrincipalName $upn -Database $db -OrganizationalUnit $ou -Password $encryptedpass
Set-User $.alias -Title $.designation
}

Both option i have never done before so it is a try out.

Neally · 2021-04-15T18:24:52.000Z

If you post code, please use the ‘Insert Code’ button. Please and thank you!

PLEASE READ BEFORE POSTING! Read if you're new to the PowerShell forum! Programming & Development

Hi, and welcome to the PowerShell forum! Don’t apologize for being a “noob” or “newbie” or “n00b.” There’s just no need – nobody will think you’re stupid, and the forums are all about asking questions. Just ask! Use a descriptive subject. Don’t say “Need help” or “PowerShell Help”, actually summarize what the problem is. It helps the rest of us keep track of which problem is which. Don’t post massive scripts. We’re all volunteers and we don’t have time to read all that, nor will we copy…

Neally · 2021-04-15T18:38:39.000Z

Is that an on-prem exchange server or exchange online?

when you create a mailbox it automagically creates the AD user.

so first create the mailbox, when set the values you want for the AD User.

new-mailbox #stuff
set-aduser #stuff

nvtnvt9030 · 2021-04-16T04:43:22.000Z

Ok thx, that is good point.

I must dive in to the

set-aduser

so with set-adusers i can edit (fter creation of the mailbox+account) all the properties for an account?

set-adusers

Neally · 2021-04-16T04:55:11.000Z

Pretty much, yeah, anything AD related

nvtnvt9030 · 2021-04-17T15:44:15.000Z

I have made a excel file with the headers and save it as a comma seperated csv.

Then tried several things in powershell to import the csv, first tried several things to make new-mailboxes and second tried to make the accounts with new-aduser both things fail. The first with the error cannot bind with the argument name is null. I cannot figure out wat the error means and what is wrond with both methods. Searching online it succeeds with the most that do this but not with me…

the code for the new-aduser:

error: cannot validate argument on parameter ‘name’ the argument is 0 or empty.

import-csv C:\scripts\input\test.csv | % {New-ADUser -Name $_.displayname -SamAccountName $_.SamAccountName -DisplayName $_.displayname -Surname $_.Sn -GivenName $_.GivenName -AccountPassword (ConvertTo-SecureString Password1234 -AsPlainText -Force) -Enabled:$true -Title $_.Title -Description $_.description  -ChangePasswordAtLogon:$false} | % {Enable-Mailbox -Identity $_.SamAccountName -Alias $_.SamAccountName}

this is for adding mailboxes with ad accounts. Run it on the Exchange 2013 server in Management PowerShell:

csv is filled with headers like this and beneath the headers:

Name,alias,userprincipalname,organizationalunit,database,password

test12 test,testa,test@domain.nl,CEO,Board,database1,Test123!

$bulk = Import-CSV c:\scripts\input\test.csv
foreach ($_ in $bulk)
{
$name=$_.name
$alias=$_.alias
$upn=$_.UserPrincipalName
$db=$_.Database
$ou=$_.organizationalunit
$encryptedpass = convertto-securestring $_.password -asplaintext -force
$resetpass = $false

new-mailbox -Name $name -Alias $alias -UserPrincipalName $upn -Database $db -OrganizationalUnit $ou -Password $encryptedpass
Set-User $_.alias -Title $_.alias
}

Can someone help me out here, adding accounts with email in Exchange 2013 from csv is used many times, what is wrong?

Powershell version 5 (WIndows 10 machine and also run on Exchange 2013 management shell

Neally · 2021-04-17T16:30:06.000Z

nvt7393:

I cannot figure out wat the error means and what is wrond with both methods. Searching online it succeeds with the most that do this but not with me…

the code for the new-aduser:

error: cannot validate argument on parameter ‘name’ the argument is 0 or empty.

make sure your CSV is a VALID format.

"Name","alias","userprincipalname","organizationalunit","database","password"

"test12 test","testa","test@domain.nl","CEO","Board","database1","Test123!"

That space might be an issue. There can not be space or blank values in the CSV

Neally · 2021-04-17T16:44:49.000Z

Why are you trying to create the AD user and the mailbox separately?

Creating the mailbox does create the user.

nvt7393:

adding accounts with email in Exchange 2013 from csv is used many times, what is wrong?

do you get an error?

nvtnvt9030 · 2021-04-18T05:28:47.000Z

where do you see the space?

In Excel i fill in the headers and beneath the data, then export to csv comma seperated, how to avoid spaces?

nvtnvt9030 · 2021-04-18T05:40:46.000Z

Neally,

I do not do both, but trying both. First one is creaating the mailboxes but that failes with the errors (when executing the .ps1):

convertTo-Securestring: cannot bind argument to parameter string because it is null (password field is filled in though in the csv)

cannot bind argument to parameter Name because it is an empty string

parametrebinding validation exception

Cannot bind argument to parameter identity bacause it is null

:

Neally · 2021-04-18T06:36:05.000Z

nvt7393:

convertTo-Securestring: cannot bind argument to parameter string because it is null (password field is filled in though in the csv)

cannot bind argument to parameter Name because it is an empty string

Powershell is pretty good with errors, even though you think all is good, it is telling you there is SOMETHING wrong with it.

nvtnvt9030 · 2021-04-18T06:38:38.000Z

But what to do with is, what is wrong with the commands or csv?

Neally · 2021-04-18T06:39:04.000Z

nvt7393:

where do you see the space?

In Excel i fill in the headers and beneath the data, then export to csv comma seperated, how to avoid spaces?

$csv = 
@"
Name,alias,userprincipalname,organizationalunit,database,password
test12 test,testa,test@domain.nl,CEO,Board,database1,Test123!
"@ | convertfrom-csv
$csv

Name               : test12 test
alias              : testa
userprincipalname  : test@domain.nl
organizationalunit : CEO
database           : Board
password           : database1

i assume the password is not supposed to be ‘database1’ ?

You have 6 columns, but 7 values.

Neally · 2021-04-18T06:40:17.000Z

i don’t have exchange to test, but maybe try like so

$csv = 
@"
Name,alias,userprincipalname,organizationalunit,database,password
test12 test,testa,test@domain.nl,CEO,database1,Test123!
"@ | convertfrom-csv
$csv

foreach ($row in $csv) {
    $newMailbox = @{
        Name               = $row.name 
        Alias              = $row.alias 
        UserPrincipalName  = $row.userprincipalname 
        Database           = $row.database 
        OrganizationalUnit = $row.organizationalunit 
        Password           = convertto-securestring $row.password -asplaintext -force
    }
    try {
        new-mailbox @newMailbox -erroraction stop
        Set-ADUser -identity $row.alias -Title $row.organizationalunit
    }
    catch {
        $error[0].exception.message
    }
}

nvtnvt9030 · 2021-04-18T07:32:40.000Z

It is atypo, in real there are 6 rows…

nvtnvt9030 · 2021-04-18T07:33:36.000Z

What do you mean with this,

$csv = 
@"
Name,alias,userprincipalname,organizationalunit,database,password
test12 test,testa,test@domain.nl,CEO,database1,Test123!
"@ | convertfrom-csv
$csv

foreach ($row in $csv) {
    $newMailbox = @{
        Name               = $row.name 
        Alias              = $row.alias 
        UserPrincipalName  = $row.userprincipalname 
        Database           = $row.database 
        OrganizationalUnit = $row.organizationalunit 
        Password           = convertto-securestring $row.password -asplaintext -force
    }
    try {
        new-mailbox @newMailbox -erroraction stop
        Set-ADUser -identity $row.alias -Title $row.organizationalunit
    }
    catch {
        $error[0].exception.message
    }
}

not make use of the csv file?

Neally · 2021-04-18T07:34:30.000Z

nvt7393:

What do you mean with this, not make use of the csv file?

typos are an issues

I have no idea what you mean.

nvtnvt9030 · 2021-04-18T07:49:54.000Z

I have run this and looks like it is doiing something. I saw that i used a database on a Exchange 2010 server, so changed the database and the password because it was not meeting the requerements.

It shows me a screen after running but at the end the message is:

"cannot find an object with the identitiy ‘testa’ under doman.local.

It is not red colored so this is not an error?

Why is this running but not when the csv is filled, i must change the database though to test if that is also working now and whaat does the last message mean?

I has created the account though test12test as displayname.

Neally · 2021-04-18T07:53:33.000Z

nvt7393:

Why is this running but not when the csv is filled

Since this is ‘manually’ creating the CSV, my best guess is that there is something wrong with your CSV file.

nvt7393:

"cannot find an object with the identitiy ‘testa’ under doman.local.

I assume that might come from ‘set-aduser’ ?
Check if

the mailbox was created
if the AD user was created
what the samaccount name is, if it was created

Neally · 2021-04-18T07:57:42.000Z

nvt7393:

It is not red colored so this is not an error?

just because it is red does not mean it is an error, same thing reverse, just because it is NOT read does not mean it is not an error.

don’t worry about the color but the message, it says there is no object with that identity found, so check if it exists or not, or possibly with a different name.

we have no access to your system, we do not see what you see, so we only know what you tell us. and it seems things are changing and you are changing things without telling us, so we have no clue, we can’t read minds.