OPEN OFFICE WRITER MAIL MERGE MANUAL

Click Insert, but do not close the dialog until all lines have been amended.To test for multiple conditions use the operators AND and/or OR between the conditional statements, for example: !AND!.It has the general form of: ! where the ‘!’ (NOT) character indicates the negative case and the square brackets delineate the condition.įor example, in our Points database the condition to test if the Last Name field is empty would be: ! as illustrated in Figure 18. Now click in the Condition box and enter the details of the condition that defines a blank address field.Select the Functions tab and then click on Hidden Paragraph in the Type column.

Click at the end of the first paragraph to be suppressed and then select Insert > Fields > Other.

(See below for an example.) At this time you may wish to consider suppressing any blank lines that may appear in the resulting letters.

Continue until you have composed the entire document.

The reason for this will be made clear in the next paragraph.ĭragging fields to the body of the form letter. Note that address lines should be in individual paragraphs, not separated by line breaks as might seem preferable.

Now create or modify the form letter by typing in text, punctuation, line breaks, and so on that will be present in all of the letters, and adding fields where needed by clicking in the field heading and dragging to the appropriate point in the letter.

Expand the Points and Tables folders, and select Sheet1.

Find the data source that you wish to use for the form letter, in this case Points.

Display the registered data sources: View > Data sources (or press F4).

Create a new text document: File > New > Text Document.

If you elect to use the wizard, pay close attention to its current (OOo V2.3) limitations, as identified within its description. You can create a form letter manually, which is the simplest and most comprehensive method and is described here, or you can use the Mail Merge wizard to create a form letter as described in Using the Mail Merge Wizard to create a form letter. At the end of the year, they want to send a letter to each customer to show the total of credit points collected. Example: Sending a letter to your customer baseĪ mail order company organized a campaign to assign credit points to their customers according to the quantity of goods they buy during one year. This worked! Thanks and more thanks! Hope I can remember it next time - I do mail merges about once every. > Go to Tools->Options->Writer->Print and uncheck 'Print Automatically Inserted Blank Pages'. You can print the letters first, and then print the envelopes separately. I have a few templates for the envelopes I use and I just use them as though the envelope was a normal document. Yea, that's what I did, which is how I found the post dealing with exactly my problem - every other envelope being blank. > There are lots of forum posts - search with envelope or with mail merge or with printing addresses or with labels. Yea, I did read the Writer Manual, but found nothing addressing the problem of every other envelope being blank, so I came to the forum.

OPEN OFFICE WRITER MAIL MERGE MANUAL

> Can I suggest you check the up to date Writer guide and/or the OOo v3.3 Writer Manual and read the chapter on Mail Merge and the pages on envelopes. Yea, all this was done, which is how I discovered the problem as I stated it - every other envelope was blank. > 3 Now get Mail Merge to fill in the fields you define in the envelope. > 2 Get inserting an envelope to work so that you can print an inserted envelope > 1 Get the Mail Merge to work without the envelope so you know Mail Merge works. > Break it down into three simpler problems: Since my problem was exactly the same as the one in the thread I posted to, I thought a new thread would be inappropriately duplicative. You should always open a new thread with a new problem - I have asked for your posts to me moved to a new thread.

Open office writer mail merge