how do I print labels from table in access

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

Guest

I created a table in Access. The table consist of names, address and phone
numbers of businesses. I would like to print this information in a mailing
label format. Can you assist??
 
Dee said:
I created a table in Access. The table consist of names, address and phone
numbers of businesses. I would like to print this information in a
mailing
label format. Can you assist??
Click to expand...

Access'll help you with a wizard. Go to the Reports section. Click on the
New button (at the top of the db window). Choose Label Wizard, select your
table in the combobox and follow the wizard's steps.
 
Thanks. Info VERY HELPFUL!!! Another issue...the addresses are on the same
line as the company names on the labels and there's no space in between city,
state and zip. Can you assist? Thanks.
 
The wizard created a report. You can open it in design view and adjust the
controls. It may be that the company name/addresses are on the same line
because of the size of the label you chose, or they are in the same field in
your table. The information should be in separate fields.

You can easily add the spaces you want in design view of the report.
 
Back
Top