Set Language and Time Zone for OWA in Office 365

Similar to the article I wrote to Set Language and Time Zone for OWA in Exchange 2013, the application of the time zone settings in Office 365 is slightly different in that they cannot be set by database–very effectively. Therefore, in this article we will focus on applying these settings in bulk using a CSV file.

Additionally, we will assume all users are in US-based locations.

Valid time zone formats for the 50 United States are…

  • ‘Alaskan Standard Time’ … Alaska
  • ‘Central Standard Time’ … Central Time (US & Canada)
  • ‘Eastern Standard Time’ … Eastern Time (US & Canada)
  • ‘Hawaiian Standard Time’ … Hawaii
  • ‘Mountain Standard Time’ … Mountain Time (US & Canada)
  • ‘Pacific Standard Time’ … Pacific Time (US & Canada)
  • ‘US Eastern Standard Time’ … Indiana (East)
  • ‘US Mountain Standard Time’ … Arizona

 

In the event that a company is localized in one region or time zone, we will use a command similar to the following to set all users in Office 365 (with a mailbox) for a company in the Central time zone and set the language to English (US).

Get-Mailbox | Set-MailboxRegionalConfiguration -Language en-US -TimeZone "Central Standard Time"

 

In the event that a company is geographically dispersed, let’s use a CSV (MyUsersTimeZone.csv) file to set users in bulk. The CSV should look similar to the following…

MyUser,MyTimeZone,MyLanguage
User1,Eastern Standard Time,en-US
User2,Central Standard Time,en-US
User3,US Eastern Standard Time,en-US
User4,Mountain Standard Time,en-US

 

Once the CSV file is created, we will use this command to set the time zone and language for each user mailbox specified in the file.

Import-Csv C:\Scripts\MyUsersTimeZone.csv | ForEach-Object { Set-MailboxRegionalConfiguration -Identity $_.MyUser -TimeZone $_.MyTimeZone -Language $_.MyLanguage }

 

Good luck and have fun!

 

My Related Articles

Reference(s):

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s