We have a fancy network attached copier/printer that will do the folding and stapling of the pages of the booklet and we have made "bluewingedolive" wrote in message We am using Word 2010 to create a small (10 page) booklet that is to be sent to a number of people (about 200).
"with a data source attached to it" & vbCr & _ "It must be a letter type main document" & vbCr & _ MsgBox "The Active Document is not set up correctly." & vbCr & _ PrintOut Range:=wdPrintFromTo, From:="s" & j, to:="s" & j + i - 1 'MsgBox "This utility will execute your merge to a new document and then send each of the letters in that document to the printer as an individual print job so that the stapling function of the printer can be used." PS: I'm not the only person wrestling with this: My hope is that Word 2010 has made my script obsoleteĪnd I can forgo updating it to work with Word 2010. When I ran into this problem in the past (it must have been 7 or 8 years ago) I wrote a Python Script that interfaced to Word and stepped Word thorough doing a mail-merge one name at a time. We are aware of the "Edit individual documents" option under Finish and Merge - and it would be the right thing if only it was sent to the copier/printer rather than opened up for editing. Is there a way built into Word 2010 mail merge that will let us send each merged booklet to the copier/printer individually instead of one humongous file? The problem is that Word is sending the 3 documents to my copier/printer as one file rather than 3 individual files. The mail merge has worked correctly, and the collation Instead of the three booklets of 10 pages each, that we want. We create a test case with a mailing list of just three names and do the mail-merge. We want to mail-merge the names and mailing addresses onto each of my booklets, send them to our fancy copier/printer and let it do the folding and stapling for me on the 200 booklets in sequence as it currently does on a single booklet. Page the mailing address of the recipient. We have a fancy network attached copier/printer that will do the folding and stapling of the pages of the booklet and we have made the back This would allow you to easily use the GROUP BY capabilities that you seek.We am using Word 2010 to create a small (10 page) booklet that is to be sent to a number of people (about 200). There you can do many types of processing-just as you can with an SQL database-in order to create views of information (queries) that can be used as the source data for a Word mail merge. The other option is to forego Excel and place your data in a real database program, such as Access.
(Full information on some of these methods can be found on the ExcelTips site. There are numerous ways that you can work with your data, including the removal of duplicate records or using macros to condense duplicate records into a single record. This means that it may be best to examine the source and do any sorting, condensing, and selecting in the workbook before you do the merge. The merge feature generally takes information as it is fed from the source document. If you are doing any other type of merge (such as merging to letters or to labels), then you are pretty much out of luck. Mail Merge Form Letters 1) Open Word and create a new blank document 2) Type the letter with all needed text and formatting, leaving room for the data from the data source (example: name, address, etc.) 3) Click the Mailings tab 4) Click Start Mail Merge 5) Click Step-by-Step Mail Merge Wizard The Mail Merge task pane appears on the right.
#Office 2016 mail merge collate how to#
If you are doing that type of merge, you can find full information on how to group records at this Microsoft Office Support article: This is not something that can be easily done with Word's mail merge capabilities, with one exception: You can do it if you are doing a directory-type merge. She wants to "group" records so she can put all the records for a given individual into a single merge document. She notes that if she was using SQL she could use "GROUP BY" to make sure that all the records of a given individual were grouped together. Erin wants to do a mail merge using source data that is in an Excel worksheet where it is possible for a given individual to have multiple rows of data.