Complex Mailing Labels

[J]

Hi,
I have a list of customers that I need to print mailing lables for. We
have many customers living in the same household and I want to send a
brochure only to each household but address the customer(s) individually.
I created the query:

Select FName + " " + LName as [Name], Address, City + ", " + State + " " +
Zip as CSZ
From Customers

How can I create the Report so the labels print on Avery 5160 as

For example:

John Doe, Jane Doe Mike Williams,
Kate Johnson
123 Street Rd. 552 Lane
St.
New York, New York 19858 Philadelphia, PA 19525

etc...


Thanks in advance


J

 

[Allen Browne]

Ultimately, the only way to handle this with any reliability and flexibility
is to include the households as "clients" in their own right, with their own
Addressee and Saluation fields.

There are just too many options for Access to be able to handle this
automatically. Combining names. Different surnames at the same address.
Addresses that are slightly different when they should not be (e.g 123
Street Rd and 123 Street Road and 123 Street Rd. and 123 Street Rd [with 2
spaces].) Cases where you do need 2 doctors at the same surgery to get their
own individual copies. Cases where you have been requested NOT to include
one person's name at an address. And lots more.

For suggestions on how to develop a data structure so you can select
individuals and/or households to send your mailings to, see:
People in households and companies - Modelling human relationships
at:
http://allenbrowne.com/AppHuman.html

 

[J]

Thank you

Ultimately, the only way to handle this with any reliability and
flexibility is to include the households as "clients" in their own right,
with their own Addressee and Saluation fields.

There are just too many options for Access to be able to handle this
automatically. Combining names. Different surnames at the same address.
Addresses that are slightly different when they should not be (e.g 123
Street Rd and 123 Street Road and 123 Street Rd. and 123 Street Rd [with
2 spaces].) Cases where you do need 2 doctors at the same surgery to get
their own individual copies. Cases where you have been requested NOT to
include one person's name at an address. And lots more.

For suggestions on how to develop a data structure so you can select
individuals and/or households to send your mailings to, see:
People in households and companies - Modelling human relationships
at:
http://allenbrowne.com/AppHuman.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Hi,
I have a list of customers that I need to print mailing lables for.
We have many customers living in the same household and I want to send a
brochure only to each household but address the customer(s) individually.
I created the query:

Select FName + " " + LName as [Name], Address, City + ", " + State + " "
+ Zip as CSZ
From Customers

How can I create the Report so the labels print on Avery 5160 as

For example:

John Doe, Jane Doe Mike
Williams, Kate Johnson
123 Street Rd. 552
Lane St.
New York, New York 19858 Philadelphia, PA
19525

etc...


Thanks in advance


J

 

[Frank Martin]

We fixed something along these lines in our
database.

We scrapped the old address system and made
several new tables:

1/ tblPEOPLE
2/ tblPeopleType
3/ tblAddressName(People Alias)
4/ tblAddressType
5/ tblAddressDetail

tblPEOPLE is where any name is entered only
once.

tblPeopleType defines
"personal/freighter/customer/supplier/consultant
etc etc"

tblAddressName is the same as tblPEOPLE but
is an alias.

tblAddressType defines "head-office, postal,
residential, FOB, FIS, factory etc"

tblAddressDetail contains all static details
like phone numbers street addresses, web
pages etc. and of course is connected to the
other tables with the appropriate IDs.

With this flexible system we can add
contacts, delete names, copy records and
alter just one field, and add/delete types
too.

All this has worked very well for about two
years now.