Ask Your Question

how to make continuous merged text document [closed]

asked 2013-01-10 21:49:27 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

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.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-02 03:46:43.487277


Hi Anon -- Still looking for an answer here?

qubit gravatar imagequbit ( 2013-04-28 20:05:48 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2013-06-09 11:08:11 +0100

nnino gravatar image

updated 2013-06-09 11:18:10 +0100

  1. Take a mature LibreOffice version (I have 3.6.5/WinXP, 4.0.3 still seems buggy)
  2. Copy the two lines you have created and paste them repeatedly until the end of the (first) page.
  3. 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.
  4. 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 ===

edit flag offensive delete link more

Question Tools


Asked: 2013-01-10 21:49:27 +0100

Seen: 1,421 times

Last updated: Jun 09 '13