Hi

Can anyone help this newbi to Access 2002.

I have generated a report which produces results of customers whose warranty is up for renewal.

I would like to bulk produce a standard letter that can be produced for each of those customers automatically which pulls information from each result (e.g. customer address, product, date warranty expires etc).

Can anyone help in supplying links, or pointing to previous threads or generally advising.

Anyhelp is very much appreciated.

Thanx

Build you report, including your customerid and a subreport for inside address, grouping by customerid so that a new page is geneated for each customerid.

How do I create a subreport?

Your customer infomation is probably in one table, product inforformation in another, and order information yet in another.

The order table would have keys or references to the customer and product tables (e.g. customerid and productid).

This way you could create a separate report with the customer information and drag it (from the database window) onto the design view of an order report. The customer portion of the report would be referred to as the "subreport." Depending on the version of Access you're using, you may have to set the Link Master Field and Child Master Field properties of the subreport. The Link Master Field is the customerid field (key) on your main report, and the Child Master Field is the corresponding customerid field on the subreport.

I suggest that you purchase a good Access book keyed to the version of Access you're using. It will have numerous examples.