Works Suite 2001: How to Merge Data from Works Database to Word (269281)



The information in this article applies to:

  • Microsoft Works Suite 2001
  • Microsoft Works Suite 2000

This article was previously published under Q269281

SUMMARY

This article describes how to merge data from a Microsoft Works Database file or the Microsoft Windows Address Book into Microsoft Word 2000 with the Works in Word Add-in installed.

MORE INFORMATION

  1. Start Microsoft Word.
  2. Create a new document or open an existing one.

    To open an existing document, follow these steps:
    1. On the File menu, click Open.
    2. Locate the file that you want.
    3. Click Open.
  3. On the Tools menu, point to Mail Merge, and then click Document Type.
  4. In the Document Type dialog box, click Form Letter.
  5. Click OK.
  6. In the Open Data Source dialog box, click Merge from the Address Book to use names and addresses in the Windows Address Book, or click Merge information from another type of file to use names and addresses from a Works database.

    Note The Mail Merge toolbar appears near the top of the Word window. A toolbar is a row of buttons that you can click to perform an action, such as to print or save a document.
  7. Place the insertion point at the position that you want mail merge data to appear in your Word document.
  8. On the Mail Merge toolbar, click Insert Merge Field.
  9. Click the merge field that you want to insert.

    TIP If the Address Book is the data source (in Mail Merge, a file that contains fields such as names, addresses and other information that are merged into a document), you can click Address_Block to insert the name and address in one step.
  10. Add any spaces, punctuation, and paragraphs necessary to format the information correctly. For example, type a space between the merge fields for first name and last name.
  11. Repeat steps 7 through 10 until all the merge fields that you want are inserted.
  12. On the File menu, click Save.
  13. Type a name for the file in the File name box, and then click Save.
To review copies of the letter, follow these steps:
  1. On the Mail Merge toolbar, click View Merged Data.
  2. Click the arrows to review all copies of the letter.
You can filter or sort records in the data source to specify the order in which the data is merged, or to merge only part of the data.

To filter records, follow these steps:
  1. On the Tools menu, point to Mail Merge, and then click Filter and Sort.

    Note If you are prompted to use Microsoft Query to filter and sort data, click No.
  2. On the Filter Records tab, in the Filter On box, click the field you want to sort by.

    For example, if you want to sort the merge data by country, click Country.
  3. Select a comparison, and then type in the comparative data in the Compares to: box
  4. To further filter the data, select and or Or, and then repeat steps 4 and 5 in the next row of boxes.
  5. Click OK.
If the Address Book is your data source, you can use the Select Names option to include names and addresses that aren't easy to find using a filter. For example, if you want to send a letter to a group of friends with whom you attended a certain event, you can use Select Names to identify them.

Select Names is also useful if you do not have many names in the Address Book and you want to choose names quickly.

To use the Select Names filter, follow these steps:
  1. On the Tools menu, point to Mail Merge, and then click Select Names.
  2. In the Type name or select from list box, type the name of the person or group (a name representing a list of entries in an address book that can be used when sending e-mail to that list) that you want to include in your mail merge, or click the name in the list.
  3. Click Select.

    The name appears in the Merge Recipients list.
  4. Repeat steps 2 and 3 to add as many names as you want.
  5. Click OK.

Modification Type:MajorLast Reviewed:6/18/2003
Keywords:kbAddIn kbhowto kbinfo kbinterop KB269281