Changing number of folders shown for Exchange Online account

When a user imports email messages from their Exchange Online account, the Email folder field in the Sage CRM UI shows 250 folders maximum by default.

You can increase this limit as follows: 

  1. Connect SQL Server Management Studio to the Sage CRM database and run the following query:

    Copy 
    update custom_sysparams set parm_value = '{number of folders}' where parm_name = N'ImportedEmailFoldersRetrievalSize'

    Replace {number of folders} with the actual maximum number of folders you want the Email folder field to display.

  2. In Sage CRM, go to My profile | Administration | System | Metadata.

  3. Select Refresh system parameters, and then select Execute Refresh.

You can use these steps to decrease the maximum number of folders displayed in the UI. Note that the minimum value you can set is 250.