Quote:
Originally Posted by Sloan149
I have 20 records with 80 pages each. I need every line from the mailmerge to print, but for this week, I only need pages 1-4 (of all 20 candidates), next week I’ll need pages 45-49 (of all 20 candidates).
|
In that case, send the merged output to a new document and print from that only the pages required.
Quote:
Originally Posted by Sloan149
Is there a line of code that can prompt me to indicate what pages out of the 80 I want to print, or get it to bring up the print dialogue box instead of just outputting right away when I run the macro.
|
No, since even a VBA-driven mailmerge has no data even to tell it what pages the records will be on until they are generated. In effect, the pages don't even exist until they are printed.
An alternative approach would be to delete all the unwanted pages from the mailmerge main document, then complete the merge, which will only send the retained pages for each record to the printer. Don't save the edited mailmerge main document after doing this, however.
01-15-2023, 12:43 PM
Similar Threads
Mailmerge to Individual Files Creating Extra Pages
Windows 10 
Office 2016
Hybrid Mode