Asked by:
Case Sensitive Email Resolution CRM 2011

Question
-
Hi All,
When an email comes into CRM, the sender is not resolved automatically when the sender's email address is partially capitalized.
For example: incoming email address => Aaa.Bbb@hotmail.com CRM record's email address => aaa.bbb@hotmail.com
Is there a way to ignore the case sensitivity when automatically resolving email addresses?
Thanks in Advance,
Lasa.
Thursday, October 16, 2014 2:39 AM
All replies
-
Hi Lasa,
I suspect you have case sensitivity enabled in your SQL Server (collation) Please check this article and see if this is true
http://stackoverflow.com/questions/1411161/sql-server-check-case-sensitivity
or http://msdn.microsoft.com/en-us/library/ms144250(v=sql.105).aspx
your fix would be to change collation in database.
Regards,
Jithesh.K
Thursday, October 16, 2014 3:00 AM -
Hi Jithesh,
Thanks for the reply. Good point but I do not think the email column in the database is case sensitive.
For example, both below queries return the same contact record.
select contactid, emailaddress1
from Contactbase
where emailaddress1 = 'Aaa.Bee@hotmail.com'select contactid, emailaddress1
from Contactbase
where emailaddress1 = 'aaa.bee@hotmail.com'Also the collation is Latin1_General_CI_AI and it is case insensitive.
Thanks,
Lasa.
Thursday, October 16, 2014 3:20 AM -
Hi Lasa,
Normally CRM email tracking is not case sensitive. please post a picture with and without tracking so that we can help.
Regards,
Jithesh
Thursday, October 16, 2014 4:29 AM -
Hi Jitesh,
Strange! I just did a test and the system is resolving my email address automatically regardless of the letter case.
I did a system wide search for the previously failed email address nd that it is only used in one contact record. So, not sure what happened there, hopefully it is a one off occurrence.
Thanks for your replies.
Lasa.
- Edited by lasajay Thursday, October 16, 2014 5:43 AM
Thursday, October 16, 2014 5:39 AM