Is there a way to view, create or export a list of contacts that have more than one email address assigned to them?
I've discovered that some of our contacts have more than one address associated to them, perhaps due to an improperly imported list or a problem with a form. For instance, if I view contact John Doe's contact page, it shows him with emails john@gmail.com,john@hotmail.com and jane@yahoo.com.
However, when viewing a list of contacts, only the first email is being shown. I need to find out which contacts have more than one email assigned to them so that I can fix these erroneous entries. For instance, in the above example, jane@yahoo.com is supposed to be a separate person, and I'm not sure how they got merged. With a contact database of over 7,000 it would be very time-consuming to go through each contact separately.
Appologize for not knowing if this functionality is tied to a specific HubSpot product or tier (don't think it is) or remembering when it was released (very recently), but when exporting contacts from a VIEW you may now select "Export all emails for selected contacts" -- see images below.
Export all emails for selected contacts
Export all email addresses for selected contacts -- RESULTS
Enjoy!
Note: Please search for recent posts as HubSpot evolves to be the #1 CRM platform of choice world-wide.
The above shows that there is a total of 157 contacts with multiple emails. The "paging" part shows that this is the first page, and the second page is "after 100".
Appologize for not knowing if this functionality is tied to a specific HubSpot product or tier (don't think it is) or remembering when it was released (very recently), but when exporting contacts from a VIEW you may now select "Export all emails for selected contacts" -- see images below.
Export all emails for selected contacts
Export all email addresses for selected contacts -- RESULTS
Enjoy!
Note: Please search for recent posts as HubSpot evolves to be the #1 CRM platform of choice world-wide.
Oct 26, 20228:43 AM - edited Oct 26, 20228:43 AM
Contributor
Finding contacts that have multiple emails
SOLVE
This helped me find which contacts that had more than 2 emailadresses and caused our integration to fail. Thanks! Not a solution to the problem (Hubspot should allow to build list to check number of emails), but a good workaround.
Currently, this is not a functionality of the tool. If you would like to see this implemented in the future, I would recommend sharing this idea inour ideas forum.
Take care!
Jess
Wusstest du, dass es auch eine DACH-Community gibt? Nimm an regionalen Unterhaltungen teil, in dem du deine Spracheinstellungen änderst !
Did you know that the Community is available in other languages? Join regional conversations by changing your language settings !