[oldbuffer]

Dear All,

Apologies for the long winded "subject" but what I'm trying to do is easier
to demonstrate rather than explain - but here goes..

As a result of serious increases in postal charges particularly regarding
envelope sizes, I am trying to arrange distribution of our Tennis Club
subscription renewals by halving the physical size of the invoices (ie two
bills on one sheet instead of one bill on a single sheet). The problem I have
is trying to mail merge the information from an Excel Database on to the two
bills, such that the first on the list appears in the top bill, the second on
the list appears in the lower bill and so on - ie I'm trying to fool Word
into thinking that one A4 sheet is in fact two separate sheets. As it stands
at the moment, I can only merge information in the top bill - the bottom one
stays blank. The next on the list then appears in the top half of another
sheet...

Any ideas would be gratefully acknowledged.

thanks and rgds

PT.

[Doug Robbins - Word MVP]

Use a label type mailmerge main document using the Avery J8168 Shipping
Label.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"oldbuffer" wrote in message
news
Dear All,

Apologies for the long winded "subject" but what I'm trying to do is
easier
to demonstrate rather than explain - but here goes..

As a result of serious increases in postal charges particularly regarding
envelope sizes, I am trying to arrange distribution of our Tennis Club
subscription renewals by halving the physical size of the invoices (ie two
bills on one sheet instead of one bill on a single sheet). The problem I
have
is trying to mail merge the information from an Excel Database on to the
two
bills, such that the first on the list appears in the top bill, the second
on
the list appears in the lower bill and so on - ie I'm trying to fool Word
into thinking that one A4 sheet is in fact two separate sheets. As it
stands
at the moment, I can only merge information in the top bill - the bottom
one
stays blank. The next on the list then appears in the top half of another
sheet...

Any ideas would be gratefully acknowledged.

thanks and rgds

PT.

[oldbuffer]

Hi Doug,

A brilliant solution!! Apart from a minor mod to content, the "labels"
worked a charm. You've saved me a fortune in time and money!! Many thanks

Paul.


"Doug Robbins - Word MVP" wrote:

Use a label type mailmerge main document using the Avery J8168 Shipping
Label.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"oldbuffer" wrote in message
news
Dear All,

Apologies for the long winded "subject" but what I'm trying to do is
easier
to demonstrate rather than explain - but here goes..

As a result of serious increases in postal charges particularly regarding
envelope sizes, I am trying to arrange distribution of our Tennis Club
subscription renewals by halving the physical size of the invoices (ie two
bills on one sheet instead of one bill on a single sheet). The problem I
have
is trying to mail merge the information from an Excel Database on to the
two
bills, such that the first on the list appears in the top bill, the second
on
the list appears in the lower bill and so on - ie I'm trying to fool Word
into thinking that one A4 sheet is in fact two separate sheets. As it
stands
at the moment, I can only merge information in the top bill - the bottom
one
stays blank. The next on the list then appears in the top half of another
sheet...

Any ideas would be gratefully acknowledged.

thanks and rgds

PT.