Summary:

The following message may be displayed when attempting to add a recipient to an email from a user picker:

Too many records

The message will normally appear when you have a large number of active users (50+).

The search function operates as expected, however displaying the full list of user records will not be posisble, as the default limit is 50.

Resolution:

The following SQL can be run to allow the display of a greater number of users:

UPDATE Custom_SysParams SET Parm_Value = '100' WHERE Parm_Name = N'DropdownThreshold';

Please ensure that relevant backups have been taken prior to performing changes on a live database. 

Once completed, a metadata refresh must be performed via Administration -> System -> Metadata -> Refresh All -> Execute Refresh.

If using a Cloud instance of CRM, a request to alter this parameter can be made via the Sage support desk.