Microsoft KB Archive/258023

= Works Suite: How to Filter a Mail Merge Using Select Names =

Article ID: 258023

Article Last Modified on 1/27/2007

-

APPLIES TO


 * Microsoft Works Suite 2000
 * Microsoft Works Suite 2001

-



This article was previously published under Q258023



SUMMARY
When you use the Microsoft Windows Address Book for a Mail Merge in a Microsoft Word 2000 document, you can use the Select Names command to filter the Mail Merge data. That is, you can use the Select Names command to gather only the data that you want.



MORE INFORMATION
You can merge any of the data contained in the Windows Address Book. The following example merges name and address data onto a form letter, and then uses the Select Names command to filter the data to a select set of names.

A Windows Address Book containing nine names is used in this example: Amy, Charlie, and Charlton Anderson; Eric, Frank, and Geoff Miller; and James, Jeff, and Neil Smith.

To merge data from the Windows Address Book to a Word 2000 document and filter the data using the Select Names command, follow these steps:

 Start Word 2000, and then create the document to which you want to merge the Windows Address Book data. On the Tools menu, point to Mail Merge, and then click Document Type. In the Document Type dialog box, select Form Letter, and then click OK. In the Open Data Source dialog box, click Merge from the Address Book.

Note that the Mail Merge toolbar is now present. Position the insertion point at the upper left corner of the document. Click Insert Merge Field on the Mail Merge toolbar. Click First_Name.</li> Press the space bar, click Insert Merge Field, and then click Surname.</li> Press ENTER, and then insert Home_Address_Street.</li> Press ENTER, insert Home_Address_City, press the space bar, insert Home_Address_State_or_Province, press the space bar, and then insert Home_Address_Postal_Code.</li>  The top left of the document should look similar to the following: <pre class="fixed_text"><<First_Name>> <<Surname>> <<Home_Address_Street>> <<Home_Address_City>> <<Home_Address_State_or_Province>> <<Home_Address_Postal_Code>> </li> Click View Merged Data on the Mail Merge toolbar, and then click the Next Record and Previous Record buttons to confirm that all nine names and address are available.</li> On the Tools menu, point to Mail Merge, and then click Select Names.

The Select Names dialog box appears.</li> Use one of the following methods to filter (sort) the names: <ul> Method 1: Find a Single Name <ol style="list-style-type: lower-alpha;"> In the Select Names dialog box, in the box to the left of Find, begin to type the name of the person that you want.

In the example, type Fra. The name Frank Miller is highlighted.</li> When the person's name is highlighted, click Select to move the name to the Merge Recipients list.</li></ol> </li> Method 2: Select Names <ol style="list-style-type: lower-alpha;"> To select names from the Name list, click a name that you want (for example, Charlie Anderson), and then click Select.

Note that Charlie Anderson now appears in the Merge Recipients list.</li> Repeat this step to add Amy Anderson to the Merge Recipients list.</li></ol> </li> Method 3: Find a Group of Names <ol style="list-style-type: lower-alpha;"> To select a group of names with a common last name, click Find.</li> <li>Type Smith in the Name box, and then click Find Now.</li> <li>When the list appears with everyone named Smith, you can select the Smiths that you want with conventional Windows rules, (press CTRL to add names as you click them, or click a name and press SHIFT, and then click another name to add all the names in between the selections).</li> <li>Click James Smith, press SHIFT and click Jeff Smith, and then click Select. All the Smiths are added to the Merge Recipients list.</li></ol> </li></ul> </li> <li>Review the list of recipients to determine if anyone should be deleted. To delete a recipient, right-click the recipient's name, and then click Remove.</li> <li>After the list is complete and reviewed, click OK.</li></ol>

NOTE: Method 3 can be used to filter names by city. To filter names by city, type the city in the Address box, and then click Find Now.

NOTE: The sample companies, organizations, products, people and events depicted herein are fictitious. No association with any real company, organization, product, person or event is intended or should be inferred.

Additional query words: w_works works2k w2001

Keywords: kbaddin kbhowto KB258023

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.