bottom
Great WordTips!
         
Your e-mail address is safe!
Close Note

Tips.Net > WordTips Home > Printing > Mail Merge > Printing Portions of Mail Merged Documents

Printing Portions of Mail Merged Documents

Summary: When you merge data into a document, Word creates a large document that includes your source document over and over again. If you want to print only a portion of that large document, you may not get the results you desire—unless you know how to refer to individual parts of that document. This tip explains how to print just the portion you want. (This tip works with Microsoft Word 97, Word 2000, Word 2002, and Word 2003.)

When you use the mail merge feature of Word, you have the capability to either merge to the printer or to merge to a new document. Choosing the latter is often the best alternative, since you have the ability to inspect your output before actually printing.

What happens if you need to only print a portion of your merged documents, however? For instance, if your merged document takes 320 pages, and you only need to print the last 15 of them? You might think the answer to print only a range of pages, meaning pages 305-320.

If you try to do this with a mail-merged document, you will not get the expected result. In fact, you will get no result at all. This is because Word inserts a section break between each merged record it adds to your document. Thus, if you are printing 320 copies of a single-paged document, you have 320 page ones, not pages 1 through 320.

Sound confusing? It can be if you don't understand how sections work. Every time a new section is started, Word starts counting page numbers over again. To get around this problem, you have three alternatives. First, you can simply start deleting pages until you only have your desired pages remaining. (I call this the brute force method, and it is not always the best choice.) Second, you can simply replace all the section breaks in the merged document with line breaks. This is done by following these steps:

  1. Choose the Replace option from the Edit menu, or press Ctrl+H. Word displays the Replace tab of the Find and Replace dialog box. (Click here to see a related figure.)
  2. In the Find What box, enter ^b. This is the code for a section break.
  3. Click on the No Formatting button, if it is available. This removes any formatting specifications in what you are searching for. (You may need to click on the More button to see the No Formatting button.)
  4. In the Replace With box, enter ^m. This is the code for a page break.
  5. Click on the No Formatting button, if it is available. This removes any formatting specifications in what you are replacing with.
  6. Click on Replace All.

Now you can print as normal, entering a range of page numbers you want to print.

The third solution is perhaps the fastest and easiest, however. Simply remember that in your merged document you are working with sections, instead of pages. Thus, if you want to print out the form letter for records 305 through 320, you would follow these steps:

  1. Choose Print from the File menu. Word displays the Print dialog box. (Click here to see a related figure.)
  2. In the Pages box, enter s305-s320. Note the inclusion of the "s." This indicates you are specifying a section range, as opposed to a normal page range.
  3. Click on OK. Your desired information is printed.

Tip #1126 applies to Microsoft Word versions: 97 | 2000 | 2002 | 2003


Great Idea! Word is a tool to get what you really want—printed output. This means you need to make sure that Word works as well as possible with your printer, whether it is sitting on your desk or in a room down the hall.
 
Check out WordTips: Printing and Printers today!

Helpful Links

Ask a Word Question
Make a Comment

Tips.Net Home
Vital News Home

WordTips FAQ
WordTips Premium

Learn Access Now

Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips

Advertise on the
WordTips Site

 

Great Info!

Get tips like this every week in WordTips, a free productivity newsletter. Enter your e-mail address and click "Subscribe."
     
(Your e-mail address will never be shared with anyone, ever.)