I took at look at the reference cited (I found it to be on p. 195 of the OOo User Guide for 2.0; the topic is "Avoiding Blank Paragraphs"). I could very well be doing something wrong. However, I followed the instructions as closely as I could, and it didn't work. It suppressed the paragraph on everything, not just on records that had that field blank. Anyone else have any success or failure with these instructions? In a message dated 12/26/2005 7:39:56 PM Eastern Standard Time, [EMAIL PROTECTED] writes:
Have a look at the user guide (http://documentation.openoffice.org) ... there is a section on this (~ page 167)... /paul On 12/23/05, Mark Phillips <[EMAIL PROTECTED]> wrote: > I am creating sheets of labels from a mysql database. I am using OO 2.0 on > Debian. > > When doing a mail merge from the database, how do I skip fields that are null? > > For example, I have two fields in my database - addr_1 and addr_2. On the > label I place addr_1 on one line and addr_2 on the next line. However, not > all the addresses need two lines. If a record in the database has a null for > addr_2, then I don't want a blank line on the label. How do I tell OO to skip > the field if it is null? > > Thanks > -- > Mark Phillips > Phillips Marketing, Inc
