I am using a mail merge to create specifically tailored letters which are
differing in page length and I wanted to know how to get each new letter to
print on an odd page such that each letter can be seperated so that they can
printed on duplex (front and back)
Thanks

Edit the template so it has two pages.

"Bevan" wrote in message
...
I am using a mail merge to create specifically tailored letters which are
differing in page length and I wanted to know how to get each new letter
to
print on an odd page such that each letter can be seperated so that they
can
printed on duplex (front and back)
Thanks

Thanks for the response Jezebel, but I aplogise for not being more specific.
I can't just insert another page as then the format of the rest of the
letters is changed.

What I have is a mail merged document which reads off an access database.
According to the database, if one field is "1" for instance, then the main
document once merged will then include an additional page of information
because of this entry of "1" in the database. This occurs with more than one
field to the point where for each record read from the database into Word
into the document from the access database, there could be anywhere from
11-20 pages.

What I was hoping to achieve is that regardless of how many pages each
record becomes, I wanted to be able to print off each new record on a new odd
page so that they can all be grouped properly in the same fashion such that
each group of letters anywhere from the 11-20 possible pages could be
seperated out and sent out in the same format rather than having the first
page fall on and be printed on an even numbered page and then through duplex
printing, having it printed on the reverse side of the last page from the
previous record.

I just want a new record always starting on an odd numbered page.

Hope that this doesn't sound too confusing, but I would have thought that it
would have been an easy thing to do and it might just be that I can't find
the function to do this.
Thanks for any assistance.

"Jezebel" wrote:

Edit the template so it has two pages.

"Bevan" wrote in message
...
I am using a mail merge to create specifically tailored letters which are
differing in page length and I wanted to know how to get each new letter
to
print on an odd page such that each letter can be seperated so that they
can
printed on duplex (front and back)
Thanks

OK, understand now. 'Page numbering' behaves strangely in mail merge
documents, as you might have found if you try to print a page range.

Suggest you think about this in a different way: rather than getting each
letter to start on an odd page, you want to find a way to get each page to
fill an even number of pages. Try this: at the end of the letter, insert a
field:

