A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Problem with duplexing



 
 
Thread Tools Display Modes
  #1  
Old March 26th, 2010, 03:59 PM posted to microsoft.public.word.mailmerge.fields
larryf
external usenet poster
 
Posts: 3
Default Problem with duplexing

We have a Home Equity form that we'd like to use with MailMerge to generate
duplexed filled-in copies. As an example, I should be able to enter three
sets of customer information, MailMerge them with the form to generate a
document that can be duplex printed. We have no problems merging the data
with the form, but printing the resulting file duplexed causes the beginning
of the second form to be printed on the back of the last page of the previous
form. We've tried inserting a blank page at the end of the Merge form, but
it is removed by the MailMerge process. We've tried all sorts of codes at
the end of the form to cause the next page to be printed on a new piece of
paper, but those are ignored as well. Does anyone have any suggestions on
how we can fix this?

Larry
  #2  
Old March 26th, 2010, 04:55 PM posted to microsoft.public.word.mailmerge.fields
Graham Mayor
external usenet poster
 
Posts: 18,297
Default Problem with duplexing

Fellow MVP Doug Robbins should come to the rescue with his macro to print
each letter pf a merge document as a separate print task.

Sub SplitMergeLetterToPrinter()
Dim Letters As Long, Counter As Long
Letters = ActiveDocument.Sections.Count
Counter = 1
While Counter Letters
ActiveDocument.PrintOut Background:=False, Range:=wdPrintFromTo, _
From:="s" & Format(Counter), to:="s" & Format(Counter)
Counter = Counter + 1
Wend
End Sub


--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




"LarryF" wrote in message
...
We have a Home Equity form that we'd like to use with MailMerge to
generate
duplexed filled-in copies. As an example, I should be able to enter three
sets of customer information, MailMerge them with the form to generate a
document that can be duplex printed. We have no problems merging the data
with the form, but printing the resulting file duplexed causes the
beginning
of the second form to be printed on the back of the last page of the
previous
form. We've tried inserting a blank page at the end of the Merge form,
but
it is removed by the MailMerge process. We've tried all sorts of codes at
the end of the form to cause the next page to be printed on a new piece of
paper, but those are ignored as well. Does anyone have any suggestions on
how we can fix this?

Larry



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:44 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.