Office 365 Set language and time zone for all users with PowerShell (Manual)

When you create a new Office 365 tenant, all user mailboxes will have the default timezone and language. In my case, I work in the Netherlands, the preference for most companies is to set the Time zone to Central European Time (GMT +1) and the language of the users default folders to Dutch.

You can either ask the users to logon to webmail using https://outlook.office.com and fill in the first time question to set the time zone and default language. But how cool would it be to do this for all your users using PowerShell?

First time login screen Outlook Web Access

PowerShell script

Step 1: First we will need to connect to Exchange Online, so run the following script and login with an account with Exchange permissions

$Credential = Get-Credential
 $Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://outlook.office365.com/powershell-liveid/ -Credential $Credential -Authentication Basic -AllowRedirection
 Import-PSSession $Session

Step 2: Get the language code from the list below

Language codeDisplay Name
af-ZAAfrikaans – South Africa
sq-ALAlbanian – Albania
ar-DZArabic – Algeria
ar-BHArabic – Bahrain
ar-EGArabic – Egypt
ar-IQArabic – Iraq
ar-JOArabic – Jordan
ar-KWArabic – Kuwait
ar-LBArabic – Lebanon
ar-LYArabic – Libya
ar-MAArabic – Morocco
ar-OMArabic – Oman
ar-QAArabic – Qatar
ar-SAArabic – Saudi Arabia
ar-SYArabic – Syria
ar-TNArabic – Tunisia
ar-AEArabic – United Arab Emirates
ar-YEArabic – Yemen
hy-AMArmenian – Armenia
Cy-az-AZAzeri (Cyrillic) – Azerbaijan
Lt-az-AZAzeri (Latin) – Azerbaijan
eu-ESBasque – Basque
be-BYBelarusian – Belarus
bg-BGBulgarian – Bulgaria
ca-ESCatalan – Catalan
zh-CNChinese – China
zh-HKChinese – Hong Kong SAR
zh-MOChinese – Macau SAR
zh-SGChinese – Singapore
zh-TWChinese – Taiwan
zh-CHSChinese (Simplified)
zh-CHTChinese (Traditional)
hr-HRCroatian – Croatia
cs-CZCzech – Czech Republic
da-DKDanish – Denmark
div-MVDhivehi – Maldives
nl-BEDutch – Belgium
nl-NLDutch – The Netherlands
en-AUEnglish – Australia
en-BZEnglish – Belize
en-CAEnglish – Canada
en-CBEnglish – Caribbean
en-IEEnglish – Ireland
en-JMEnglish – Jamaica
en-NZEnglish – New Zealand
en-PHEnglish – Philippines
en-ZAEnglish – South Africa
en-TTEnglish – Trinidad and Tobago
en-GBEnglish – United Kingdom
en-USEnglish – United States
en-ZWEnglish – Zimbabwe
et-EEEstonian – Estonia
fo-FOFaroese – Faroe Islands
fa-IRFarsi – Iran
fi-FIFinnish – Finland
fr-BEFrench – Belgium
fr-CAFrench – Canada
fr-FRFrench – France
fr-LUFrench – Luxembourg
fr-MCFrench – Monaco
fr-CHFrench – Switzerland
gl-ESGalician – Galician
ka-GEGeorgian – Georgia
de-ATGerman – Austria
de-DEGerman – Germany
de-LIGerman – Liechtenstein
de-LUGerman – Luxembourg
de-CHGerman – Switzerland
el-GRGreek – Greece
gu-INGujarati – India
he-ILHebrew – Israel
hi-INHindi – India
hu-HUHungarian – Hungary
is-ISIcelandic – Iceland
id-IDIndonesian – Indonesia
it-ITItalian – Italy
it-CHItalian – Switzerland
ja-JPJapanese – Japan
kn-INKannada – India
kk-KZKazakh – Kazakhstan
kok-INKonkani – India
ko-KRKorean – Korea
ky-KZKyrgyz – Kazakhstan
lv-LVLatvian – Latvia
lt-LTLithuanian – Lithuania
mk-MKMacedonian (FYROM)
ms-BNMalay – Brunei
ms-MYMalay – Malaysia
mr-INMarathi – India
mn-MNMongolian – Mongolia
nb-NONorwegian (Bokmål) – Norway
nn-NONorwegian (Nynorsk) – Norway
pl-PLPolish – Poland
pt-BRPortuguese – Brazil
pt-PTPortuguese – Portugal
pa-INPunjabi – India
ro-RORomanian – Romania
ru-RURussian – Russia
sa-INSanskrit – India
Cy-sr-SPSerbian (Cyrillic) – Serbia
Lt-sr-SPSerbian (Latin) – Serbia
sk-SKSlovak – Slovakia
sl-SISlovenian – Slovenia
es-ARSpanish – Argentina
es-BOSpanish – Bolivia
es-CLSpanish – Chile
es-COSpanish – Colombia
es-CRSpanish – Costa Rica
es-DOSpanish – Dominican Republic
es-ECSpanish – Ecuador
es-SVSpanish – El Salvador
es-GTSpanish – Guatemala
es-HNSpanish – Honduras
es-MXSpanish – Mexico
es-NISpanish – Nicaragua
es-PASpanish – Panama
es-PYSpanish – Paraguay
es-PESpanish – Peru
es-PRSpanish – Puerto Rico
es-ESSpanish – Spain
es-UYSpanish – Uruguay
es-VESpanish – Venezuela
sw-KESwahili – Kenya
sv-FISwedish – Finland
sv-SESwedish – Sweden
syr-SYSyriac – Syria
ta-INTamil – India
tt-RUTatar – Russia
te-INTelugu – India
th-THThai – Thailand
tr-TRTurkish – Turkey
uk-UAUkrainian – Ukraine
ur-PKUrdu – Pakistan
Cy-uz-UZUzbek (Cyrillic) – Uzbekistan
Lt-uz-UZUzbek (Latin) – Uzbekistan
vi-VNVietnamese – Vietnam

