This is a somewhat involved mail merge question. I'm printing out address labels for Christmas cards, and I'd like to address different families of different sizes personally. The easy way out, which I'm tempted to do at the moment, is "The <<last name>> family," as in "The Peterson family." But I'm addressing cards to families of all different sizes:
- single people
- single people with kids
- married people without kids
- married people with kids
Single people are easy. Married people without kids are easy too, once I figured out the "if ... then" trick. Where it gets tricky is that some of my married friends kept their maiden names. Right now when I use the "if ... then" trick with maiden names, it's trying to print out "Tim and Jenny Smith Peterson," as opposed to what I want: "Tim Peterson and Jenny Smith."
And then how about kids' names? Is this even possible? MS Word doesn't seem to recognize this field - can I create it? I'd love to have the first line read "Tim, Jenny, Tommy, and Charlie Peterson." Assuming I can get it to recognize the "child" field, how do I work it with the commas and the last "and?" It seems like this would be involved, but possible.
I'd appreciate any help you all could give me on this matter. I'm a mail merge rookie, though, so the more dumbed-down the explanation, the better.