Home |
Search |
Today's Posts |
#12
Posted to microsoft.public.word.docmanagement,microsoft.public.word.mailmerge.fields,microsoft.public.word.pagelayout
|
|||
|
|||
How to Add blank page after every mail merge letter
!Syntax Error, ,
The above is the error that appears when I copy the code given by macropod at the end of the 11 page document and run print. "S N" wrote in message ... I am trying the code given by macropod 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 "Graham Mayor" wrote in message ... When a merge is completed to a new document, the merged 'documents' are separated by section breaks. Doug's macro splits the macro at the section breaks into separate print tasks - which is what you describe as happening. Are you saying that the document *before being merged* contains multiple sections? If so, the macro requires modification to account for the number of sections in the source document. The following will do that: Dim i As Long Dim iSect As Integer iSect = InputBox("How many sections were there in the merge source document?", _ "Split Merge To Printer", "1") With ActiveDocument For i = 1 To .Sections.Count Step iSect .PrintOut Range:=wdPrintFromTo, _ From:="s" & i, _ To:="s" & i + iSect - 1 Next i End With Input the number of sections in the original document.at the prompt. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Add blank page after every mail merge letter | Mailmerge | |||
How to Add blank page after every mail merge letter | Microsoft Word Help | |||
Mail merge inserts blank page | Mailmerge | |||
After merge a blank page is printing after each letter | Mailmerge | |||
Mail Merge same letter twice - diff addresses - on same page | Mailmerge |