Accell labels won't print correctly

[Guest]

I'm trying to use the label wizard to create labels on Avery 5160 but it
keeps saying that there is not enough horizontal space and directs me to go
to page setup and either decrease the number of columns or the space between
and when they print the first four rows are okay then they start to mess up.
Does anyone have any ideas?

 

[Guest]

I meant to say Access.... don't know what my fingers were doing!!

 

[Van T. Dinh]

It may have something to do with the paper size for your printer. For
example, if you printer is set to default to A4, the Avery 5160 may be wider
than A4 and you will get this sort of warning.

 

[Guest]

Well I found a way to do it myself. It was the hard way but they work now.

 

[Guest]

Well what I did was I used Microsoft Word and did a Mail Merge with label as
the setting and just selected my access databases. It was actually pretty
easy once I started doing it. I've sent stuff from Access to Word but this
was the first time I obtained stuff from Access and put it into Word. It was
a learning experience... and now I'll always know how to do it. (I use
WordPerfect more than anything else - I just don't like Corel's databases and
spreadsheets) Thanks for your help though.

 

[Van T. Dinh]

When you have time, you can try to print the labels directly from Access
without using Word MailMerge.

I find the Label Wizard in Access is more convenient than using Word
MailMerge.

 

[Guest]

I did try and I kept having that print problem. I checked my printer and it's
set on 8.5 x 11 so I don't know why it wouldn't work.