Printing Labels using Access 2007

[Robert]

I am trying to print address labels on an Avery sheet (3 columns by 7 rows),
but all I can get is 1 label per A4 page. Can anyone suggest a solution
please?

Robert

 

[Dale Fye]

Have you tried the Label Wizard in the Reports?

Reports | New | Label Wizard

It lets you select from among the various Avery label types and
automatically configures your columns correctly. Once the wizard has done
its thing, you can go in and tweak the format of the labels.

HTH
Dale

 

[Robert]

Thank you - yes I have tried this and it was only in desperation after this
did not work and I felt if should have that I posted the question, but thank
you for you help.

I was wondering if this could be a macro and be affected by security
settings, although I have tried setting these as low as possible for the
test.

Robert