How to delete mailing to people with JT/RS, LC, & in the field

[Raquel666]

Hi, I have a query with over 4000 mailing names. I'd like only to see single people and no corporations. What would I use to delete any name with "JT/RS, LC, &" in the "Mail 1" field?



I tried Not=JT/RS and that didn't work.

Thanks!

[pbaldy]

If I understand correctly, this type of thing:

Not Like "*JT/RS*" AND Not Like "*LC*"

[Raquel666]

Wow, great, thanks!

[pbaldy]

Happy to help, and welcome to the site by the way!