When you download mail merge template or create your own, you lose a feature that’s built into the OpenOffice.org mail merges and reports: printing more than one record on a sheet of paper. However, it’s easy to add that ability yourself.

This article addresses the issue of how to have information from multiple records on the same sheet of paper, in mail merges for lists, downloaded label templates, and other mail merge documents. The first section of this article explains how mail merges work regarding when the next record is chosen, and why. If you’re already familiar with this, go straight to the solution in the tutorial part of the article, Triggering a new record whenever you want it by using the next record field.

This article has three sections: the problem, how the program works, and how to get around it.

• How mail merges work by default covers the default behavior, and why that’s not always what you want
• Why the mail merge doesn’t trigger the next record all the time covers why it’s sometimes a good idea, and sometimes not, to have the same record print multiple times on the same sheet of paper. It’s a “nice to know” explanation that you can skip if you’re looking for the solution.
• Triggering a new record whenever you want it by using the next record field provides steps for controlling exactly when your mail merges switch to the next record.

A mail merge is a connection between a document and a database

How mail merges work by default

A mail merge is a connection between a document and a database. The document pulls information for certain fields, like Name and Address and Birthdate, out of the database. You set up your mail merge document easily (figure 1).

Figure 1: Standard mail merge setup

The information for the first record (the first person in this case) is printed, then the second record, and so on (see figure 2).

Figure 2: The printed results of a mail merge

Here’s the question, though:

When do you go to the next record? What makes the mail merge document switch so that we see the information about Miranda?

In labels, it makes sense for information about the next record to show up in the next label, which is the next time that the field appears. And that’s how it works when you create labels—at least, when you create labels by choosing File→New→Labels. It’s also how things work when you create a report generated from your database; multiple records will be printed in the same page because the logic is built into the report wizard.

Let’s say that you don’t want to use the document-creation tools provided by OpenOffice.org; you want some more control over exactly what output you have. So you download templates, like the ones at WorldLabel.com, which has free OpenOffice.org templates. If you’re using those templates or if you create your own mail merge document from scratch, you’re going to get the same name and address in every label area until you go to the next page, with 10 or 30 labels for the same person. The logic to trigger the next record isn’t built into those templates.

Situations when you want to have multiple fields from the same record on the same page

The default behavior for mail merges is to err on the side of giving you the opportunity to repeat information if you want it. And sometimes you do. If you’re creating a mail merge letter, you sometimes want the same information for one record to repeat. Sometimes your letter goes for three pages. It certainly doesn’t make sense to show information from the next record after each carriage return, or the next time the field shows up.

The default behavior for mail merges is to err on the side of giving you the opportunity to repeat information if you want it

FIgure 3 shows you how you might set up a typical mail merge letter.

Figure 3: Setting up a mail merge letter

Figure 4 shows you what it would look like if you triggered a new record each time you got a new carriage return, reuse of a field, or new page.

Figure 4: Unfortunate results of a mail merge that flips to the next record each time a field appears again