how to remove recipients from mailing list??

[WATERLILY1213]

Hoping to find some help, please.

My Real Estate office generates frequent "mass mailings" to our area's homeowners, hoping to have someone list their property for sale with us, HOWEVER, there are some residents who have no intention of selling and who have called our office and demanded that they be REMOVED from our mailing list. This has resulted in me having to keep a hand-written sheet of DO NOT CONTACT names, so each month when I download the most recent database I have to go through the THOUSANDS of names and physically delete the DO NOT CONTACT persons. Is there any way to create a table of DO NOT CONTACT names, update it as needed, and through some query, utilize it on each of my most recent database downloads to delete those person's names that do not want to receive mail from us?

Thank you in advance for any advice you can provide.

Regards,
Waterlily1213

 

[Pat Hartman]

Keep a table of the Do Not Contact people. When you refresh your mailing list, run a query that joins to the Do Not Contact table on all the name and address fields or just the address fields and updates the mailing list table Do Not Mail flag. Or you can make this a delete query instead and delete the records from the mailing list. If you leave the records there, flagged, you need to modify your selection queries to ignore the Do Not Contact people.

 

[WATERLILY1213]

Thank you!

Phil, I appreciate your reply to my post, and will surely give it a try in the near future

 

[Pat Hartman]

Phil?

 

[WATERLILY1213]

PLEASE EXCUSE ME!

Oh, Pat

I do apologize for replying to you with my sister's name! I was on my cell with Phyllis aka PHIL while I was replying to your post DUH!! Guess I don't multi-task very well...........PLEASE ACCEPT MY APOLOGY and again, thanks for your help............

 

[Mile-O]

lol

Don't worry Pat, people still call me Mike for some reason. I know how it feels.

 

[Rich]

They might just have bad eyesight Milk

 

[Pat Hartman]

No problem My mother had trouble with names also. For years my youngest brother thought his name was Pa-Ar-Keith. I was the eldest so she usually got my name right