Re: [libreoffice-users] Printing labels from LO-Base

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: users+unsubscribe@global.libreoffice.org
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