[Kevin Bilbee]

We have a merge document that used to start each new record on an odd
numbered page. We have recently upgraded from office 2000 to office 2007.
Some documents may spill over to a third page or even a fourth page during
the merge.


Is ther a way with Office 2007 to start each new record on an odd numbered
page so duplex printing works correctly.


Kevin Bilbee

[Doug Robbins - Word MVP]

Execute the mail merge to a new document and then use the
following macro to send that document to the printer:

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

That will cause each document to be sent to the printer as a separate print
job so that the duplexing should 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

"Kevin Bilbee" wrote in message
...
We have a merge document that used to start each new record on an odd
numbered page. We have recently upgraded from office 2000 to office 2007.
Some documents may spill over to a third page or even a fourth page during
the merge.


Is ther a way with Office 2007 to start each new record on an odd numbered
page so duplex printing works correctly.


Kevin Bilbee

[Kevin Bilbee]

Thank you for this suggestion. Our department running the merge has delete
their recent data run and fixed the document manually this week. When they
get new data they are going to save the merged document for me to play with.



Kevin Bilbee



"Doug Robbins - Word MVP" wrote in message
...
Execute the mail merge to a new document and then use the
following macro to send that document to the printer:

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

That will cause each document to be sent to the printer as a separate
print job so that the duplexing should 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

"Kevin Bilbee" wrote in message
...
We have a merge document that used to start each new record on an odd
numbered page. We have recently upgraded from office 2000 to office 2007.
Some documents may spill over to a third page or even a fourth page
during the merge.


Is ther a way with Office 2007 to start each new record on an odd
numbered page so duplex printing works correctly.


Kevin Bilbee