[Kbrad32 via OfficeKB.com]

How to send mail merge document as a separate print job in Word? Any help
will be greatly appreciate.

Thanks,
Kbrad32

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...merge/200810/1

[Doug Robbins - Word MVP]

If you execute the merge to a new document and then run a macro containing
the following code, it will send each letter to the printer as a
separate print job, so that the printer can then do its thing as it does
when printing a single letter.

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


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

"Kbrad32 via OfficeKB.com" u47076@uwe wrote in message
news:8c1b4df5a5598@uwe...
How to send mail merge document as a separate print job in Word? Any help
will be greatly appreciate.

Thanks,
Kbrad32

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...merge/200810/1

[Kbrad32 via OfficeKB.com]

Thanks a bunch...do you know if you can adjust it to print 10 at a time? I
have over 1100 pages.

Doug Robbins - Word MVP wrote:
If you execute the merge to a new document and then run a macro containing
the following code, it will send each letter to the printer as a
separate print job, so that the printer can then do its thing as it does
when printing a single letter.

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

How to send mail merge document as a separate print job in Word? Any help
will be greatly appreciate.

Thanks,
Kbrad32

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...merge/200810/1

[Doug Robbins - Word MVP]

What to you want to do between each 10 letters?

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

"Kbrad32 via OfficeKB.com" u47076@uwe wrote in message
news:8c1bed41b4072@uwe...
Thanks a bunch...do you know if you can adjust it to print 10 at a time? I
have over 1100 pages.

Doug Robbins - Word MVP wrote:
If you execute the merge to a new document and then run a macro containing
the following code, it will send each letter to the printer as a
separate print job, so that the printer can then do its thing as it does
when printing a single letter.

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

How to send mail merge document as a separate print job in Word? Any
help
will be greatly appreciate.

Thanks,
Kbrad32

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...merge/200810/1

[Kbrad32 via OfficeKB.com]

I have my printer to print both sides...it's cookbook to be exact and I don't
know if there is there a way to include a message box to continue to print
the next group or end the print job...this may not be possible, but printing
all 1100 is overwhelming for my printer.

Doug Robbins - Word MVP wrote:
What to you want to do between each 10 letters?

Thanks a bunch...do you know if you can adjust it to print 10 at a time? I
have over 1100 pages.
[quoted text clipped - 17 lines]
Thanks,
Kbrad32

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...merge/200810/1

[Doug Robbins - Word MVP]

Try

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

The computer should not then send the next print job until the present one
is finished.

If you want to modify the macro between each batch, you could replace the
line

For i = 1 To .Sections.Count Step 1

with

For i = 1 to 50

then after the first 50 are printed, change it to

For i = 51 to 100

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

"Kbrad32 via OfficeKB.com" u47076@uwe wrote in message
news:8c1f87d08ab1d@uwe...
I have my printer to print both sides...it's cookbook to be exact and I
don't
know if there is there a way to include a message box to continue to print
the next group or end the print job...this may not be possible, but
printing
all 1100 is overwhelming for my printer.

Doug Robbins - Word MVP wrote:
What to you want to do between each 10 letters?

Thanks a bunch...do you know if you can adjust it to print 10 at a time?
I
have over 1100 pages.
[quoted text clipped - 17 lines]
Thanks,
Kbrad32

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...merge/200810/1

[Kbrad32 via OfficeKB.com]

I tried the the code and it works find but now it will print double sided. I
have my printing peferences set to duplexe so I wouldn't have to do it
manually. So I'm not sure whats going on there and I tried the modifications
and it will only print the first four pages no matter what # of page to print
(ie 51-100)...any suggestions?

Doug Robbins - Word MVP wrote:
Try

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

The computer should not then send the next print job until the present one
is finished.

If you want to modify the macro between each batch, you could replace the
line

For i = 1 To .Sections.Count Step 1

with

For i = 1 to 50

then after the first 50 are printed, change it to

For i = 51 to 100

etc.
I have my printer to print both sides...it's cookbook to be exact and I
don't
[quoted text clipped - 11 lines]
Thanks,
Kbrad32

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...merge/200810/1

[Doug Robbins - Word MVP]

The code is telling the computer to print the document 1 section at a time,
not any particular number of pages. Do you have more than one Section in
each letter?

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

