How do I print a Mail Merge Doc with letterhead every other page?

holmep

New Member
Joined
Oct 7, 2010
Messages
4
Hi,

I am hoping someone might be able to point me in the correct direction. Does anyone know how to print a mail merged doc (approx. 200 pages/100 letters) so the company letter head is on every other page and that would come out of a different printer tray?

We are using Office 2010.

Many thanks in advance,
Paul
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
Hi Paul,

Configure your mailmerge main document to use a 'Different first page' layout and to draw the first page from the letterhead tray and the second page from the standard paper tray. These attributes should carry through to the output document.
 
Upvote 0
Hi,

Many thanks for your reply, How would we configure the document to use a 'Different first page' layout.

Many thanks
Paul
 
Upvote 0
Hi Paul,

Click on Layout|Page Setup > Layout > Different First Page. This allows you to define different margins (eg top/bottom) for the first page to accommodate the space required for the letterhead). Then, before dismissing the Page Setup dialogue box, click on Paper tab and choose the appropriate trays for the first page and other pages, respectively.
 
Upvote 0
Hi,

Thanks for the suggestion, how would word know that page 1 would need to be on Company headed paper, Page 2 on Plain, 3 or Company headed 4 plain etc.?


Word has taken the 200 pages (that is 100 Letters in total) and put it into one massive document.

I really appreciate your help on this, just trying to get my head round it
:)

Many thanks in advance,
Paul
 
Upvote 0
Hi Paul,

In theory, the Section breaks that Word uses to delineate each mailmerge output record should tell the printer to apply the settings.
 
Upvote 0
Hi,

Thanks for the reply. We have tried adding the section break into the document, however only the first page comes out on headed paper.

The only way i can think of doing this is splitting up the merged document into multiple print jobs, that’s going to take some time, or printing only the first page of the letters, 1 3,5,7 ..... And then all the evens, and getting someone to then put together.

Thank you again for your time

Many thanks
Paul
 
Upvote 0
Hi Paul,

You don't put a Section break into the document - all you should need is the different first page & print setup configuration (especially the latter). Word inserts whatever Section breaks are required during the merge.
 
Upvote 0
I got it to print the first page on letterhead by using the method described, but my problem is that it doesn't print the second page on the back side!

I have a four page letter and want to merge it in such a way that the first page prints on letterhead (from a separate tray) with the second page on the back and the third and fourth pages print on plain paper (for each letter in the merge).

Can I do this?

Thanks!
 
Upvote 0
Guess what? After experimenting with all the print settings in the book, I finally found a combination that works!

Set the Different First Page properties as explained above, then when you get to the print dialog box, select Printer Properties. Set Duplex to double-sided (open to left) and, on the Paper tab, select Paper Selection, Front Cover. Then for the Front Cover Input Tray select your letterhead tray and the Both Sides option.

It will get the "reset" each first page from the Page Settings and the double-sided part from the Printer Settings.
 
Upvote 0

Forum statistics

Threads
1,225,613
Messages
6,186,003
Members
453,334
Latest member
Prakash Jha

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top