Author Archives: NesiSamurai

(below details are copy-pasted from Microsoft forum)

POST 1:

Some of our users’ outlook stop sync with exchange and ask for password, as shown in below image:

But when we press the “Need Password” button, nothing happens. there is no prompt.

to fix the issue, I clear entries in Credential Manager, Delete Temporary Files, unchecked “Use Cached Exchange mode”, restart system and check this again.

POST 2: (Confirmed accepted answer)

There are a number of reasons for this. First I would look inside the Office 365 admin portal to make sure your password expiration policy is not set to only a few days

If this is ok, setting the below registry key to 1 in below path often resolves it

Path: HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Common\Identity
Key: DisableADALatopWAMOverride (DWORD)

This key may not exist, we need to create it.

The following VBA code can help you quickly split multiple worksheets of current workbook to separate Excel files, please do as follows:

1. Create a new folder for the workbook that you want to split, because the split Excel files will be stayed at the same folder as this master workbook.

2. Hold down the ALT + F11 keys in Excel, and it opens the Microsoft Visual Basic for Applications window.

3. Click Insert > Module, and paste the following code in the Module Window.

VBA: Split a workbook into multiple workbooks and save in the same folder

Sub Splitbook()
'Updateby20140612
Dim xPath As String
xPath = Application.ActiveWorkbook.Path
Application.ScreenUpdating = False
Application.DisplayAlerts = False
For Each xWs In ThisWorkbook.Sheets
    xWs.Copy
    Application.ActiveWorkbook.SaveAs Filename:=xPath & "\" & xWs.Name & ".xlsx"
    Application.ActiveWorkbook.Close False
Next
Application.DisplayAlerts = True
Application.ScreenUpdating = True
End Sub

4. Click F5 to run the code

(Above info is copied from here >> external link)

Step 1: Select the cells where you want the pop-up then from menu Data> validation

Step 2: select date from validation criteria and click save

OK now when you click the selected cell from step 1 you will get a pop-up calender.

The following steps will add a new alias to given emails. It will not make the new alias as primary.

1. Open a persistant session to the exchange.
   $Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://outlook.office365.com/powershell-liveid/ -Credential $UserCredential -Authentication Basic -AllowRedirection

02.Import the session to your powershell:
Import-PSSession $Session

03.Login to Microsoft 365 admin account
Connect-Msolservice

4. Download Global address list.
   get-user -resultsize unlimited |select * |export-csv c:\M365\users.csv
5. Delete all columns except “Identity”.
6. Add a new column named “Alias”.
7. After updating the sheet run the following script.

$Recipients = Import-Csv C:\M365\users.csv
Foreach ($Item in $Recipients)
{
Set-Mailbox -Identity $Item.Identity -EmailAddresses @{Add=$Item.Alias}
}

(This note is based on what I did today. I have very little understanding of powershell, if you are going to try these steps please do your research first.)