Printing address labels

Discuss the word processor
Post Reply
grampst
Posts: 6
Joined: Fri Jul 06, 2018 10:27 am

Printing address labels

Post by grampst »

When I try to print a sheet of my address labels I select sheet but it only prints one label. What the heck am I doing wrong
open office 415
windows
John_Ha
Volunteer
Posts: 9584
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: printing address labels

Post by John_Ha »

Either search the Writer forum with labels or mail merge, or read (all of) Chapter 11 - Using Mail Merge in the manual.

As a new poster you will find much useful information in the Writer FAQ, the Writer Tutorials, the up to date Writer guide and the Writer Manual. May I suggest you bookmark the pages.

Press F1 to access the Help screen and search for your problem

The chapter headings in the manual are:

1 - Introducing Writer
2 - Setting up Writer
3 - Working with Text
4 - Formatting Pages
5 - Printing, Exporting, Faxing and E-Mailing
6 - Introduction to Styles
7 - Working with Styles
8 - Working with Graphics
9 - Working with Tables
10 - Working with Templates
11 - Using Mail Merge
12 - Tables of Contents, Indexes and Bibliographies
13 - Working with Master Documents
14 - Working with Fields
15 - Using Forms in Writer
16 - Customizing Writer – Keyboard shortcuts.

When a pop-up window opens, click the Help button for extensive help on that function - it is often more comprehensive than the manual.

Showing that a problem has been solved helps others searching so, if your problem is now solved, please view your first post in this thread and click the Edit button (top right in the post) and add [Solved] in front of the subject.
LO 6.4.4.2, Windows 10 Home 64 bit

See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
grampst
Posts: 6
Joined: Fri Jul 06, 2018 10:27 am

Re: printing address labels

Post by grampst »

I've done all you suggested and I still can't print column 1 row 2 There is no print button when I select that.
open office 415
windows
UnklDonald418
Volunteer
Posts: 1548
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: printing address labels

Post by UnklDonald418 »

If you have a label document with a single label you need to create a new one with File>New>Labels and on the Options tab select Entire page.
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
John_Ha
Volunteer
Posts: 9584
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: printing address labels

Post by John_Ha »

1. Start again with a new test spreadsheet, a new database and new label sheet.
2. Follow the instructions in the manual exactly, including registering the database.

It will work so now find out what you are doing differently with your actual labels.

If not give a precise and detailed description of what you did and the result, like

1. Open labels sheet for Avery L7160 labels
2. File > Print. Pop-up window asks "Do you want to print a form letter?" > YES
3. Spreadsheet opens > choose rows 1 to 20 > OK
... etc
LO 6.4.4.2, Windows 10 Home 64 bit

See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
Post Reply