Before me sits 1,555 returned brochures (that is, they were undeliverable via postal mail ... yuck!) and the daunting task of going through this pile of loveliness and designating these folks in Tessitura with the appropriate mail restriction for each corresponding record.
Luckily, each brochure has the constituent ID number above the address, so I've made quick work of keying a spreadsheet in with all the appropriate IDs. I've also used List Manager and Extraction Manager to weed through folks that shouldn't have been mailed to begin with (this has been a data disaster--around 460 constituents that were Inactive or already had a Mail Restriction somehow ended up on the list ... Luckily for me, I'm not the responsible party--i.e--not my list, though I get the pleasure of cleaning up after it), and before I set to manually updating each remaining individual record, I wonder if there was a significantly smarter/easier way to do this.
I have a limited working knowledge of (and, more dangerously, full access to) SQL (I use it SO infrequently that I spent more time reacquainting myself with it than actually performing the task at hand), but I'm not afraid to dive into my test server to try (break) a few things if that's what it takes. I'm not averse to staying within Tessitura if there's an easy route there as well ... I've already imported my spreadsheet via List Manager (which of course ferrets out the Inactives off the bat), any thoughts on this are MUCH APPRECIATED!
You all rock! I've been pulled away from this for a few days due to some illnesses around the office (we all wear so many hats, don't we?), but really appreciate your responses. This has made life SOOOO much easier in this regard, I'm definitely keeping this all in the cache!
THANK YOU!!