Word includes a very powerful mail merge feature. In order to take advantage of this feature, you need to create a main document. This document is the "template" or "boilerplate" for your finished document. It includes everything Word needs to create the finished document, including placeholders for the data that Word extracts from a data file.
A mail merge document is not complete, however, until you have also specified a data file that you want to associate with the main document. Exactly how you do this depends on the version of Word you are using.
To create your main mail merge document and attach a data source to it when using Word 2002 or Word 2003, follow these steps:
- If you want to use an existing document as the basis for your mail merge, load that document from disk.
- Choose Letters & Mailings from the Tools menu, and then Mail Merge Wizard from the resulting submenu. Word displays the Mail Merge task pane at the right side of the screen.
- From the list of available document types provided in the task pane, select the one that most closely matches the type of document you want to create. In most cases you will choose Letter, but you can also choose any of the other options.
- At the bottom of the task pane, click Next: Starting Document. The wizard's next step is displayed in the task pane.
- Specify what you want to use as you starting document for the mail merge. If you have a document open (such as the one mentioned in step 1), you should choose Use the Current Document. You can choose either of the other options (Start From a Template and Start From Existing Document) if they are more appropriate for what you are doing.
- At the bottom of the task pane, click Next: Select Recipients. The wizard's next step is displayed in the task pane.
- Specify where you want the merge data to come from. If you already have the list in a disk file of any type, choose the default of Use An Existing List. You can also choose Select From Outlook Contacts or Type a New List.
- At the bottom of the task pane, click Next: Write Your Letter. If you chose Use An Existing List in the previous step, Word displays the Select Data Source dialog box. This dialog box is very similar to a standard Open dialog box.
- Using the controls in the Select Data Source dialog box, locate the file you want to use for your data source, then click Open. Word displays the Mail Merge Recipients dialog box.
- Use the Mail Merge Recipients dialog box to make changes to which records are to be used in the merge and to modify the order in which the records are merged. When completed, click OK. The information in the task pane is updated to reflect your choices regarding the data source.
- At the bottom of the task pane, click Next: Write Your Letter. (Yes, this is the same thing you clicked in step 8. Go figure.)
If you are using an older version of Word (Word 97 or Word 2000) then the steps are quite a bit different:
- If you want to use an existing document as the basis for your mail merge, load that document from disk.
- Choose the Mail Merge option from the Tools menu. Word displays the Mail Merge Helper dialog box.
- Click on the Create button in step 1, Main Document. Word displays a menu of types of documents you can create.
- Using the drop-down menu, choose the type of document you want. In most cases you will choose Form Letter, but you can also choose any other of the other options (Mailing Labels, Envelopes, or Catalog).
- If you have a document open (such as the one mentioned in step 1), Word asks you if you want to use that document or if you want to create a new main document. Click on the button that is appropriate for what you are doing. Word updates the Mail Merge Helper dialog box to reflect your choice.
- On the Mail Merge Helper dialog box, click on the Get Data button in step 2, Data Source. Word displays a menu of sources you can use for your data.
- If you have an existing data source, such as a Word document or a database or spreadsheet file, you should click your mouse on Open Data Source. Otherwise, select one of the other options that reflect how you want to get your data.
- If you selected Open Data Source in step 7, you see an Open Data Source dialog box. Use the controls in the dialog box to locate the file you want to use for your data source. When you have done this, click on Open.
- Word informs you that you need to edit your main document because it could not locate any merge fields in it. Click on the Edit Main Document button.
At this point, you are ready to modify or type your main document. You will include merge fields in the document that indicate where you want the data from your data file to appear.
WordTips is your source for cost-effective Microsoft Word training.
(Microsoft Word is the most popular word processing software in the world.)
This tip (84) applies to Microsoft Word 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Word (Word 2007 and later) here: Beginning a Mail Merge.
Author Bio
Allen Wyatt
With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company. Learn more about Allen...
Searching for Characters
When using pattern matching in a search, you can specify individual characters or ranges of characters you want matched ...
Discover More
Dynamic Worksheet Tab Names
Need a worksheet's name to change based on the contents of a cell? You'll need to rely on a macro to do the changing, but ...
Discover More
Put Your Space Before or After?
When working with spacing between paragraphs, Word allows you to specify exactly how much space should be either before ...
Discover More
Speeding Up Mail Merges
The Mail Merge tool in Word is a great way to create new, customized documents. If you are doing a lot of merging, you ...
Discover More
Proper Comparisons for Dates in Merge Fields
How Word merges a data source with a document is controlled by merge fields. In those fields you may want to compare ...
Discover More
Using Merge Fields
When creating a mail merge document, you use merge fields to indicate where the information from each record of your data ...
Discover More
Comments