We use NPSP, currently there are 3 emails fields, Personal Email, Work Email, Alternate Email. When creating matching rules, we need to create matching rule for each email field separately. Ideally, when importing Contacts, Salesforce should be able to match the email in the import file across all the fields. I can create an apex trigger to block duplicate record creation based on email addresses across all the 3 fields. But I think this is an unnecessary thing to do. This can be easily done if Salesforce allows multiple fields from the Contact object to be mapped in the matching rule. Currently Salesforce allows the same object only once in a matching rule.
If anyone experienced the same issue and if could add a comment to let me know how you have resolved the issue, that would be great.
