View Single Post
  #12   Report Post  
Posted to microsoft.public.word.docmanagement,microsoft.public.word.mailmerge.fields,microsoft.public.word.pagelayout
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default How to Add blank page after every mail merge letter

{=MOD({PAGE},2) \# "{QUOTE 12};;"}

1. Don't change QUOTE 12 to QUOTE 1. The "12" means insert character
code 12, which is a page break.

2. Although I have been unable to generate a "!Missing operator" error
here (macropod may well be able to think of a reason why when he next
sees your message), things that might cause a syntax error include:
a. each pair of {} need to be the special field code braces that you
can insert using ctrl-F9. You can't just type them using the keyboard
b. If you have section formatting that outputs the result of { PAGE }
as anything other than a number (1,2,3), then the syntax may be wrong,
or there could be nother type of error. e.g. if your page numbers are
set up to be - 1 -,- 2 -, or A,B,C. In the unlikely event that you are
using chapter-page numbering, you may not get a syntax error but the MOD
calculation might be wrong, e.g. if you have 1-1, MOD will treat it as zero.
b. if your regional options (in Control Panel) are set up to use a
"List separator" that is not "," you will need to use that List
separator, e.g.

{=MOD({PAGE};2)}

instead of

{=MOD({PAGE},2)}


Peter Jamieson

http://tips.pjmsn.me.uk

On 07/01/2010 12:10, S N wrote:
I am trying the code given in a new document having single page
(modified QUOTE 12 to QUOTE 1).

Still I am getting the following error message and the resulting
document still contains only one page after print.

!Missing Operator

Please help

"macropod"
wrote in message ...
Hi SN,

So how many Sections per letter are there? With that information, you

could modify the macro print groups of Sections.

An alternative approach is to place the following field code at the

very end of the last Section in your mailmerge main document:
{=MOD({PAGE},2) \# "{QUOTE 12};;"}
What this will do is to insert a page break if the page on which it

occurs is an odd-numbered page.

Note: The field brace pairs (ie '{ }') for the above example are

created via Ctrl-F9 - you can't simply type them or copy & paste
them from this message.

--
Cheers
macropod
[Microsoft MVP - Word]


"S N" wrote in

message ...
The solution is not working.
Probably the problem is that the original single document also

contains many sections. Hence the macro is splitting the document
itself into many separate print documents, sometimes even when there

is no section breaks between them.
Please help with alternative solution.



"Doug Robbins - Word MVP"

wrote in message
...
Execute the merge to a new document, and then use a macro

containing the following code to do the printing

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

That will send each letter to the printer as a separate print job

and hence the duplexing will work correctly.

--
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, originally posted via msnews.microsoft.com

"S N" wrote in

message ...
I have a 11 page letter which I want to send to about a 100

different people. I am storing the addresses of all the 100 contacts
in a word file and am using mail merge to generate the 100 copies

of the letter addresses to each of the 100 contacts.
However, when I send the new mail merge document to print (duplex

printing on both side of page), it prints the first page of
the second letter pn the back side of the 11 page of the first

letter. I dont want this to happen.
Further if I add a blank page in my letter as the 12th page, the

total page count in the footer shows the count as 12 whereas
there are only 11 pages available and hence is incorrect.
What I want is that the footer should show the total pages as 11,

and after the 11th page the printed document should keep te
12th page as blank automatically. The first page of the next mail

merger letter (to the second recipient and so on), should
start from a fresh page and not print at the back side of the 11th

printed page (when duplex printing has been selected).

Kindly help.