Avoid Duplicate Mailing labels

[Guest]

Hello,
I've designed a mailing label to contact parents. My database contains a
main table with the information on the church members. A second table
contains child information. I'd like to mail to households with children
satisfying certain criteria.

My label report is currently set up to produce a multiple labels for
households with more than one child. How can I modify this so that no
household gets more than one mailing.

Thanks in advance,

Ellen

 

[Guest]

Ellen,

This is an easy one ....... I think...

I assume your report is based on a query that currently has the names of the
Children. Hopefully your table has a separate field for last and first
names. Remove the first name field and group on the other fields. I assume
every other field should be the same.

Also, you can customize how the last name appears on the label. For example
assuming your last name column is called lname:

In the text box on the label, enter the following:

="The "&lname&" Family"

Or something similar..

HTH

Greg

 

[Guest]

Thanks for your quick reply, Greg! The grouping thing seems to have worked.
I even added some bogus data placing another family living at the same
residence and two lables were made for them as I'd like.

The only drawback is that it seems to have messed up the label lineup. I'm
not sure if all the labels would be printed. With the three households that
I'm using for testing, it looks like the first label is skipped. That's no
big deal, better than duplicate mailings.