mailing labels--PLEASE help!

[lindsaybee]

ok, still trying to get the christmas cards out, so i entered all the names
and addresses into a contacts database on access 2007. but when i try to
formulate avery mailing labels using the label wizard, i get stuck o nthe
step where it asks you to construct the label on the right by choosing fields
from the list on the left. my list has the following options:
file as
contact name
id
company
last name
first name
.......
all the way down to city, state, zip, and then about five different
attachment options BUT NO ADDRESS!!

this means i can get everything i need (name, city, state, and zip) onto the
label, except for the house and street number! why is it only presenting me
with these options? i tried to copy to command and wrote {address} onto the
form but it said that didnt match any of the existing fields, although it
clearly does--the street address appear on my contact list under the column
"address."

what am i doing wrong?? i just spent hours entering all the addresses and i
can bear the thought of doing it over only to remain stuck. i would so
appreciate any help you can offer

 

[Allen Browne]

The most likely explanation is that you are using a query as the source for
the label report, and you left the address field out of the query.

If that is not the case, you can go ahead and use the wizard to place all
the other fields on the label. Then switch to design view, and add the
address field.

Merry Christmas.