K
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
will be greatly appreciate.
Thanks,
Kbrad32
What to you want to do between each 10 letters?
[quoted text clipped - 17 lines]Thanks a bunch...do you know if you can adjust it to print 10 at a time? I
have over 1100 pages.
Kbrad32 via OfficeKB.com said: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.
What to you want to do between each 10 letters?
[quoted text clipped - 17 lines]Thanks a bunch...do you know if you can adjust it to print 10 at a time?
I
have over 1100 pages.Thanks,
Kbrad32
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.[quoted text clipped - 11 lines]I have my printer to print both sides...it's cookbook to be exact and I
don't
Kbrad32 via OfficeKB.com said: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
(ie 51-100)...any suggestions?
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.[quoted text clipped - 11 lines]I have my printer to print both sides...it's cookbook to be exact and I
don'tThanks,
Kbrad32
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?
[quoted text clipped - 38 lines]I tried the the code and it works find but now it will print double sided.
I
Kbrad32 via OfficeKB.com said: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.
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?
[quoted text clipped - 38 lines]I tried the the code and it works find but now it will print double
sided.
IThanks,
Kbrad32
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.