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 > [EMAIL PROTECTED] > 602 524-0376 > 480 945-9197 fax > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
