Multiple searches from a spreadsheet?
I have the task of cleaning a database in FMP 10. The data to be cleaned is invalid email addresses which are in a spreadsheet. (bounces from a mailing)
Is there a way of finding over 900 different contacts using first name, last name or email address without having to search for each one individually.
Currently I am searching for each one and putting a common identifier in the notes field so they can all be found later in a single search.
Thanks, in anticipation.