Word.Tips.Net Welcome toWord.Tips.Net

Helpful Links

Tips.Net Home
WordTips Home

Ask a Word Question
Make a Comment

Tips.Net Store

WordTips FAQ
WordTips Premium

Learn Access Now
Free Printable Forms

Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Legal Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips

Advertise on the
WordTips Site

Newest Tips

Setting Fraction Bar Overhang Spacing in the Equation Editor

Printing On Both Sides of the Paper

Turning Off AutoComplete for Dates

Ordering Search and Replace

Understanding Auto Line Spacing

Adding Comments to Your Document

Conditional Calculations in Word

 

Using Unique Document Serial Numbers

Summary: If you need to include serial numbers in your printed matter (labels, letters, documents, etc.), the best way is through the use of Word's mail-merge capabilities. This tip outlines how you can use this capability to get just the serial numbers you need. (This tip works with Microsoft Word 97, Word 2000, Word 2002, Word 2003, and Word 2007.)

There may be times you want to include a unique serial number in your documents, and the serial numbers much be specific and non-sequential. For instance, the first serial number could be X2417, the next one X2428, the third X2435, etc.

Assuming you know what serial numbers you need to use, the quickest way to handle this situation is to use the mail-merge features of Word to create your final documents. To do this, follow these general steps:

  1. Create a document that contains nothing but the serial numbers. Put the serial numbers in a table, one serial number per row. Make sure there is a header on the table, and the header is named something like "Serial Number."
  2. Load your target document, the one you want to contain the serial number.
  3. If you are using Word 97 or Word 2000, choose Mail Merge from the Tools menu to display the Mail Merge Helper dialog box. If you are using Word 2002 or Word 2003, choose Letters and Mailings from the Tools menu, then choose Mail Merge to display the Mail Merge task pane. If you are using Word 2007, choose Start Mail Merge from the Start Mail Merge group of the Mailings tab of the ribbon and then choose the type of merge you want to do.
  4. Go through the steps of specifying your main document (the one you loaded in step 2) and your data source (the one you created in step 1).
  5. In your main document, insert a merge field that indicates where you want the serial number to appear.
  6. Print your mail-merged documents.

The primary advantage of this approach is that you can use non-sequential serial numbers. You can also change the contents of your serial number file whenever you need a new batch of documents, and simply print again.

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

Create Rock-Solid Lists! Bulleted and numbered lists can help make your writing clearer and easier to follow. If not done properly, however, they can be a nightmare to work with. Discover the ins and outs of Word's lists with this great reference available in two versions.
 
Check out Word Bullets and Numbering today!