"Kbrad32 via OfficeKB.com" u47076@uwe wrote in message
news:8c239bc17d31d@uwe...
I tried the the code and it works find but now it will print double sided.
I
have my printing peferences set to duplexe so I wouldn't have to do it
manually. So I'm not sure whats going on there and I tried the
modifications
and it will only print the first four pages no matter what # of page to
print
(ie 51-100)...any suggestions?

Doug Robbins - Word MVP wrote:
Try

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

The computer should not then send the next print job until the present one
is finished.

If you want to modify the macro between each batch, you could replace the
line

For i = 1 To .Sections.Count Step 1

with

For i = 1 to 50

then after the first 50 are printed, change it to

For i = 51 to 100

etc.
I have my printer to print both sides...it's cookbook to be exact and I
don't
[quoted text clipped - 11 lines]
Thanks,
Kbrad32

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...merge/200810/1

[Kbrad32 via OfficeKB.com]

My document as follow comes from a template that I created...it has 4 parts
that pull from Access db. The Recipe Name, Description, Ingredients and
Instructions. Every thing print fine, but if the recipe continues to the next
page it doesn't duplex.

Doug Robbins - Word MVP wrote:
The code is telling the computer to print the document 1 section at a time,
not any particular number of pages. Do you have more than one Section in
each letter?

I tried the the code and it works find but now it will print double sided.
I
[quoted text clipped - 38 lines]
Thanks,
Kbrad32

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...merge/200810/1

[Doug Robbins - Word MVP]

That is a setting of the printer, nothing really to do with Word.

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

"Kbrad32 via OfficeKB.com" u47076@uwe wrote in message
news:8c2412b77c2f9@uwe...
My document as follow comes from a template that I created...it has 4
parts
that pull from Access db. The Recipe Name, Description, Ingredients and
Instructions. Every thing print fine, but if the recipe continues to the
next
page it doesn't duplex.

Doug Robbins - Word MVP wrote:
The code is telling the computer to print the document 1 section at a
time,
not any particular number of pages. Do you have more than one Section in
each letter?

I tried the the code and it works find but now it will print double
sided.
I
[quoted text clipped - 38 lines]
Thanks,
Kbrad32

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...merge/200810/1

[Michael Cole]

Doug
Would gladly pay a fair sum if you can solve this problem.

Using Word-mail-merge to create a merge document of 8 pages, sent to HP9050dn printer, with multi-function finisher [bookletmaker]. Successful when sending only one record...merges/folds/staples just fine. when sending the complete merge file, it will attempt to merge every record into one giant booklet. I have tried your code:
"Dim i As Long
With ActiveDocument
For i = 1 To .Sections.Count Step 1
..PrintOut Range:=wdPrintFromTo, From:="s" & i, To:="s" & i
Next i
End With"
Have also tried "gmayer" code. Neither works in this situation.

Any ideas?
Thanks, Mike www.metroform.com






Doug Robbins - Word MVP wrote:

If you execute the merge to a new document and then run a macro containingthe
23-Oct-08

If you execute the merge to a new document and then run a macro containing
the following code, it will send each letter to the printer as a
separate print job, so that the printer can then do its thing as it does
when printing a single letter.

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


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

"Kbrad32 via OfficeKB.com" u47076@uwe wrote in message
news:8c1b4df5a5598@uwe...

Previous Posts In This Thread:

On Thursday, October 23, 2008 2:10 PM
Kbrad32 via OfficeKB.com wrote:

How to send each document as a separate print job in Word?
How to send mail merge document as a separate print job in Word? Any help
will be greatly appreciate.

Thanks,
Kbrad32

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...merge/200810/1

On Thursday, October 23, 2008 3:07 PM
Doug Robbins - Word MVP wrote:

If you execute the merge to a new document and then run a macro containingthe
If you execute the merge to a new document and then run a macro containing
the following code, it will send each letter to the printer as a
separate print job, so that the printer can then do its thing as it does
when printing a single letter.

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


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

"Kbrad32 via OfficeKB.com" u47076@uwe wrote in message
news:8c1b4df5a5598@uwe...

On Thursday, October 23, 2008 3:21 PM
Kbrad32 via OfficeKB.com wrote:

Thanks a bunch...do you know if you can adjust it to print 10 at a time?
Thanks a bunch...do you know if you can adjust it to print 10 at a time? I
have over 1100 pages.

Doug Robbins - Word MVP wrote:

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...merge/200810/1