Step 3: Now select your time zone from the list below:

Name of Time ZoneTime
Dateline Standard Time(GMT-12:00) International Date Line West
Samoa Standard Time(GMT-11:00) Midway Island, Samoa
Hawaiian Standard Time(GMT-10:00) Hawaii
Alaskan Standard Time(GMT-09:00) Alaska
Pacific Standard Time(GMT-08:00) Pacific Time (US and Canada); Tijuana
Mountain Standard Time(GMT-07:00) Mountain Time (US and Canada)
Mexico Standard Time 2(GMT-07:00) Chihuahua, La Paz, Mazatlan
U.S. Mountain Standard Time(GMT-07:00) Arizona
Central Standard Time(GMT-06:00) Central Time (US and Canada
Canada Central Standard Time(GMT-06:00) Saskatchewan
Mexico Standard Time(GMT-06:00) Guadalajara, Mexico City, Monterrey
Central America Standard Time(GMT-06:00) Central America
Eastern Standard Time(GMT-05:00) Eastern Time (US and Canada)
U.S. Eastern Standard Time(GMT-05:00) Indiana (East)
S.A. Pacific Standard Time(GMT-05:00) Bogota, Lima, Quito
Atlantic Standard Time(GMT-04:00) Atlantic Time (Canada)
S.A. Western Standard Time(GMT-04:00) Caracas, La Paz
Pacific S.A. Standard Time(GMT-04:00) Santiago
Newfoundland and Labrador Standard Time(GMT-03:30) Newfoundland and Labrador
E. South America Standard Time(GMT-03:00) Brasilia
S.A. Eastern Standard Time(GMT-03:00) Buenos Aires, Georgetown
Greenland Standard Time(GMT-03:00) Greenland
Mid-Atlantic Standard Time(GMT-02:00) Mid-Atlantic
Azores Standard Time(GMT-01:00) Azores
Cape Verde Standard Time(GMT-01:00) Cape Verde Islands
GMT Standard Time(GMT) Greenwich Mean Time: Dublin, Edinburgh, Lisbon, London
Greenwich Standard Time(GMT) Casablanca, Monrovia
Central Europe Standard Time(GMT+01:00) Belgrade, Bratislava, Budapest, Ljubljana, Prague
Central European Standard Time(GMT+01:00) Sarajevo, Skopje, Warsaw, Zagreb
Romance Standard Time(GMT+01:00) Brussels, Copenhagen, Madrid, Paris
W. Europe Standard Time(GMT+01:00) Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna
W. Central Africa Standard Time(GMT+01:00) West Central Africa
E. Europe Standard Time(GMT+02:00) Bucharest
Egypt Standard Time(GMT+02:00) Cairo
FLE Standard Time(GMT+02:00) Helsinki, Kiev, Riga, Sofia, Tallinn, Vilnius
GTB Standard Time(GMT+02:00) Athens, Istanbul, Minsk
Israel Standard Time(GMT+02:00) Jerusalem
South Africa Standard Time(GMT+02:00) Harare, Pretoria
Russian Standard Time(GMT+03:00) Moscow, St. Petersburg, Volgograd
Arab Standard Time(GMT+03:00) Kuwait, Riyadh
E. Africa Standard Time(GMT+03:00) Nairobi
Arabic Standard Time(GMT+03:00) Baghdad
Iran Standard Time(GMT+03:30) Tehran
Arabian Standard Time(GMT+04:00) Abu Dhabi, Muscat
Caucasus Standard Time(GMT+04:00) Baku, Tbilisi, Yerevan
Transitional Islamic State of Afghanistan Standard Time(GMT+04:30) Kabul
Ekaterinburg Standard Time(GMT+05:00) Ekaterinburg
West Asia Standard Time(GMT+05:00) Islamabad, Karachi, Tashkent
India Standard Time(GMT+05:30) Chennai, Kolkata, Mumbai, New Delhi
Nepal Standard Time(GMT+05:45) Kathmandu
Central Asia Standard Time(GMT+06:00) Astana, Dhaka
Sri Lanka Standard Time(GMT+06:00) Sri Jayawardenepura
N. Central Asia Standard Time(GMT+06:00) Almaty, Novosibirsk
Myanmar Standard Time(GMT+06:30) Yangon Rangoon
S.E. Asia Standard Time(GMT+07:00) Bangkok, Hanoi, Jakarta
North Asia Standard Time(GMT+07:00) Krasnoyarsk
China Standard Time(GMT+08:00) Beijing, Chongqing, Hong Kong SAR, Urumqi
Singapore Standard Time(GMT+08:00) Kuala Lumpur, Singapore
Taipei Standard Time(GMT+08:00) Taipei
W. Australia Standard Time(GMT+08:00) Perth
North Asia East Standard Time(GMT+08:00) Irkutsk, Ulaanbaatar
Korea Standard Time(GMT+09:00) Seoul
Tokyo Standard Time(GMT+09:00) Osaka, Sapporo, Tokyo
Yakutsk Standard Time(GMT+09:00) Yakutsk
A.U.S. Central Standard Time(GMT+09:30) Darwin
Cen. Australia Standard Time(GMT+09:30) Adelaide
A.U.S. Eastern Standard Time(GMT+10:00) Canberra, Melbourne, Sydney
E. Australia Standard Time(GMT+10:00) Brisbane
Tasmania Standard Time(GMT+10:00) Hobart
Vladivostok Standard Time(GMT+10:00) Vladivostok
West Pacific Standard Time(GMT+10:00) Guam, Port Moresby
Central Pacific Standard Time(GMT+11:00) Magadan, Solomon Islands, New Caledonia
Fiji Islands Standard Time(GMT+12:00) Fiji Islands, Kamchatka, Marshall Islands
New Zealand Standard Time(GMT+12:00) Auckland, Wellington
Tonga Standard Time(GMT+13:00) Nuku’alofa

Step 4: Now its time to run the final script. Make sure you change the values. In the example below I am using the Dutch Language and the Western European Time Zone.

Get-mailbox -ResultSize unlimited | Set-MailboxRegionalConfiguration -Language nl-nl -TimeZone "W. Europe Standard Time" -LocalizeDefaultFolderName

BONUS:

If you want to run the script on certain mailboxes only, you could create a CSV with one collumn: PrimarySmtpAddress

$user = import-csv c:\userlist.csv

foreach ($user in $user){
 
Set-MailboxRegionalConfiguration -Identity $user.PrimarySmtpAddress -LocalizeDefaultFolderName: $true -Language nl-NL -DateFormat dd-MM-yy
 
}

More information on this command can be found on Microsoft docs: https://docs.microsoft.com/en-us/powershell/module/exchange/client-access/set-mailboxregionalconfiguration?view=exchange-ps

One Comment

Add a Comment

Your email address will not be published. Required fields are marked *