Screening bad mail

[Saucepan]

ive got an import table in my database that imports the emailadresses and subjects from my regular email program. now i want to check and screen some mails that i really dont need to add to my database. lets say i dont want any mails containing the word "free" in the adressfield, i just want the database to automaticly delete that record. ive got one table with all the words i want to screen for, another with the unedited mails which i import into, and lastly a table into which im going to stick the edited mails.

the problem in having is that i cant figure out how to search for the unwanted words in a smart way. what i want to do is something like:

If[email::email ; Contains "free"; delete; store]

make any sence?

[Inky Phil]

Look up the'PatternCount()' function in your help files

[Saucepan]

huh!

the more you know i guess... this seems like something i could use, thanks!

[Saucepan]

kinda related followup...

when im importing the mails i do that from a big excel file. is there anyway to use the same method to check (and screen) for duplicates there? i dont want to import the same mail twice...