On Thursday, October 23, 2008 5:50 PM
Doug Robbins - Word MVP wrote:

What to you want to do between each 10 letters?
What to you want to do between each 10 letters?

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

"Kbrad32 via OfficeKB.com" u47076@uwe wrote in message
news:8c1bed41b4072@uwe...

On Thursday, October 23, 2008 10:14 PM
Kbrad32 via OfficeKB.com wrote:

I have my printer to print both sides...
I have my printer to print both sides...it's cookbook to be exact and I don't
know if there is there a way to include a message box to continue to print
the next group or end the print job...this may not be possible, but printing
all 1100 is overwhelming for my printer.

Doug Robbins - Word MVP wrote:

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...merge/200810/1

On Thursday, October 23, 2008 11:38 PM
Doug Robbins - Word MVP wrote:

Try Dim i As Long With ActiveDocument For i = 1 To .Sections.
Try

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

The computer should not then send the next print job until the present one
is finished.

If you want to modify the macro between each batch, you could replace the
line

For i = 1 To .Sections.Count Step 1

with

For i = 1 to 50

then after the first 50 are printed, change it to

For i = 51 to 100

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

"Kbrad32 via OfficeKB.com" u47076@uwe wrote in message
news:8c1f87d08ab1d@uwe...

On Friday, October 24, 2008 6:01 AM
Kbrad32 via OfficeKB.com wrote:

I tried the the code and it works find but now it will print double sided.
I tried the the code and it works find but now it will print double sided. I
have my printing peferences set to duplexe so I wouldn't have to do it
manually. So I'm not sure whats going on there and I tried the modifications
and it will only print the first four pages no matter what # of page to print
(ie 51-100)...any suggestions?

Doug Robbins - Word MVP wrote:

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...merge/200810/1

On Friday, October 24, 2008 6:36 AM
Doug Robbins - Word MVP wrote:

The code is telling the computer to print the document 1 section at a time,
The code is telling the computer to print the document 1 section at a time,
not any particular number of pages. Do you have more than one Section in
each letter?

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

"Kbrad32 via OfficeKB.com" u47076@uwe wrote in message
news:8c239bc17d31d@uwe...

On Friday, October 24, 2008 6:55 AM
Kbrad32 via OfficeKB.com wrote:

My document as follow comes from a template that I created...
My document as follow comes from a template that I created...it has 4 parts
that pull from Access db. The Recipe Name, Description, Ingredients and
Instructions. Every thing print fine, but if the recipe continues to the next
page it doesn't duplex.

Doug Robbins - Word MVP wrote:

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...merge/200810/1

On Friday, October 24, 2008 3:44 PM
Doug Robbins - Word MVP wrote:

That is a setting of the printer, nothing really to do with Word.
That is a setting of the printer, nothing really to do with Word.

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

"Kbrad32 via OfficeKB.com" u47076@uwe wrote in message
news:8c2412b77c2f9@uwe...


Submitted via EggHeadCafe - Software Developer Portal of Choice
WPF GridView Sample To Insert, Update, and Delete Records
http://www.eggheadcafe.com/tutorials...ple-to-in.aspx

[Doug Robbins - Word MVP]

Hi Michael,

What happened when you tried running that macro? Did you have the
bookletmaker option selected in the printer properties before running the
macro?

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

"Michael Cole" wrote in message ...
Doug
Would gladly pay a fair sum if you can solve this problem.

Using Word-mail-merge to create a merge document of 8 pages, sent to
HP9050dn printer, with multi-function finisher [bookletmaker]. Successful
when sending only one record...merges/folds/staples just fine. when
sending the complete merge file, it will attempt to merge every record
into one giant booklet. I have tried your code:
"Dim i As Long
With ActiveDocument
For i = 1 To .Sections.Count Step 1
.PrintOut Range:=wdPrintFromTo, From:="s" & i, To:="s" & i
Next i
End With"
Have also tried "gmayer" code. Neither works in this situation.

Any ideas?
Thanks, Mike www.metroform.com






Doug Robbins - Word MVP wrote:

If you execute the merge to a new document and then run a macro
containingthe
23-Oct-08

If you execute the merge to a new document and then run a macro containing
the following code, it will send each letter to the printer as a
separate print job, so that the printer can then do its thing as it does
when printing a single letter.

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


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

