I am setting up an address database in Excel 2003 that I need to be able to
use to make labels for mailings. I have people that are in different
"categories" and will want to group them by that category, depending on who I
am sending the mailing to. For instance, I have a person, Person A, who is a
general supporter, lives in the area, and sponsors a child. Person A is in
three of the possible 5 categories. Another person, Person B, might be
simply a general supporter (i.e., in one category). How can I best organize
the data - and the headings - so that I can make labels for just the general
supporters, for instance, or for the sponsors? Do I have to enter each
person's data once for each category they fit under with a column, "Type,"
with a code in that cell for the specific category? So - Person A would have
3 rows, all the same, except for the Type Code? Or can I put 3 or more "Type
Codes" under the category "Type," separated by commas or something, and then
organize them somehow when it comes to printing them out? And then...is
there a way to prevent from printing out that "Type" and "Type Code" when it
comes to printing the labels? I understand how to choose the fields I want
in the label, so maybe it's that simple for that part. I actually wanted to
only use Outlook for this - so I would only have to enter it in one place -
but I was never able to get the labels to print properly so I have to do it
this way, for now. Frustrating! Thank you so much for your help. --Jan