• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Case Example

In the following example, you create a query with contact info and use it in a mail-merge Word document. The finished letter is shown in Figure 13.30.

1.
In the Database window, select tblCustomersSalutation.

2.
Choose Insert, Query. With Design View selected in the New Query dialog box, click OK.

3.
In the field list, click CustSalutation. Press Shift and click CustZIP. Drag the seven fields to the design grid and drop them.

4.
Click in the Criteria row of the CustState field and type ca.

This limits the recipients to only those customers who live in California.

5.
Choose File, Save. Name the query qryCaliforniaCustomers and click OK. Click View to see the records. Close the query.

6.
In the Database window, click Queries.

7.
Select qryCaliforniaCustomers. Choose Tools, Office Links, Merge It with Microsoft Office Word.

8.
In the first dialog box of the Mail Merge Wizard, check Create a New Document and then link the data to it. Click OK.

9.
If necessary, maximize the Word window. With Letters selected in the Mail Merge pane at the right, click Next, Starting Document.

10.
In Select Starting Document, Use the Current Document should be selected. Click Next, Select Recipients.

11.
In Select Recipients, Use an Existing List should be selected.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint