Making Mailing Labels from a Member List

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Our club member list is in Access 2003. Each member is a separate record. We
have single, married and dependent members.

I would like to make mailing labels from the member list so that only one
label is made per address regardless of the number of members living at that
address.

A plus would be the ability to list all the names of the members at that
address on the label - for example: Tom, Jane and Billy Smith.

How can I do this?

Thanks,
David
 
When you go to build a report, there is a LABEL WIZARD that will walk you
through building the label.

combining the names would be done something like...


= [Firstname] & IIf ([spousename]<>"",", "&[SpouseName],"") & IIf
([Childname]<>""," and "&[ChildName],"") & [LastName]

Note that this is aircode. You may need to perfect it a bit.

Rick B
 
Rick B,

Thanks very much for responding. I believe I understand your info on
combining names but I am not sure about how to get just one label when there
are two or more records with the same address.

Regards,
David

Rick B said:
When you go to build a report, there is a LABEL WIZARD that will walk you
through building the label.

combining the names would be done something like...


= [Firstname] & IIf ([spousename]<>"",", "&[SpouseName],"") & IIf
([Childname]<>""," and "&[ChildName],"") & [LastName]

Note that this is aircode. You may need to perfect it a bit.

Rick B



DavidWP said:
Our club member list is in Access 2003. Each member is a separate record. We
have single, married and dependent members.

I would like to make mailing labels from the member list so that only one
label is made per address regardless of the number of members living at that
address.

A plus would be the ability to list all the names of the members at that
address on the label - for example: Tom, Jane and Billy Smith.

How can I do this?

Thanks,
David
Click to expand...
Click to expand...
 
AHHHH Sorry. I thought you had one record with a "anme" "spouse name", etc.
field.

I'd think you would need to build a UNION query to combine records that have
like addresses or maybe a "family number" or some other key.

Maybe someone will be able to post back with a better answer.


Sorry,
Rick B



DavidWP said:
Rick B,

Thanks very much for responding. I believe I understand your info on
combining names but I am not sure about how to get just one label when there
are two or more records with the same address.

Regards,
David

Rick B said:
When you go to build a report, there is a LABEL WIZARD that will walk you
through building the label.

combining the names would be done something like...


= [Firstname] & IIf ([spousename]<>"",", "&[SpouseName],"") & IIf
([Childname]<>""," and "&[ChildName],"") & [LastName]

Note that this is aircode. You may need to perfect it a bit.

Rick B



DavidWP said:
Our club member list is in Access 2003. Each member is a separate
Click to expand...
record.
We
have single, married and dependent members.

I would like to make mailing labels from the member list so that only one
label is made per address regardless of the number of members living
Click to expand...
at
that
address.

A plus would be the ability to list all the names of the members at that
address on the label - for example: Tom, Jane and Billy Smith.

How can I do this?

Thanks,
David
Click to expand...
Click to expand...
Click to expand...
 
It's not really a good idea to depend on an address as a primary key to
isolate duplicate records. Some people will write out North...some will write
N. There's too many things that can go wrong there. I use a phone number for
that purpose to pull out one occurrence per household using "First". The
query would be something like:

SELECT Contacts.[BusinessPhone], First(Contacts.FullName) AS FirstOfFullName
FROM Contacts
GROUP BY Contacts.[BusinessPhone]
ORDER BY Contacts.[BusinessPhone];


Rick B said:
AHHHH Sorry. I thought you had one record with a "anme" "spouse name", etc.
field.

I'd think you would need to build a UNION query to combine records that have
like addresses or maybe a "family number" or some other key.

Maybe someone will be able to post back with a better answer.


Sorry,
Rick B



DavidWP said:
Rick B,

Thanks very much for responding. I believe I understand your info on
combining names but I am not sure about how to get just one label when there
are two or more records with the same address.

Regards,
David

Rick B said:
When you go to build a report, there is a LABEL WIZARD that will walk you
through building the label.

combining the names would be done something like...


= [Firstname] & IIf ([spousename]<>"",", "&[SpouseName],"") & IIf
([Childname]<>""," and "&[ChildName],"") & [LastName]

Note that this is aircode. You may need to perfect it a bit.

Rick B



Our club member list is in Access 2003. Each member is a separate record.
We
have single, married and dependent members.

I would like to make mailing labels from the member list so that only one
label is made per address regardless of the number of members living at
that
address.

A plus would be the ability to list all the names of the members at that
address on the label - for example: Tom, Jane and Billy Smith.

How can I do this?

Thanks,
David
Click to expand...
Click to expand...
Click to expand...
 
rowiga,

Thanks for your reply. I understand the concept but I don't know how to
access a screen to enter the "SELECT", "FROM", etc commands. I have done them
in the distant past but can't remember how to get there. Any further,
detailed help you can supply would be greatly appreciated.

David

rowiga said:
It's not really a good idea to depend on an address as a primary key to
isolate duplicate records. Some people will write out North...some will write
N. There's too many things that can go wrong there. I use a phone number for
that purpose to pull out one occurrence per household using "First". The
query would be something like:

SELECT Contacts.[BusinessPhone], First(Contacts.FullName) AS FirstOfFullName
FROM Contacts
GROUP BY Contacts.[BusinessPhone]
ORDER BY Contacts.[BusinessPhone];


Rick B said:
AHHHH Sorry. I thought you had one record with a "anme" "spouse name", etc.
field.

I'd think you would need to build a UNION query to combine records that have
like addresses or maybe a "family number" or some other key.

Maybe someone will be able to post back with a better answer.


Sorry,
Rick B



DavidWP said:
Rick B,

Thanks very much for responding. I believe I understand your info on
combining names but I am not sure about how to get just one label when there
are two or more records with the same address.

Regards,
David

:

When you go to build a report, there is a LABEL WIZARD that will walk you
through building the label.

combining the names would be done something like...


= [Firstname] & IIf ([spousename]<>"",", "&[SpouseName],"") & IIf
([Childname]<>""," and "&[ChildName],"") & [LastName]

Note that this is aircode. You may need to perfect it a bit.

Rick B



Our club member list is in Access 2003. Each member is a separate record.
We
have single, married and dependent members.

I would like to make mailing labels from the member list so that only one
label is made per address regardless of the number of members living at
that
address.

A plus would be the ability to list all the names of the members at that
address on the label - for example: Tom, Jane and Billy Smith.

How can I do this?

Thanks,
David
Click to expand...
Click to expand...
Click to expand...
 
Back
Top