Creating labels is an impossible task in LO

English
#1

I followed all the instructions to create a database from a CSV file. Then used the label wizard to select an Avery format.

When I get to the new document, and try to print, answer yes on the question the document contains addresses I always get the message that the connection to the database cannot be made. When I open the dialog, I see the connection to the right database. But whatver I do or try or click, no mail merge window is ever shown.

This part of LibreOffice must have been designed by a veritable enemy of humanity. It is worse then listening to Vogon poetry…

#5

Hello,

Have created labels through LO Writer form many years simply to answer questions like yours. Have not seen any need to used Calc to create the labels and Calc does not do nearly everything that the database has.

When asking a question you should include basic information such as Specific LO version and OS used. In your case you also noted:

But what/where are those instructions? Also:

but I do not understand what dialog this is. Please provide further information.

#6

I am running LO 6.0.7.3 on Linux Mint 19.1 Tessa

When printing I first get this error dialog telling that a connection to a datasource could not be made and offering to check the connections:

Then I just see the datasource and that it is selected. Howver selecting it again, or trying to edit it, or deleting and recreating it, and then pressing OK (or any other button) just closes the dialog without doing anything:

2021-10-10-screenprint-database-selection
2021-10-10-screenprint-database-selection1920Ă—1080 212 KB

(everything in Dutch sorry for that)

#7

And the instructions where the instructions in chapter 14 of the 6.0 userguide on mail merge and labels. Also looked into some other problems people encountered, but that did not provide a solution for e either.

#2

I would use a Spreadsheet to print Address Labels - Load the CSV into a Spreadsheet with each name address in a Separate cell & control of alignment would be controlled by adjusting the Column Spacing for Your Address Labels - nearly everything that the database has can also be done as a Spreadsheet or a number of pages of the spreadsheet document - the other option is to create a Table on a Word type Document which might also work…

#3

If you go this way try and get the data into calc from a query. That would give you the flexibility of a spreadsheet layout and database data management.

1 Like
#4

In the end I created a python script, basing myself on the suggestions here:

Here is my version of the utility, modified to create address labels:

1 Like
#8

Did not see this before I posted my other comments.

So no further help wanted?

#9

I would like some solution, as in general I like LO a lot and want to promote its use. So the fact that what should be relatively simple is so complicated, and even for an experienced IT person as myself actually impossible or at least very hard to accomplish, is quite frustrating

#10

@NL66278

OK. Please verify the Base file is displaying data. Open your Base .odb file and in the tables section double click on the table name (appears this is Adres).

Is there a display of data?

Edit:

If there is no data you did not create the Base file correctly or moved something.

If data is there, re-establish the registration. From the menu Tools->Options on the left under LibreOffice Base->Databases on the right highlight the connection your have and Delete (button). Close ALL open LO items.

Again open the Base file & get back to the registration screen and Add (button) the Base file again. When done, close ALL open LO items again.

Now try creating the labels again from the start in Writer.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.