Jonathan Kaye wrote:
Hi all,
Googled high and low and nothing even close to a solution. Here's the
problem. I'm using mail merge to convert data in a spreadsheet into a nice
report formatted the way I want. Everything is great except that OOo wants
to put a hard page break following every record (83,000 of them) but I want
the records to flow from one to the other without even a line break. (Don't
panic! There are line breaks but they don't come at the end of every
record). So what I would like to do is one of the following:
1. Let OO insert the page breaks and then I use a search/replace to convert
them all to a single space, or
2. Convince mail merge somehow not to put hard page breaks at the end of
every record. Instead it can put whatever it wants as long as I can find it
using a regular expression (so a newline is fine with me. But Openoffice,
unlike WordPerfect (ahem ;)) makes it impossible to find page breaks.
Any solutions will be rewarded by warm thoughts directed towards the genius.
Thanks,
Jonathan
Please try the following. It works in a simple case in which I
deliberately created a 4-page document by inserting a manual page break
before each of lines 2, 3 & 4 of what started as a 4-line document.
* Select the entire document except the first record (Ctrl-A probably).
* Go to menu Format>Paragraph>Text Flow
* Uncheck the box labelled "Insert" under the heading "Breaks" near
the middle of the pane.
* Click OK.
You *might* end up with a blank line after each record (I did). If so,
use the Regular Expression "^$" (without the quotes) to get rid of those
empty lines (change all occurrences of it to the null string).
--
Harold Fuchs
London, England
Please reply *only* to [email protected]
