Reply
 
Thread Tools Display Modes
  #1   Report Post  
electric
 
Posts: n/a
Default How to print mailmerge multipage with 1st page on diff paper

How can I print a multi page mail merge letter when the first page is on
letterhead and the second not?

When I try this with a large number of letters, only the first letter prints
correctly.
  #2   Report Post  
Doug Robbins
 
Posts: n/a
Default

If you run the following macro when the document created by executing the
merge is the active document, it will send the letter created for each
record to the printer as a separate print job.

Dim i As Long
With ActiveDocument
For i = 1 To .Sections.Count
.PrintOut Range:=wdPrintFromTo, From:="s" & i, To:="s" & i
Next i
End With

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
"electric" wrote in message
...
How can I print a multi page mail merge letter when the first page is on
letterhead and the second not?

When I try this with a large number of letters, only the first letter
prints
correctly.



  #3   Report Post  
electric
 
Posts: n/a
Default

Thanks for this. Unfortunately what happened is the first 2 page letter
printed correctly and the following pages all printed onto letterhead.
Regards
Jenny

"Doug Robbins" wrote:

If you run the following macro when the document created by executing the
merge is the active document, it will send the letter created for each
record to the printer as a separate print job.

Dim i As Long
With ActiveDocument
For i = 1 To .Sections.Count
.PrintOut Range:=wdPrintFromTo, From:="s" & i, To:="s" & i
Next i
End With

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
"electric" wrote in message
...
How can I print a multi page mail merge letter when the first page is on
letterhead and the second not?

When I try this with a large number of letters, only the first letter
prints
correctly.




  #4   Report Post  
electric
 
Posts: n/a
Default

I take it back. After a bit of playing around it does work. Thanks Doug.

"Doug Robbins" wrote:

If you run the following macro when the document created by executing the
merge is the active document, it will send the letter created for each
record to the printer as a separate print job.

Dim i As Long
With ActiveDocument
For i = 1 To .Sections.Count
.PrintOut Range:=wdPrintFromTo, From:="s" & i, To:="s" & i
Next i
End With

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
"electric" wrote in message
...
How can I print a multi page mail merge letter when the first page is on
letterhead and the second not?

When I try this with a large number of letters, only the first letter
prints
correctly.




Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Jump back from page (n) on print preview to that page in Word (n) Kenn Raymond Microsoft Word Help 1 August 24th 05 04:04 PM
Macro for print current page not always working Mike Page Layout 0 August 4th 05 05:11 PM
1st page turns into "odd" when # inserted tinhorn Page Layout 12 May 19th 05 01:18 PM
Why are my word documents only showing one page under print previe Frustrated73 Page Layout 2 March 27th 05 04:35 AM
Why does the border around a page not print? Is on screen, does . WMock Tables 1 November 24th 04 10:19 PM


All times are GMT +1. The time now is 08:10 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"