At 17:30 04/01/2009 -0800, Allan Abrahamse wrote:
How do I use openoffice writer to create a "directory" (the term MS Word uses). That is, a single document with a list whose items are records in a database. Openoffice mail merge seems to only want to send each record to a different page.

I don't know that you can use Mail Merge in this way - at least, not directly. Here is a slightly messy workaround, which you may or may not find useful:
o  Follow the Mail Merge Wizard up to Step 6: Edit document.
o  Click the Edit Document... button.
o Cut the entire content - the fields and any other text - from the frame and paste it outside the frame.
o  Delete the frame.
o  Click the Return to Mail Merge Wizard button.
o  Continue the Wizard to Step 8: Save, print or send.
o  Select "Save merged document" and "Save as single document".
o Click Save Documents and Finish. (You now have what you need except for your stated problem: each record is on a separate page.) o Select all the material, cut it, and then use Edit | Paste Special... (or right-click | Paste Special... or Ctrl+Shift+V) to paste it back into place. In the Paste Special dialogue box, select "Unformatted text". This removes the page breaks at a stroke. (I don't see any reliable way to do this using regular expressions.)
o  Adjust formatting as required.

I trust this helps.

Brian Barker


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to