If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? Thanks -- BeeJay |
#2
|
|||
|
|||
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, see: People in households and companies at: http://allenbrowne.com/AppHuman.html 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 approach. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "BeeJay" wrote in message ... 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? Thanks -- BeeJay |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Is there a full page template for Avery 8160 mailing labels? | Le B | General Discussion | 0 | June 11th, 2005 08:51 PM |
Cleaning up a GIANT mailing list, with many duplicate names | PSlaven33 | New Users | 3 | June 10th, 2005 01:23 PM |
duplicate mailing labels | jaytee | General Discussion | 1 | May 12th, 2005 06:00 PM |
Avoid Duplicate Mailing labels | Ellen | Setting Up & Running Reports | 2 | January 6th, 2005 06:03 PM |
How do I print mailing labels using addresses from my Outlook Con. | Gary | Contacts | 1 | November 28th, 2004 03:01 AM |