The short: I'm looking for a solution that will allow me to flag mail messages based on the from: field by matching them with addresses in a text file (NOT address book)
The long: I'm a college coach. I'm inundated with hundreds of emails a week from potential recruits. The vast majority of these aren't legit, but those that are are very important that I reply to asap. I'm trying to find a solution where I can whitelist a certain set of email addresses so that they are highlighted in my mailbox so that I can respond to them quickly. While this can be accomplished easily enough using mail rules and whether they are located in my address book, I would need to add hundreds of contacts to my address book - contacts that serve no purpose other than being "whitelisted".
An alternate solution would be to add them individually under a rule in mac mail (and this may be the route I go). While this would save me from having too many cards in address book, it still is a bit time consuming to add them - and I would prefer to have them stored in a text or some other easily accessed file (I have experience building FileMaker databases, so part of the process that I haven't detailed here would be to create this whitelist text file through FM as part of a larger process).
I've wasted today looking through spam filters, mail add-ons, AppleScripts and Automator task, to no avail. I'm thinking an AppleScript would be the most likely answer, but I've had no luck in my searches (everything returns how to trigger an AppleScript in rules, not how to make an AppleScript rule). Any help pointing me in the right direction or thinking outside the box would be greatly appreciated.
The long: I'm a college coach. I'm inundated with hundreds of emails a week from potential recruits. The vast majority of these aren't legit, but those that are are very important that I reply to asap. I'm trying to find a solution where I can whitelist a certain set of email addresses so that they are highlighted in my mailbox so that I can respond to them quickly. While this can be accomplished easily enough using mail rules and whether they are located in my address book, I would need to add hundreds of contacts to my address book - contacts that serve no purpose other than being "whitelisted".
An alternate solution would be to add them individually under a rule in mac mail (and this may be the route I go). While this would save me from having too many cards in address book, it still is a bit time consuming to add them - and I would prefer to have them stored in a text or some other easily accessed file (I have experience building FileMaker databases, so part of the process that I haven't detailed here would be to create this whitelist text file through FM as part of a larger process).
I've wasted today looking through spam filters, mail add-ons, AppleScripts and Automator task, to no avail. I'm thinking an AppleScript would be the most likely answer, but I've had no luck in my searches (everything returns how to trigger an AppleScript in rules, not how to make an AppleScript rule). Any help pointing me in the right direction or thinking outside the box would be greatly appreciated.