Access 2000 labels

[Ray Clemons]

I am printing address labels from an access database. How
do I select which addresses to use? I do not want all of
the addresses printed. I cannot find a way to select
certain addresses to mail merge.

Thank you,

Ray Clemons

 

[Tim Ferguson]

I am printing address labels from an access database. How
do I select which addresses to use? I do not want all of
the addresses printed. I cannot find a way to select
certain addresses to mail merge.

Depends on how you are printing the labels -- let's assume a Report for a
moment.

The easiest way is to set the Recordsource property of the report to a
query: click the "..." button and use the query designer to select which
columns you need printed, any manipulation needed, and the Criteria to use.

For more advanced purposes, it is possible to use link this query to a form
so that the user can pick which YearJoined or HomeState values to filter
on, etc.

If you are using MS Word etc. to create the labels with the MailMerge
wizard, then you can either (a) base it on a query you have already created
inside Access, or (b) use the Criteria boxes in the wizard in Word.

Hope that helps

Tim F