locked
Case Sensitive Email Resolution CRM 2011 RRS feed

  • 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