"Kbrad32 via OfficeKB.com" u47076@uwe wrote in message
news:8c1b4df5a5598@uwe...

Previous Posts In This Thread:

On Thursday, October 23, 2008 2:10 PM
Kbrad32 via OfficeKB.com wrote:

How to send each document as a separate print job in Word?
How to send mail merge document as a separate print job in Word? Any help
will be greatly appreciate.

Thanks,
Kbrad32

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...merge/200810/1

On Thursday, October 23, 2008 3:07 PM
Doug Robbins - Word MVP wrote:

If you execute the merge to a new document and then run a macro
containingthe
If you execute the merge to a new document and then run a macro containing
the following code, it will send each letter to the printer as a
separate print job, so that the printer can then do its thing as it does
when printing a single letter.

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


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

"Kbrad32 via OfficeKB.com" u47076@uwe wrote in message
news:8c1b4df5a5598@uwe...

On Thursday, October 23, 2008 3:21 PM
Kbrad32 via OfficeKB.com wrote:

Thanks a bunch...do you know if you can adjust it to print 10 at a time?
Thanks a bunch...do you know if you can adjust it to print 10 at a time? I
have over 1100 pages.

Doug Robbins - Word MVP wrote:

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...merge/200810/1

On Thursday, October 23, 2008 5:50 PM
Doug Robbins - Word MVP wrote:

What to you want to do between each 10 letters?
What to you want to do between each 10 letters?

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

"Kbrad32 via OfficeKB.com" u47076@uwe wrote in message
news:8c1bed41b4072@uwe...

On Thursday, October 23, 2008 10:14 PM
Kbrad32 via OfficeKB.com wrote:

I have my printer to print both sides...
I have my printer to print both sides...it's cookbook to be exact and I
don't
know if there is there a way to include a message box to continue to print
the next group or end the print job...this may not be possible, but
printing
all 1100 is overwhelming for my printer.

Doug Robbins - Word MVP wrote:

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...merge/200810/1

On Thursday, October 23, 2008 11:38 PM
Doug Robbins - Word MVP wrote:

Try Dim i As Long With ActiveDocument For i = 1 To .Sections.
Try

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

The computer should not then send the next print job until the present one
is finished.

If you want to modify the macro between each batch, you could replace the
line

For i = 1 To .Sections.Count Step 1

with

For i = 1 to 50

then after the first 50 are printed, change it to

For i = 51 to 100

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

"Kbrad32 via OfficeKB.com" u47076@uwe wrote in message
news:8c1f87d08ab1d@uwe...

On Friday, October 24, 2008 6:01 AM
Kbrad32 via OfficeKB.com wrote:

I tried the the code and it works find but now it will print double sided.
I tried the the code and it works find but now it will print double sided.
I
have my printing peferences set to duplexe so I wouldn't have to do it
manually. So I'm not sure whats going on there and I tried the
modifications
and it will only print the first four pages no matter what # of page to
print
(ie 51-100)...any suggestions?

Doug Robbins - Word MVP wrote:

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...merge/200810/1

On Friday, October 24, 2008 6:36 AM
Doug Robbins - Word MVP wrote:

The code is telling the computer to print the document 1 section at a
time,
The code is telling the computer to print the document 1 section at a
time,
not any particular number of pages. Do you have more than one Section in
each letter?

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

"Kbrad32 via OfficeKB.com" u47076@uwe wrote in message
news:8c239bc17d31d@uwe...

On Friday, October 24, 2008 6:55 AM
Kbrad32 via OfficeKB.com wrote:

My document as follow comes from a template that I created...
My document as follow comes from a template that I created...it has 4
parts
that pull from Access db. The Recipe Name, Description, Ingredients and
Instructions. Every thing print fine, but if the recipe continues to the
next
page it doesn't duplex.

Doug Robbins - Word MVP wrote:

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...merge/200810/1

On Friday, October 24, 2008 3:44 PM
Doug Robbins - Word MVP wrote:

That is a setting of the printer, nothing really to do with Word.
That is a setting of the printer, nothing really to do with Word.

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

"Kbrad32 via OfficeKB.com" u47076@uwe wrote in message
news:8c2412b77c2f9@uwe...


Submitted via EggHeadCafe - Software Developer Portal of Choice
WPF GridView Sample To Insert, Update, and Delete Records
http://www.eggheadcafe.com/tutorials...ple-to-in.aspx