Forum home » Delegate support and help forum » Microsoft Access Training and help » access class microsoft training - Access
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
access class microsoft training - Access
Resolved · Low Priority · Version Standard
Reply Wed 18 Jul 2007, 10:02Delegate Sarah said...
Sarah has attended:
Access Introduction course
Access Intermediate course
Access
How do I set up automatic letter generation for consultation for regen estates on the database?
For upcoming training course dates see: Pricing & availability
RE: 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
|