Mailmerge print specified pages

Sloan149 · #1 01-13-2023, 08:55 AM

Regarding the macro in https://www.msofficeforums.com/mail-...documents.html, is there a way to ask what page range in this document you want to print out. I have a similar issue with a larger document that needs to be mail merge printed and stapled out, but there are times that I need to narrow down the range of pages.

Thanks!

macropod · #2 01-14-2023, 04:38 AM

Preferably, you'd use the mailmerge filters to output only the records you actually want to print. Otherwise, you can send the output to a new Word document, then tell your printer which Sections of the output document to print, by inserting the section references into the print dialogue (e.g. s2-s5,s7,s9-s11).

Sloan149 · #3 01-14-2023, 08:27 PM

Quote:

Originally Posted by macropod

Preferably, you'd use the mailmerge filters to output only the records you actually want to print. Otherwise, you can send the output to a new Word document, then tell your printer which Sections of the output document to print, by inserting the section references into the print dialogue (e.g. s2-s5,s7,s9-s11).

Thanks, but I was more referring to the macro code referenced above. For that code, it doesn’t bring out the print dialogue, and it does not ask what page ranges I want to print. Is there another couple line of codes that I can insert for it to ask me what range of pages I want to print?

macropod · #4 01-15-2023, 05:05 AM

As I said:

Quote:

Preferably, you'd use the mailmerge filters to output only the records you actually want to print.

If you want to be able to select only specific pages, you would have to send the output to a new Word document, then choose the pages from there.

Sloan149 · #5 01-15-2023, 07:03 AM

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.

macropod · #6 01-15-2023, 12:43 PM

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mailmerge to Individual Files Creating Extra Pages	cmt11	Mail Merge	2	04-21-2019 09:32 AM
Printing selected pages based on a MERGEFIELD.g. If MERGEFIELD=x then print pages 1,2,4 if MERGEFIEL	Richard.p	Word	3	04-21-2015 01:14 AM
can word: make variables, find appropriate pages, fill out pages with variables, print only those	20GT	Word VBA	1	10-15-2014 09:48 PM
Word Mailmerge wont print	aovc	Mail Merge	1	05-06-2011 05:29 AM
mailmerge with letters of a different numbers of pages	roel1972	Mail Merge	0	02-21-2011 11:45 AM