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 -- Registerd Linux user #445917 at http://counter.li.org/ Please do not send me copies of list mail. I read the lists. Thanks! --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
