Help no longer needed. The label fields had to be re-entered. I could not (did not) recognise that they did not have a connection to the database in spite of the fact that all fields were still present from previous uses. I suppose it must have something to do with the loss of database registration (during OS/LO updates?)
Problem solved. On Mon, 2022-12-12 at 20:44 +0100, Harvey Nimmo wrote: > I need help to print address labels from my database. I have had it > working e.g. a year ago, but now I am having trouble. My database > Mariadb10 on a backend server and Base on my frontend desktop. > > I have followed the following procedure (as last year) > > 1. From Base (adresslisten database) select File → New → Labels > 2. In window ‘Labels’ check that source of data and fields under > ‘Label text:” is as desired and select Table Query Q_labels_Xmas (ie. > the one set up for labels) > 3. If not, choose Table and Database fields as desired, moving > fields into Label Text box > 4. Select Format ‘Sheet’ > 5. Select Brand (z.B. Herma A4) and Type (z.B. 4278) of labels > 6. Check Tab Format of labels, in particular the left margin > should > be at least 0,55 cm and top margin 2,25 cm (in case of Herma 4278 > labels) > 7. Tab ‘Options’ are ‘Entire page’ and ‘Synchronise contents’ > 8. Click ‘New Document’ > 9. In Writer document click page navigator ‘First Mail Merge > Entry’ > to highlight the related line of icons. > 10. Before generating the labels (point 13) got to the > File>Printer > Settings>Options and check the box ‘Left pages’ in order to suppress > the generation of blank right pages. > 11. Click icon ‘Edit individual Documents’. All labels should now > appear in a new untitled document > 12. Save the document for later printing or print directly > > All fields appear in the Writer as expected. > However, step 9 fails, there is no response to synchronising with the > database data. There is no response to going to the first data > record. > There is also no response at step 11. There is also no response to > 'Synchronise labels'. > > I am using: > Version: 7.3.4.2 / LibreOffice Community > Build ID: 30(Build:2) > CPU threads: 2; OS: Linux 5.14; UI render: default; VCL: gtk3 > Locale: en-GB (en_GB.UTF-8); UI: en-GB > Calc: threaded > > What am I missing? Any ideas? > -- To unsubscribe e-mail to: [email protected] Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
