Print Current Page does not work

[Derek Y via OfficeKB.com]

Hello,

I have a mail merge document that is about 6,000 pages long. Within each
page there are about 5 sections. So when you get just a few hundred pages
into the document section numbers and whatnot are not even displayed. I
would simply just like to print the current page I have up of these 6,000
pages. I would preferably like a macro to do this (i have seen a bunch on
here and tried them all but they always send my entire document as a print
job).

Since I was getting nowhere with this, I thought maybe it would be a good
idea to use a macro to copy and paste the current page to a new document and
just simply print that new document. But since i have so many different
sections and my margins on the mail merged document are not the same as that
of the new document, those settings are not preserved.

Any help would be greatly appreciated.

Thanks

 

[Robert M. Franz (RMF)]

Hi Derek

I have a mail merge document that is about 6,000 pages long. Within each
page there are about 5 sections. So when you get just a few hundred pages
into the document section numbers and whatnot are not even displayed. I
would simply just like to print the current page I have up of these 6,000
pages. I would preferably like a macro to do this (i have seen a bunch on
here and tried them all but they always send my entire document as a print
job).

Since I was getting nowhere with this, I thought maybe it would be a good
idea to use a macro to copy and paste the current page to a new document and
just simply print that new document. But since i have so many different
sections and my margins on the mail merged document are not the same as that
of the new document, those settings are not preserved.

I'm sure there are clever ways through VBA to print such a document.
OTOH, I think it's a burden to start with this document in the first
place: why not just merge to new document (or printer directly) with a
couple (say, 100) records at a time, preferably through VBA?

Greetinx
Robert

 

[Jezebel]

You're right. MailMerge documents are almost impossible to deal with for
selective printing.

I'd go with RMF's answer: whatever your task, a 6000 page mailmerge document
is surely a poor solution. Rather than writing a macro to try to print
individual pages, why not write the macro to *create* the individual pages
you want? That's a much easier coding task, and would be a heap faster to
run.