If you use the "2 pages per sheet" option (in Page Setup), you should be
using a Letter merge. Every page is a separate letter, and you should be
getting two "letters" per page. If you put have two labels AND two pages to
a sheet, you're going to have four of these things per page. If you're going
to do that, then you should be using 4-up labels.
--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site:
http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
"Jim McColl" wrote in message
news
Thanks very much for your replies
I tried both approaches suggested as well as a combo approach, (i.e. I set
it up as 2 to a page custom labels and also used Page/setup to indicate 2
pages per sheet.
All of these approaches still give me one query record per sheet i.e same
record appears on both labels in a sheet.
--
Jim McColl
"Suzanne S. Barnhill" wrote:
Although using 2-to-a-page "labels" would be the standard way to do this
in
any version of Word, Word 2000 and above offer another, simpler option.
Set
up your mail merge main document for "2 pages per sheet" (Portrait, in
the
Page Setup dialog, NOT in the Print dialog), and you can then use a
Letter
merge.
--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so
all may benefit.
"CyberTaz" typegeneraltaz1ATcomcastdotnet wrote in message
...
When you create your Main Document use either Labels or Directory as
the
document type rather than Letters... Letters implies that you want a
separate copy of the document for each recipient, so Word is repeating
the
data for each recipient into the corresponding copies of the fields on
your
one-page letter.
If you use Labels you can select any of the one-up/2 labels per page
formats
& perhaps get the results you are looking for even if you print to
plain
paper. OTOH, if you use the Directory feature it will give you more
layout
flexibility.
--
HTH |:)
Bob Jones
[MVP] Office:Mac
"Jim McColl" wrote in message
...
Greetings - I am trying to print application forms two to a page
lengthwise
using MS Office 2003 mail merge with an MS Access query as input. I
have
tried setting this up as a custom sized label, so I would get two on
each
page, one on the top half and one on the bottom half of the page.
The problem I am running into is that each label on a given page
uses
the
same record from the query.
Does anyone know a way to get two records to print on a single
sheet.
Thanks for any help
--
Jim McColl