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...
Importing a Text File and Inserting after a Bookmark
Word macros are a great way to automate some of the ways in which you create documents. If you have a need to insert the ...
Discover More
Making Banners in Word
Word can be used for printing a variety of document types. You may want to use the program to print a festive banner for ...
Discover More
Switching Editing Location
Excel allows you to edit the contents of a cell in two places—the cell itself or in the Formula bar. If you want to ...
Discover More
Creating a Mail Merge Data File
An easy way to perform a mail merge starts with creating a data file in a Word document. This tip shows how you can ...
Discover More
Merging Formatted Data
Using the mail merge feature of Word, you can make data from Access databases accessible for your documents. How ...
Discover More
Wrong Values Merged from Excel
When you use an Excel workbook as a data source for your merged document, you may be surprised if what is merged doesn't ...
Discover More
Comments