"Jonathan Kaye" <[email protected]> wrote in message news:[email protected] > Twayne wrote: > >> "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` > Hi Twayne > Sorry but I'm not looking for a line break. I'm familar with regular > expressions and know how to use them. I am looking for a hard page > break or whatever code the mail merge routine inserts after each > record. It is NOT repeat NOT a line break. It is a page break and I > want to find them a get rid of them. > > Thanks for the effort but it doesn't help. > Cheers, > Jonathan
Sorry for the misinterp, Jonathan. You seem to be right; I can't believe I've never searched for that myself, but I can't find a way either. There must be a way<g>. We need one of the gurus to check in on this one I guess; you're not getting a lot of responses so far. Cheers, Twayne` --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
