Writer Guide

lines, you need to replace line breaks with paragraphs as
follows.
c) Click at the end of the last data source address field in the
first line of the label. Press Delete to remove the new line and
then press Return (or the Enter key) to insert a paragraph.
Repeat this action for each line of the label.
If the line spacing in the Addressee area is not satisfactory,
you may wish to correct this before proceeding, by modifying
the paragraph style associated with the address. Unless you
have changed it, the address uses the Default style.
d) Click again at the end of the first paragraph to be
conditionally suppressed and then choose Insert > Fields >
Other. Select the Functions tab and then click on Hidden
Paragraph in the Type column. 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 299.
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 box 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.
Merging and printing the envelopes
To merge addresses and print the envelopes:
1) Choose File > Print. A message box (Figure 300) appears. Click
Yes.
2) The Mail Merge dialog box (Figure 301) appears. As with form
letters and mailing labels, you can choose to print envelopes for
one, several or all address records in the database.
Chapter 11 Using Mail Merge 367
Free eBook Edition