[S N[_2_]]

Sorry, but it is not possible to reduce the number of sections, since I have
used different sections to isolate different layouts of pages - landscape
and portrait etc.
Without the section breaks, the layouts are not preserved differently as
desired.
Please advise considering the above restrictions.


"macropod" wrote in message
...
Hi SN,

For a single-Section letter, that's easy. But you've described your
mailmerge as using multi-Section letters. Is there any way you can reduce
the # Sections per letter to 1? If not, the field coding becomes somewhat
complex - especially since one has to avoid IF fields if the fields are to
survive a mailmerge.

--
Cheers
macropod
[Microsoft MVP - Word]


"S N" wrote in message
...
The procedure is giving me a document with 12th page generated
automatically. This is fine.
But the total number of pages shown in the footer is also showing as 12
in the manner Page 1 of 12, Page 12 of 12 etc.
What I want is that the 12th page should be generated but the count of
total number of pages shown in footer etc should remain at 11. The footer
should show as Page 2 of 11, Page 11 of 11 etc and not PAge 11 of 12,
PAge 2 of 12, Page 12 of 12.
Ideally the solution should be generic, i.e it should be independent of
the number of pages in original document before merge. The solution
should work for situation even of the number of pages initially in
document before merge are 5 or 7 or 11 or 50 whatever.


"macropod" wrote in message
...
Hi SN,

DO NOT change 'QUOTE 12' to 'QUOTE 1'! The 'QUOTE 12' tells Word to
insert a page break.

As for your page numbering, issue, try doing a print preview before
printing. If that doesn't work, post back and I'll give you a field code
to suppress the page number on the last page.

--
Cheers
macropod
[Microsoft MVP - Word]


"S N" wrote in message
...
I tried the code again and ran the mail merge.
The code automatically generated the 12th blank page after every 11th
page.
However, the footer on the 12th page appeared as
Page 12 of 11

This is absurd.

Please help.



"macropod" wrote in message
...
Hi SN,

So how many Sections per letter are there? With that information, you
could modify the macro print groups of Sections.

An alternative approach is to place the following field code at the
very end of the last Section in your mailmerge main document:
{=MOD({PAGE},2) \# "{QUOTE 12};;"}
What this will do is to insert a page break if the page on which it
occurs is an odd-numbered page.

Note: The field brace pairs (ie '{ }') for the above example are
created via Ctrl-F9 - you can't simply type them or copy & paste them
from this message.

--
Cheers
macropod
[Microsoft MVP - Word]


"S N" wrote in message
...
The solution is not working.
Probably the problem is that the original single document also
contains many sections. Hence the macro is splitting the document
itself into many separate print documents, sometimes even when there
is no section breaks between them.
Please help with alternative solution.



"Doug Robbins - Word MVP" wrote in message
...
Execute the merge to a new document, and then use a macro containing
the following code to do the printing

Dim i As Long
With ActiveDocument
For i = 1 To .Sections.Count
.PrintOut Range:=wdPrintFromTo, From:="s" & i, To:="s" & i
Next i
End With

That will send each letter to the printer as a separate print job
and hence the duplexing will work correctly.

--
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, originally posted via msnews.microsoft.com

"S N" wrote in message
...
I have a 11 page letter which I want to send to about a 100
different people. I am storing the addresses of all the 100
contacts in a word file and am using mail merge to generate the 100
copies of the letter addresses to each of the 100 contacts.
However, when I send the new mail merge document to print (duplex
printing on both side of page), it prints the first page of the
second letter pn the back side of the 11 page of the first letter.
I dont want this to happen.
Further if I add a blank page in my letter as the 12th page, the
total page count in the footer shows the count as 12 whereas there
are only 11 pages available and hence is incorrect.
What I want is that the footer should show the total pages as 11,
and after the 11th page the printed document should keep te 12th
page as blank automatically. The first page of the next mail merger
letter (to the second recipient and so on), should start from a
fresh page and not print at the back side of the 11th printed page
(when duplex printing has been selected).

Kindly help.