Mailing Labels

[Helen]

I don't work with Access but 2-3 times a year so I am very
frustrated when I do need to use it. (Had classes 6-7
years ago.)

My question today has to do with printing my database on
mailing labels.

An earlier version (I have 2002 loaded) had this as part
of a wizard. I could identify the label format and it
would print on my labels. Wasn't perfect but it worked
well enough.

I can't find this feature on the current version. How do
I get mailing labels printed. HELP wasn't.

 

[Ivan Grozney]

Helen wrote ...
I don't work with Access but 2-3 times a year so I am very
frustrated when I do need to use it. (Had classes 6-7
years ago.)

My question today has to do with printing my database on
mailing labels.

An earlier version (I have 2002 loaded) had this as part
of a wizard. I could identify the label format and it
would print on my labels. Wasn't perfect but it worked
well enough.

I can't find this feature on the current version. How do
I get mailing labels printed. HELP wasn't.

*************************************************
Ms. Helen,

If you are doing it off a table you can highlight
the table, go to INSERT and select REPORT. On that screen
is a LABEL WIZARD. That should get you where you want to
go.

When formatting the labels, here are what I use
the concatenate the city/state/zip and firstname/lastname
together. The PO likes the stuff in all caps so that is
what the UCASE will do for you.

=Trim(UCase([FirstName]) & " " & UCase([LastName]))
=Trim(UCase([CompanyName]))
=Trim(UCase([Address]))
=Trim(UCase([City]) & " " & UCase([State]) & " " & [Zip])


hth

Ivan