"Page Numbering" Quirk with Merged Docs

[RacinMyLancer]

As stated, I'm experience a strange "page numbering" quirk with a merged
document.

Document: For simplicity's sake, we'll invent some easy numbers. I'm
creating a merged doc with 5 records from an Access Table. Each record is 10
pages, so I end up with a 50 page document. The "master" page number list
numbers the pages from 1-50. The "sub" page number list numbers the pages
from 1-10 5 times.

My Program: "Loops" through the different clients... establishes page ranges
(first pages 1-10 for the first record, then 11-20 for the next record, then
21-30, etc. etc.), then prints out those records, using my ranges, using the
"Printout" VBA method.

The Problem: It seems the "Printout" method doesn't know what to do with
"master" and "sub" page numbers when used with a range! My first record
(Pages 1-10) print out perfectly, but NO OTHER RECORDS beyond the first will
print! Remember that for the second record, we're dealing with a "master"
page range of 11-20, and a "sub" page range of 1-10. However, "Printout"
doesn't read the "master" page range (printing the correct pages), or the
"sub" page range (re-printing pages 1-10)... instead it seems confused... and
doesn't print anything at all!

Is this a bug? Is there another way for me to solve this page numbering
problem? (Note: Removing the sub-page numbering produces the desired result,
but I have the page-numbering in the footer of the doc... and I need it
numbered 1-10 on every doc, not 1-10 for the first, 11-20 on the second, etc.)

 

[Doug Robbins]

With 5 records, the document produced by the merge contains 5 sections, so
to print out a particular section, use specify the section number (in the
form s#) in place of the page number in the range to print.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

 

[Jezebel]

You're right that it's confusing. Two methods I've used --

1. Do the printing by section. Each record will be merged into its own
section, so if you enter "s2" into the print dialog page range, it will
print section 2, ie pages 11-20.

2. Save the document, delete the pages you don't want, then print the rest.

 

[RacinMyLancer]

Doug and Jezebel, thank you for your responses... I agree that "section"
printing gets me headed in the right direction.

There still exists one more issue...

My task requires several "sub"-prints within each section (Print the first 3
pages stapled, print the next 4 pages three-hole punched, etc. etc.). By
referring to the section as a whole, I've eliminated my ability to perform
these sub-prints.

Unless there's a way to refer to pages within a section with the "Range"
command.... ie. "Section 2, Pages 1-3 (or 11-13)." Is this possible? If not,
I may have to refer to Jezebel's secondary suggestion to "delete-n-print" in
order to move through the records. While probably effective, this is for
obvious reasons my second choice.

Thanks for the help so far, hope I can get this last issue ironed out.

 

[Doug Robbins]

p1s2-p3s2 will print the first three pages of Section 2. Get the picture?

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP