Configuring Exchange mailboxes for a lot of users using powershell

Question

I need to configure mailbox settings for 1000 users. I created a .csv file that has all there userprinciplenames (name.surname@domain.com) When I do it one by one it all works, however the issue is when I try to reference a .csv file.

I would like to change their maxsendsize to 0mb and their (onlyacceptmessagesfrom@) should only be 3 people, everyone should not be able to send them emails. The file path is C:\Temp\users.csv

How do I properly reference the file that is all runs in a clean script?

Answer 1

Something like this should work:

Import-CSV C:\Temp\users.csv | % { Set-Mailbox $_.UserPrincipalName -MaxSendSize 0mb -AcceptMessagesOnlyFromSendersOrMembers @{add="user1","user2","user3"} -WhatIf}

where I'm making the assumption that the CSV file has the UserPrincipalName column to reference each user, and the set of objects to configure message restrictions is predefined (the same) for all users.

Make sure to run the sample with the -WhatIf switch, just in case.