hey

i'm trying to create a label for a mailing list using 2 tables, the first contains the name of the company, address, phone number, and the second table contains the name of the ppl working in it and their titles(GM, ITM, etc...)

i need to mention information from both tables such as name of the person and title from one table and name of the company he works in and the phone number and address

The label wizard only lets me pick information from one table only

i'm using Office 2007

thank you ur help

NEED A LITTLE MORE INFO:

1) where are you putting the label?
2) are you talking about a report TITLE?

thx for the reply ajetrumpet
i didn't understand ur first question u mean saving them? or
no it's not a title for a report, i want to print them on stickers for envelops,

here's the structure i have:
First table has the company name and details such as address and phone number
second table is linked to the first with a one to many relationship and contains the names of the employees and their job title

what i want to have is a label containing the name of each employee with their title along with the name of the company they work in, address and phone number of that company

hope my explanation is enough

if what you want is stickers for envelopes, you need to set up a mail merge in MS word! That will give you EXACTLY what you need. Open word and go to:

TOOLS > LETTERS AND MAILINGS > MAIL MERGE.

everything else is self explanatory from there. Use the access table as the source for your merge fields. If you need any help with this, let us know and someone may be able to upload a sample of how you make labels from an access table.

If you're going to do ANY kind of mass mailing, you need to learn mail merge. ;)