Mailing Labels - Duplicate Addresses



I have created mailing labels using the wizard in Access 2000. If a mailing
address appears more than once in the database (this happens because a Head
Office / Company can have more than 1 branch and generally we just mail shot
the Head Office / Company) then a label is produced for each occurance. Is
there away to get Access to just produce one label per address easily?




Allen Browne

This is a matter of creating the relationships between the head office and
the branches, and then choosing the correct one to mail to. For an example,
People in households and companies

Though less desirable, it would be possible to create a query that selects
records based on just the address fields. In the Properties of the query in
query design, you can choose Unique Values only. Save the query. Then use a
DLookup() expression on the report to get the company name. You will need
some way to distinguish the head office from the branch office, so it picks
the head office where there is a duplicate. This is where it gets messy,
plus the fact that relying on the exact same address fields is not a great

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Duplicate Labels 4
Address Labels 3
Mailing labels 1
Mailing Labels 0
More Address labels 6
Help with Address labels 2
How omit Address line 2 in mailing labels? 5
Report and/or Mail Label 0