access class microsoft training - Access

Hi Sarah,

You can store the details of the letter in tables
So perhaps 2 tables, one containing the contact details for each recipient, then the letter details in another table. You could also do it ini just one table, depending on your DB structure.


Then use a query, if needed, to extract relevant data


Then create a report that looks like a letter.
So in the Detail section you would have the letter content in a text box or label control.

Perhaps in the page header, you could put the contact details.

Remember to force each record to appear on a new page, in the way you learnt on the intermedite course. (Under properties for the report itself).

Regards

Richard