Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How to Add blank page after every mail merge letter
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. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How to Add blank page after every mail merge letter
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. |
#3
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
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. |
#4
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
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. |
#5
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
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. |
#6
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
{=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. |
#7
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
I tried the code again and ran the mail merge.
The code automatically generated the 12th blank page after every 11th page. However, the footer on the 12th page appeared as Page 12 of 11 This is absurd. 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. |
#8
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
Hi SN,
DO NOT change 'QUOTE 12' to 'QUOTE 1'! The 'QUOTE 12' tells Word to insert a page break. As for your page numbering, issue, try doing a print preview before printing. If that doesn't work, post back and I'll give you a field code to suppress the page number on the last page. -- Cheers macropod [Microsoft MVP - Word] "S N" wrote in message ... I tried the code again and ran the mail merge. The code automatically generated the 12th blank page after every 11th page. However, the footer on the 12th page appeared as Page 12 of 11 This is absurd. 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. |
#9
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
In the footer of your mail merge main document, in place of the { page } of
{ numpages } that you now have, use { IF { PAGE } 12 "{ page } of { numpages }" "" } That will suppress the page numbering on page 12. -- 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 tried the code again and ran the mail merge. The code automatically generated the 12th blank page after every 11th page. However, the footer on the 12th page appeared as Page 12 of 11 This is absurd. 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. |
#10
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
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. |
#11
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
I think the solution given by macropod would be simpler if successful
provided further that the additional blank page inserted by the macro does not add to the count of the pages indicated in the footer of every page. "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. |
#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
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. |
#13
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. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cannot get a blank page in word -previous letter is locked in | Tables | |||
Mail merge inserts blank page | Mailmerge | |||
After merge a blank page is printing after each letter | Mailmerge | |||
Still getting a blank page between each letter. | Mailmerge | |||
Mail Merge same letter twice - diff addresses - on same page | Mailmerge |