Mautic Community Forums

two contacts in Mautic that have a same email address

Hello two contacts in Mautic that have a same email address when i import from csv doesn’t recognize if a contact has same email ! Please Help me

Hi,

Are you on the latest version of Mautic? On my instance, it automatically merges contacts if it finds there’s a duplicate on it.

I am not sure about Mautic’s method on handling duplicate emails but my best workaround for you is that if you have a large list of emails already in Mautic, and you want to avoid putting duplicate emails you should :

  1. Download all those emails from Mautic
  2. Put it in Microsoft Excel and put the new emails in the same column. Seperate by a unique text like [Separator]
  3. Deduplicate it using Excel function “Deduplicate”
    OR
  4. You can also use VLOOKUP in Excel to wash against the existing emails. Then you’ll get only the unique ones that doesn’t exist in your database.

Anyway, that’s the best alternative I have ever since I have started working. I am sorry I can’t give a solution or suggestion within Mautic itself.

3 Likes