Using Powershell to set static passwords

I'm using the following to create bulk create mailbox enabled user accounts
from a CSV.

$Password = Read-Host “Enter Password� -AsSecureString

import-csv user1.csv | foreach {New-Mailbox -name $_.Name -sAMAccountName
$_.sAMAccountName -UserPrincipalName $_.UPN -database "EXC01\SCCCS\SCCCS
Database" -Password $Password -OrganizationalUnit "test.local/SCC"
-ResetPasswordOnNextLogon:$true }

At the moment, I have to manually type in the password before running the
import.

Is it possible to assign a static password without having to manually enter
it....so have the password set from within the CSV?

I'm trying to automate the whole thing but can't figure out how...

JC

I believe that method requires a secure string for the password. As long as you know the risks of hardcoding passwords, this might get you around using Read-Host

#create the plain text password string
$s="IAmASecureString"
#create a securestring object
$pwd=new-object system.security.securestring
#add the plain text string to the secure string
$s.toCharArray() | foreach {$pwd.AppendChar($_)}