I am making a phone, address, email roster in LO Writer from data included in a LO Base query. It includes two lines, second line is indented. I included the Next record “command” at the end of the second line. I included a paragraph return at the end of both lines. The output produces all 250 records, EXCEPT each record is on a separate page. I’m sure this something simple to correct, but I do not know how. Any assistance will be appreciated.
Thanks.
Hi Anon – Still looking for an answer here?
- Take a mature LibreOffice version (I have 3.6.5/WinXP, 4.0.3 still seems buggy)
- Copy the two lines you have created and paste them repeatedly until the end of the (first) page.
- From the last line on the page, remove the “Next record” field (works better with View > Field names" switched ON), as at the and of a page, LibreOffice by default moves to the next record in the database. So removing this command prevents losing a record.
- With Mail Merge wizard choose “Save merged document > Save as single document”
In the end you should have something like
=== TOP OF PAGE ===
<database.FirstField> <database.SecondField>
<database.LastField>NextRecord:database
<database.FirstField> <database.SecondField>
<database.LastField>NextRecord:database
[…]
<database.FirstField> <database.SecondField>
<database.LastField>NextRecord:database
<database.FirstField> <database.SecondField>
<database.LastField>
=== END OF PAGE ===