Merge Selected Letters


Tutorial Home >Software >Office >Microsoft Office 2000 Projects >How do I merge selected form letter in Office 2000?
Tutorial Home >Software >Office >Microsoft Office 2000 Projects >Merged Form Letter >Merge Selected Letters

  Step 1:  Click the Merge Button

Open a Report
Let's run a merge that will produce only those letters containing "Atlanta" in the City field. Click the Start Mail Merge button on the Merge toolbar to go directly to the Merge dialog box.
  Step 2:  Click Query Options

Open a Report
Click Query Options to open the Query Options dialog box.
  Step 3:  Select the Query Field

Open a Report
Click the Field list arrow and then select the field containing the data you want to appear in each letter. Here I'm selecting the City field because I'm going to specify that only letters to people in Atlanta be merged.
  Step 4:  Enter Criteria

Open a Report
Click in the Compare to text box and then enter the required criteria. Here I've entered Atlanta.
  Step 5:  Run the Merge

Open a Report
Click OK and then click Merge to run the merge.
  Step 6:  Change the Zoom

Open a Report
Click View on the menu bar, click Zoom and then click the Many pages option button and select 3 pages as shown. I'm selecting 3 because I just happen to know that only three letters were addressed to people in Atlanta.
  Step 7:  View the Letters

Open a Report
Here's how the three merged letters appear.