Office 2008 mail merge question

[Tim Streater]

Is there any way to get two records onto a single A4 sheet? In effect, I
want to print a short letter and name/address onto an A5 landscape sheet
which is inserted into an A5 window envelope. Easiest way would be if I
could get two of these mail-merged onto an A4 sheet and then cut them in
two.

I thought of just duplicating the upper half into a lower half on the
A4, or of separating the two halves with a section-break-continuous, but
whatever I try I get the same info merged into the fields in the top
half as in the bottom half. What I want is records 1 and 2 on A4 sheet one, records 3 and 4 on A4 sheet two, etc.

Is there a way to do this in Office 2008?

 

[Michael Vilain]

Is there any way to get two records onto a single A4 sheet? In effect, I
want to print a short letter and name/address onto an A5 landscape sheet
which is inserted into an A5 window envelope. Easiest way would be if I
could get two of these mail-merged onto an A4 sheet and then cut them in
two.

I thought of just duplicating the upper half into a lower half on the
A4, or of separating the two halves with a section-break-continuous, but
whatever I try I get the same info merged into the fields in the top
half as in the bottom half. What I want is records 1 and 2 on A4 sheet one,
records 3 and 4 on A4 sheet two, etc.

Is there a way to do this in Office 2008?

Not with the way mail merge is implemented in Office.

The database document has columns or fields that are inserted into the
merged document according to the merge controls. AFAIK, you can
conditionally add fields IN THE SAME RECORD into the same document, but
once you switch records, you can't go back.

Rethink your implementation here. Maybe you need to combine records 1 &
2 into 1 record with multiple fields, like <address> and <env-address>
to get what you want. But they can't be separate records.