[S N]

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.