Finding hundreds of email addresses
I have a list in an Excel spreadsheet of about 300 email addresses, each of which are also in some record in my 2,000 record FM database. These are the addresses of people to whom we cannot e-mail. There is a field in the db called "OK to Email" and I need to find the records for all those addresses and change each one to "No" in the OK to email field.
I can't figure out how to do this besides doing a separate find on each and every one of those email addresses, and then changing the other field manually. I figured if I could manage to pull out all 300 records as a found set, then I could change the OK to Email field globally. But I can't find any way to do that. Any advice would be appreciated!