July 25, 200619 yr 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?
July 25, 200619 yr Author huh! the more you know i guess... this seems like something i could use, thanks!
July 25, 200619 yr Author 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...
Create an account or sign in to comment