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!
Do you do your mail restrictions as an attribute or on the general tab? If you use attributes you could run the Manage Attributes report against the list and do it that way. If not try something like
update c
set mail_ind=<whatever the id is for the restriction you need, get this from tr_mail_ind>
from t_customer c
inner join t_list_contents l on l.customer_no=c.customer_no
where list_no=<that list you created>