If you're trying to use hidden paragraphs, we had a long discussion about this problem on this list a couple of weeks ago and concluded that it doesn't work, due to a bug in OOo. The workaround is to put those paragraphs into hidden sections.

Regards, Jean


[EMAIL PROTECTED] wrote:
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







---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to