how do I get Word to recognize a merged file as seperate documents hiz5 10/16/2008 5:17:02 PM I have a 6 page Word document that I am using in a Merge. I have a merge field in the heading of the document that enters the name of the company from an Excel spreadsheet. When I merge the document and print it, Word is seeing my document as one large document instead of 200 individual letters, so I am not able to use the staple feature on the printer. What can I do to get Word to recognize 200 individual letters of 6 pages rather than one document of 1,200 pages? -- hiz5

Re: how do I get Word to recognize a merged file as seperate documents "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 10/16/2008 7:30:44 PM If you execute the merge to a new document and then run a macro containing the following code, it will send each 6 page letter to the printer as a separate print job, so that the printer can then do its thing as it does when printing a single letter. Dim i As Long With ActiveDocument For i = 1 To .Sections.Count Step 1 .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 "hiz5" <hiz5[ at ]discussions.microsoft.com> wrote in message news:2F885988-AB01-4968-9F8F-8A7141CF7B0F[ at ]microsoft.com... [Quoted Text] >I have a 6 page Word document that I am using in a Merge. I have a merge > field in the heading of the document that enters the name of the company > from > an Excel spreadsheet. When I merge the document and print it, Word is > seeing > my document as one large document instead of 200 individual letters, so I > am > not able to use the staple feature on the printer. What can I do to get > Word > to recognize 200 individual letters of 6 pages rather than one document of > 1,200 pages? > -- > hiz5

Re: how do I get Word to recognize a merged file as seperate docum hiz5 10/16/2008 9:07:01 PM Thank you. I will try it tomorrow. -- hiz5 "Doug Robbins - Word MVP" wrote: [Quoted Text] > If you execute the merge to a new document and then run a macro containing > the following code, it will send each 6 page letter to the printer as a > separate print job, so that the printer can then do its thing as it does > when printing a single letter. > > Dim i As Long > With ActiveDocument > For i = 1 To .Sections.Count Step 1 > .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 > > "hiz5" <hiz5[ at ]discussions.microsoft.com> wrote in message > news:2F885988-AB01-4968-9F8F-8A7141CF7B0F[ at ]microsoft.com... > >I have a 6 page Word document that I am using in a Merge. I have a merge > > field in the heading of the document that enters the name of the company > > from > > an Excel spreadsheet. When I merge the document and print it, Word is > > seeing > > my document as one large document instead of 200 individual letters, so I > > am > > not able to use the staple feature on the printer. What can I do to get > > Word > > to recognize 200 individual letters of 6 pages rather than one document of > > 1,200 pages? > > -- > > hiz5 > > >