Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #16  
Old 01-15-2023, 07:03 AM
Sloan149 Sloan149 is offline How to staple mail merged documents Windows 10 How to staple mail merged documents Office 2021
Novice
 
Join Date: Jan 2023
Posts: 3
Sloan149 is on a distinguished road
Default

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). 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.
Reply With Quote
  #17  
Old 01-15-2023, 12:43 PM
macropod's Avatar
macropod macropod is offline How to staple mail merged documents Windows 10 How to staple mail merged documents Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by Sloan149 View Post
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 View Post
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.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to staple mail merged documents Align Mail Merged Numbers to the Decimal Point HangMan Mail Merge 1 12-11-2013 02:32 PM
Insert Text between Mail Merged Items kawirider88 Mail Merge 1 09-29-2013 06:55 PM
saving a mail merged document after the user edits it. kosh2 Mail Merge 0 08-05-2011 03:35 AM
How to staple mail merged documents Overlapping text once mail merged Spartan300 Mail Merge 6 10-13-2010 06:14 PM
How to staple mail merged documents No toggle b/w 2 accounts; mail merged in 1 inbox Windwardman Outlook 1 06-09-2010 09:25 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:43 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft