Labels from Spreadsheet

Discuss the word processor
Post Reply
cpbrawand
Posts: 1
Joined: Sun Dec 09, 2018 6:14 am

Labels from Spreadsheet

Post by cpbrawand »

I have created a database from a spreadsheet containing 160 entries (rows) 5 (Columns)
When I go to create labels for the 160 entries, I only get a single sheet with the first row of 5 columns of data repeated on the sheet, it does not move to the next row.
Can anyone help?
OpenOffice 4 on Windows 7
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Labels from Spreadsheet

Post by Villeroy »

Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
John_Ha
Volunteer
Posts: 9583
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: Labels from Spreadsheet

Post by John_Ha »

Read Chapter 11 - Using Mail Merge in the writer Guide where it is explained in excruciating detail.

You need three files for Mail Merge (what you are doing) to work:

1. A spreadsheet .ods file with the names and addresses
2. A database .odb file which acts as the interface to the .ods file. The database file must be registered.
3. A text document .odt file with the fields you need to fill.

You also need 32-bit Java installed if you use the wizard.

Search this forum with labels or mail merge for countless posts.

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.
Post Reply