[S N]

I am trying the code given in a new document having single page (modified QUOTE 12 to QUOTE 1).

Still I am getting the following error message and the resulting document still contains only one page after print.

!Missing Operator

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.

[S N]

I think the solution given by macropod would be simpler if successful
provided further that the additional blank page inserted by the macro does
not add to the count of the pages indicated in the footer of every page.

"Graham Mayor" wrote in message
...
When a merge is completed to a new document, the merged 'documents' are
separated by section breaks. Doug's macro splits the macro at the section
breaks into separate print tasks - which is what you describe as
happening. Are you saying that the document *before being merged* contains
multiple sections? If so, the macro requires modification to account for
the number of sections in the source document. The following will do that:

Dim i As Long
Dim iSect As Integer
iSect = InputBox("How many sections were there in the merge source
document?", _
"Split Merge To Printer", "1")
With ActiveDocument
For i = 1 To .Sections.Count Step iSect
.PrintOut Range:=wdPrintFromTo, _
From:="s" & i, _
To:="s" & i + iSect - 1
Next i
End With

Input the number of sections in the original document.at the prompt.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org





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

[S N]

I am trying the code given by macropod in a new document having single page
(modified QUOTE 12 to QUOTE 1).

Still I am getting the following error message and the resulting document
still contains only one page after print.

!Missing Operator

Please help

"Graham Mayor" wrote in message
...
When a merge is completed to a new document, the merged 'documents' are
separated by section breaks. Doug's macro splits the macro at the section
breaks into separate print tasks - which is what you describe as
happening. Are you saying that the document *before being merged* contains
multiple sections? If so, the macro requires modification to account for
the number of sections in the source document. The following will do that:

Dim i As Long
Dim iSect As Integer
iSect = InputBox("How many sections were there in the merge source
document?", _
"Split Merge To Printer", "1")
With ActiveDocument
For i = 1 To .Sections.Count Step iSect
.PrintOut Range:=wdPrintFromTo, _
From:="s" & i, _
To:="s" & i + iSect - 1
Next i
End With

Input the number of sections in the original document.at the prompt.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org





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

[S N]

!Syntax Error, ,



The above is the error that appears when I copy the code given by macropod
at the end of the 11 page document and run print.





"S N" wrote in message
...
I am trying the code given by macropod in a new document having single page
(modified QUOTE 12 to QUOTE 1).

Still I am getting the following error message and the resulting document
still contains only one page after print.

!Missing Operator

Please help

"Graham Mayor" wrote in message
...
When a merge is completed to a new document, the merged 'documents' are
separated by section breaks. Doug's macro splits the macro at the section
breaks into separate print tasks - which is what you describe as
happening. Are you saying that the document *before being merged*
contains multiple sections? If so, the macro requires modification to
account for the number of sections in the source document. The following
will do that:

Dim i As Long
Dim iSect As Integer
iSect = InputBox("How many sections were there in the merge source
document?", _
"Split Merge To Printer", "1")
With ActiveDocument
For i = 1 To .Sections.Count Step iSect
.PrintOut Range:=wdPrintFromTo, _
From:="s" & i, _
To:="s" & i + iSect - 1
Next i
End With

Input the number of sections in the original document.at the prompt.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org





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

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

[S N]

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.

[Doug Robbins - Word MVP]

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.

[S N[_2_]]

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.

[S N]

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.

[macropod[_2_]]

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.

[Graham Mayor]

When a merge is completed to a new document, the merged 'documents' are
separated by section breaks. Doug's macro splits the macro at the section
breaks into separate print tasks - which is what you describe as happening.
Are you saying that the document *before being merged* contains multiple
sections? If so, the macro requires modification to account for the number
of sections in the source document. The following will do that:

Dim i As Long
Dim iSect As Integer
iSect = InputBox("How many sections were there in the merge source
document?", _
"Split Merge To Printer", "1")
With ActiveDocument
For i = 1 To .Sections.Count Step iSect
.PrintOut Range:=wdPrintFromTo, _
From:="s" & i, _
To:="s" & i + iSect - 1
Next i
End With

Input the number of sections in the original document.at the prompt.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org





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

[Peter Jamieson]

{=MOD({PAGE},2) \# "{QUOTE 12};;"}

1. Don't change QUOTE 12 to QUOTE 1. The "12" means insert character
code 12, which is a page break.

2. Although I have been unable to generate a "!Missing operator" error
here (macropod may well be able to think of a reason why when he next
sees your message), things that might cause a syntax error include:
a. each pair of {} need to be the special field code braces that you
can insert using ctrl-F9. You can't just type them using the keyboard
b. If you have section formatting that outputs the result of { PAGE }
as anything other than a number (1,2,3), then the syntax may be wrong,
or there could be nother type of error. e.g. if your page numbers are
set up to be - 1 -,- 2 -, or A,B,C. In the unlikely event that you are
using chapter-page numbering, you may not get a syntax error but the MOD
calculation might be wrong, e.g. if you have 1-1, MOD will treat it as zero.
b. if your regional options (in Control Panel) are set up to use a
"List separator" that is not "," you will need to use that List
separator, e.g.

{=MOD({PAGE};2)}

instead of

{=MOD({PAGE},2)}


Peter Jamieson

http://tips.pjmsn.me.uk

On 07/01/2010 12:10, S N wrote:
I am trying the code given in a new document having single page
(modified QUOTE 12 to QUOTE 1).

Still I am getting the following error message and the resulting
document still contains only one page after print.

!Missing Operator

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.

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

[macropod[_2_]]

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.

[Doug Robbins - Word MVP]

In the footer of your mail merge main document, in place of the { page } of
{ numpages } that you now have, use

{ IF { PAGE } 12 "{ page } of { numpages }" "" }

That will suppress the page numbering on page 12.

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

[Doug Robbins - Word MVP]

Try going to the first page of your mail merge main document and via the
Page Setup dialog Sections tab, set the Section Start to Odd page. When you
do that, the first page of each document created by your merging will have
the Section start on an Odd page and if you merge to a new document (Edit
Individual Documents) and then do a duplex print of that document, I think
that a blank page should in inserted automatically.

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

[macropod[_2_]]

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.

[Doug Robbins - Word MVP]

Now that I have had the opportunity to try that, I can report that it did
not work.

--
Hope this helps,

Doug Robbins - Word MVP

Please reply only to the newsgroups unless you wish to obtain my services on
a paid professional basis.

"Doug Robbins - Word MVP" wrote in message
...
Try going to the first page of your mail merge main document and via the
Page Setup dialog Sections tab, set the Section Start to Odd page. When
you do that, the first page of each document created by your merging will
have the Section start on an Odd page and if you merge to a new document
(Edit Individual Documents) and then do a duplex print of that document, I
think that a blank page should in inserted automatically.

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

[macropod[_2_]]

hi SN,

In that case, you need to place a field like:
{SET Sec1Pages {SECTIONPAGES}}
in each Section's footer, changing the '1' to match the Section numbers. Then, in the last Section's footer, a field like:
{={PAGE}-Sec1Pages-Sec2Pages-Sec3Pages \# "'Page {PAGE} of {={NUMPAGES}-1}';;"}
with as many '-Sec#Pages' expressions as needed (I'm assuming you've used a NUMPAGES field for the 'Y' part of the 'X of Y'
numbering). With this field code, the last page in each letter (always an even-numbered page with the previous field coding) won't
be included in the page numbering.

--
Cheers
macropod
[Microsoft MVP - Word]


"S N" wrote in message ...
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.