{ IF { = MOD({PAGE}, 2) = 1 "X" " " }

In place of X insert a next page section break. This inserts a next page
section break if the letter ends on an odd page, and a single space if on an
even page. Once you've created your merge output, select the entire document
and press F9 to update fields.




"Bevan" wrote in message
...
Thanks for the response Jezebel, but I aplogise for not being more
specific.
I can't just insert another page as then the format of the rest of the
letters is changed.

What I have is a mail merged document which reads off an access database.
According to the database, if one field is "1" for instance, then the main
document once merged will then include an additional page of information
because of this entry of "1" in the database. This occurs with more than
one
field to the point where for each record read from the database into Word
into the document from the access database, there could be anywhere from
11-20 pages.

What I was hoping to achieve is that regardless of how many pages each
record becomes, I wanted to be able to print off each new record on a new
odd
page so that they can all be grouped properly in the same fashion such
that
each group of letters anywhere from the 11-20 possible pages could be
seperated out and sent out in the same format rather than having the first
page fall on and be printed on an even numbered page and then through
duplex
printing, having it printed on the reverse side of the last page from the
previous record.

I just want a new record always starting on an odd numbered page.

Hope that this doesn't sound too confusing, but I would have thought that
it
would have been an easy thing to do and it might just be that I can't find
the function to do this.
Thanks for any assistance.

"Jezebel" wrote:

Edit the template so it has two pages.

"Bevan" wrote in message
...
I am using a mail merge to create specifically tailored letters which
are
differing in page length and I wanted to know how to get each new
letter
to
print on an odd page such that each letter can be seperated so that
they
can
printed on duplex (front and back)
Thanks

Alternative approach: I did a very quick test and this appears to work.

A letter merge in Word puts each rendition of the letter in a separate
section of one big file. The easy way would be to replace those Next Page
Section Breaks with Odd Page Section Breaks. But Find&Replace doesn't offer
that option and I'm not sure how a macro would do it.

It might work if you do a catalog or directory merge instead of a letter
merge, and put an Odd Page Section Break as part of the base document. For
catalog merges, Word does not put in a Next Page Section Break.

DM


On 1/30/05 4:41 PM, "Bevan" wrote:

Thanks for the response Jezebel, but I aplogise for not being more specific.
I can't just insert another page as then the format of the rest of the
letters is changed.

What I have is a mail merged document which reads off an access database.
According to the database, if one field is "1" for instance, then the main
document once merged will then include an additional page of information
because of this entry of "1" in the database. This occurs with more than one
field to the point where for each record read from the database into Word
into the document from the access database, there could be anywhere from
11-20 pages.

What I was hoping to achieve is that regardless of how many pages each
record becomes, I wanted to be able to print off each new record on a new odd
page so that they can all be grouped properly in the same fashion such that
each group of letters anywhere from the 11-20 possible pages could be
seperated out and sent out in the same format rather than having the first
page fall on and be printed on an even numbered page and then through duplex
printing, having it printed on the reverse side of the last page from the
previous record.

I just want a new record always starting on an odd numbered page.

Hope that this doesn't sound too confusing, but I would have thought that it
would have been an easy thing to do and it might just be that I can't find
the function to do this.
Thanks for any assistance.

"Jezebel" wrote:

Edit the template so it has two pages.

"Bevan" wrote in message
...
I am using a mail merge to create specifically tailored letters which are
differing in page length and I wanted to know how to get each new letter
to
print on an odd page such that each letter can be seperated so that they
can
printed on duplex (front and back)
Thanks

You would think you would be able to do it with Find and Replace. You can
search for section breaks (^b) and you can replace with the Clipboard
contents (^c). So if you convert one section break to an Odd Page one,
select it and Copy, then use ^c in the "Replace with" box, you'd think that
might work. Unfortunately, I just tried it, and it doesn't.

--
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.

"Daiya Mitchell" wrote in message
.. .
Alternative approach: I did a very quick test and this appears to work.

A letter merge in Word puts each rendition of the letter in a separate
section of one big file. The easy way would be to replace those Next Page
Section Breaks with Odd Page Section Breaks. But Find&Replace doesn't
offer
that option and I'm not sure how a macro would do it.

It might work if you do a catalog or directory merge instead of a letter
merge, and put an Odd Page Section Break as part of the base document.
For
catalog merges, Word does not put in a Next Page Section Break.

DM


On 1/30/05 4:41 PM, "Bevan" wrote:

Thanks for the response Jezebel, but I aplogise for not being more
specific.
I can't just insert another page as then the format of the rest of the
letters is changed.

What I have is a mail merged document which reads off an access
database.
According to the database, if one field is "1" for instance, then the
main
document once merged will then include an additional page of information
because of this entry of "1" in the database. This occurs with more than
one
field to the point where for each record read from the database into
Word
into the document from the access database, there could be anywhere from
11-20 pages.

What I was hoping to achieve is that regardless of how many pages each
record becomes, I wanted to be able to print off each new record on a
new odd
page so that they can all be grouped properly in the same fashion such
that
each group of letters anywhere from the 11-20 possible pages could be
seperated out and sent out in the same format rather than having the
first
page fall on and be printed on an even numbered page and then through
duplex
printing, having it printed on the reverse side of the last page from
the
previous record.

I just want a new record always starting on an odd numbered page.

Hope that this doesn't sound too confusing, but I would have thought
that it
would have been an easy thing to do and it might just be that I can't
find
the function to do this.
Thanks for any assistance.

"Jezebel" wrote:

Edit the template so it has two pages.

"Bevan" wrote in message
...
I am using a mail merge to create specifically tailored letters which
are
differing in page length and I wanted to know how to get each new
letter
to
print on an odd page such that each letter can be seperated so that
they
can
printed on duplex (front and back)
Thanks

Oh, I hadn't even thought of Clipboard contents. Just tried to mess around
with recording a macro, but got nowhere. Messed around some more. Finally
looked in VB Help, turns out it's really simple. They even had an example.

ActiveDocument.PageSetup.SectionStart = wdSectionOddPage

Will convert all the section breaks to odd page section breaks. If the
original poster is still around, see here for what to do with that:

What do I do with macros sent to me by other newsgroup readers to help me
out?
I don't know how to install them and put them to use
http://word.mvps.org/FAQs/MacrosVBA/CreateAMacro.htm

On 1/30/05 9:45 PM, "Suzanne S. Barnhill" wrote:

You would think you would be able to do it with Find and Replace. You can
search for section breaks (^b) and you can replace with the Clipboard
contents (^c). So if you convert one section break to an Odd Page one,
select it and Copy, then use ^c in the "Replace with" box, you'd think that
might work. Unfortunately, I just tried it, and it doesn't.

--
Daiya Mitchell, MVP Mac/Word
Word FAQ: http://www.word.mvps.org/
MacWord Tips: http://www.word.mvps.org/MacWordNew/
What's an MVP? A volunteer! Read the FAQ: http://mvp.support.microsoft.com/

On Sun, 30 Jan 2005 13:17:04 -0800, "Bevan"
wrote:

I am using a mail merge to create specifically tailored letters which are
differing in page length and I wanted to know how to get each new letter to
print on an odd page such that each letter can be seperated so that they can
printed on duplex (front and back)
Thanks

The easy way is to fix the main document before doing the merge. In
Page Setup, set "different odd/even headers" so that Word "knows" that
you are printing 2-sided, and set section start to "Odd Page".

Then do the merge and print the result.

Bob S