"Jonathan Kaye" <[email protected]> wrote in message news:[email protected] > 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
See if this is any help: \n in Find and Replace: Represents a line break that was inserted with the Shift+Enter key combination. To change a line break into a paragraph break, enter \n in the Search for and Replace with boxes, and then perform a search and replace. \n in the Search for text box stands for a line break that was inserted with the Shift+Enter key combination. \n in the Replace with text box stands for a paragraph break that can be entered with the Enter or Return key. I haven't played with it, but it looks like the right area. Help: Find tab, enter "find page break" without the quotes. You'll note there are additional finds listed there also. HTH, Twayne` --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
