Comparing email addresses in one database and a csv list

[jamesHP]

All our new enquiries are mean't to get added to our main contact database - their name, telephone number and email address - But over time some get missed and we have to compare the list of incoming email enquiries and our database by scrolling through all our emails - a years worth - and searching for each email address individually.

I have got a file with every email address that we have had an enquiry from. Is there any way of searching all the records in our database to see if any of them exist in one go? That way I can cross the ones off that exist pretty quickly and then add the rest.

Hope that makes sense!

Thanks

[fseipel]

You should be able to select File|Import Records|File... and then select updating matching records in found set. Check add remaining data as new records. For field mapping, set email field in database to match email in input file (= field mapping). Back up file before doing this. This will work particularly well if there aren't other fields or empty fields, incorrect fields, etc, in the email import file, that would over-write data for existing records.

In the latter case, defining a second table in existing solution might be preferred, then setting up a relationship between e-mail address in the two tables, and importing the file into 2nd table. You can then write a script to cycle through each record in second table of imported addresses, and add it if no related record exists in the first table, with rules.