Writer Guide

address field. It has the general form of:
![Database.Table.Database field]
where the ‘!’ (NOT) character indicates the negative case and
the square brackets indicate the condition.
For example, in our Points database the condition to test if the
Company field is empty would be
![Points.Sheet1.Company] as illustrated in Figure 300.
To test for multiple conditions, use the operators AND and/or
OR between the conditional statements, for example:
![Points.Sheet1.Title]AND![Points.Sheet1.Last Name]
Click Insert, but do not close the dialog until all lines have
been amended.
e) Repeat for each paragraph to be conditionally suppressed,
remembering to advance the cursor to the end of the line in
question before changing the last element of the condition and
Inserting the result.
Caution
The last paragraph of the label address block ends with a special
field, Next record:Database.Table (Next record:Points.Sheet1 in
our example), and the Hidden paragraph field MUST be inserted
before this field. This can generally be accomplished by clicking
at the end of the paragraph and then using the Left Arrow key
once to skip back over it.
A clue that you omitted this action is the observation that some
records have been skipped and are missing from the final output.
f) Remembering that we selected
Synchronise contents earlier,
you should now be able to see a
small window containing a button
labelled Synchronise Labels. Click on this button and the
hidden paragraph fields are propagated to all the labels in
your document.
You now have a template suitable for future use with the same
data source and type of label. If you wish to save it, use either
File > Templates > Save as, or save it as an Open Document
Text Template (.ott) into the private template directory (folder)
that you have previously defined in
Tools > Options > OpenOffice.org > Paths > Templates.
The labels are now ready to be printed.
1) Click File > Print. The message shown in Figure 301 appears.
Click Yes.
Chapter 11 Using Mail Merge 353