Harold, Please see new Post titled "Find Page Breaks?" It's an extension of this conversation but goes off in a different direction.
Thanks, Twayne` "Harold Fuchs" <[email protected]> wrote in message news:[email protected] > 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). Twayne --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
