OpenOffice.org OpenOffice - 3.3 User Manual download pdf (Page 307)

100

101

5) Continue until you have composed the entire document. At this time you may

wish to consider suppressing any blank lines that may appear in the resulting

letters. If not, skip ahead to Step 7.

Figure 306: The completed form letter

6) To suppress blank lines:

a) Click at the end of the first paragraph to be suppressed and then choose

Insert > Fields > Other.

b) Select the Functions tab and then click on Hidden Paragraph in the

Type column.

c) Now click in the Condition box and enter the details of the condition that

defines a blank 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 307.

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]

d) Click Insert, but do not close the dialog box until you have amended all

the lines that should be suppressed.

Chapter 11 Using Mail Merge 307

1 2 ... 302 303 304 305 306 307 308 309 310 311 312 ... 463 464

Comments to this Manuals

No comments

OpenOffice.org OpenOffice - 3.3 User Manual Page 307

Comments to this Manuals