Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 02-08-2018, 08:55 AM
RookA1 RookA1 is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Feb 2018
Posts: 5
RookA1 is on a distinguished road
Default Hundreds of letters - print only the lead page on letterhead

Hello,

I have a mail merged document with hundreds of pages. Most of the letters are 3 pages long, but a few of them are 4 pages long. I want to print only the lead page of each letter on special letterhead.

What are some simple strategies for separating out the first pages of each letter, so that they may be printed on letterhead?



Re-doing the mail merge is not desirable, since the first pages were customized in many cases.

Thank you for your advice and please advice if more information is needed.
Rook
Reply With Quote
  #2  
Old 02-08-2018, 01:40 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 18,033
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

You should have configured your mailmerge main document with a 'different first page' layout and with only that page directed to your printer's letterhead bin. You will now need to either:
• do that for each letter within the output document; or
• manually send each letter's first page to your printer's letterhead bin and the other pages to its normal paper bin.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 02-08-2018, 02:29 PM
RookA1 RookA1 is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Feb 2018
Posts: 5
RookA1 is on a distinguished road
Default

Thank you, Paul.

I really should have thought of this sooner.

Knowing that only the lead pages have the date on the top, is there any way to do either of the following?:

1. Print only pages with the date from the merged document.
2. Move only pages with the date to a brand new document, which would be printed entirely on letterhead.
Reply With Quote
  #4  
Old 02-08-2018, 02:50 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 18,033
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Neither of those approaches would be easy. A macro might be used to configure each Section with a 'different first page' layout, but the code for telling Word which page goes to what bin is printer specific and depends on what paper bins/feeds are attached to the printer and how those are configured at the printer. That is where the real challenge lies. Such a macro might be coded along the lines of:
Code:
Sub Demo()
Dim Sctn As Section
For Each Sctn In ActiveDocument.Sections
  With Sctn.PageSetup
    .DifferentFirstPageHeaderFooter = True
    .FirstPageTray = wdPrinterUpperBin
    .OtherPagesTray = wdPrinterDefaultBin
    ' Depending on the printer configuration, you
    ' might need to swap the above bin definitions
    ' around or change them to any of:
    ' wdPrinterPaperCassette
    ' wdPrinterAutomaticSheetFeed
    ' wdPrinterLowerBin
    ' wdPrinterMiddleBin
    ' wdPrinterLargeCapacityBin
  End With
Next
End Sub
Note all the commented out alternative variables that might apply...

For PC macro installation & usage instructions, see: http://www.gmayor.com/installing_macro.htm
For Mac macro installation & usage instructions, see: https://wordmvp.com/Mac/InstallMacro.html
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #5  
Old 02-08-2018, 02:59 PM
RookA1 RookA1 is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Feb 2018
Posts: 5
RookA1 is on a distinguished road
Default

I see - wow. I'm afraid macros are a bit out of my pay grade - at least in terms of what I could learn by tomorrow morning (deadline). Would your answer change if I added that there is only one printer involved - not one bin for letterhead and one bin for other sheets?
Reply With Quote
  #6  
Old 02-08-2018, 03:06 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 18,033
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

The answer doesn't change, because I can't tell you what Word would recognise your printer bins as - that all depends on how your printer is configured. The only other option you've got is to manually print the first page of each section to the letterhead bin, which you'd do by inputting specs like:
p1s1, p1s2, p1s3, p1s4, p1s5 …
to get all the first pages, then manually print the other pages of each section to the non-letterhead bin, which you'd do by inputting specs like
p2-3s1, p2-3s2, p2-4s3, p2-3s4, p2-3s5 …
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #7  
Old 02-08-2018, 03:07 PM
RookA1 RookA1 is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Feb 2018
Posts: 5
RookA1 is on a distinguished road
Default

Roger that. Going to see if I can make this happen.

Cheers,
Reply With Quote
  #8  
Old 02-13-2018, 11:08 AM
RookA1 RookA1 is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Feb 2018
Posts: 5
RookA1 is on a distinguished road
Default

For anyone who comes across this problem in the future, I converted to PDF, since I could more readily manipulate the pages:

1. Convert document to PDF
2. In Adobe Acrobat, make sure that all letters are the same number of pages (if a few letters are shorter or longer, extract them into a separate document(s) for now.)
3. Use the Organize Pages tool in Adobe Acrobat
4. Zoom in/out until all of the first pages line up in one even column.
5. Click and drag to select all first pages.
6. Print selection

Regards,
Reply With Quote
Reply

Tags
letterhead, print specific pages, separate pages

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Template opens with userform ; non-checked boxes should lead to deletion of corresp paragraphs samszaf Word 1 09-07-2015 09:52 AM
want to make letterhead template with second page blank William Whitney Word 4 06-20-2014 05:59 AM
Specialty paper template - print around preprinted letterhead Jennifer Murphy Word 3 12-26-2013 07:57 PM
Hundreds of Docs quarkrad Office 5 01-15-2012 02:27 PM
Letterhead to appear on each page of word doc? silawtz Word 1 07-28-2011 08:21 AM


All times are GMT -7. The time now is 09:58 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft