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

Tips.Net > WordTips Home > Printing > Mail Merge > Using Unique Document Serial Numbers

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


Ultimate Library! An amazing resource that brings together, in one place, the collected knowledge of everything ever published in WordTips. The library combines two powerful elements to make you more productive: solutions and convenience. Here's where you get your own copy of everything ever published in WordTips.
 
Check out WordTips Ten-Year Library 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.)