hi There,
I have an access database, and I have successfully made a number of mail merges linking to it. These have been prity basic documents, mainly where there are only one record per page, or a list.
Now, I have a document i need, which i have created quite easily as a report, but I want to see if its possible as a mail merge.
It is basically a bill, which shows the persons name and address (table; Applicant), but also a list of which classes they have enrolled in (table; classes).
So, i could easily have a document which has each page containing the persons details, but the bit im not sure if you can do or not, is the listing of the classes they have signed up for as shown below. In the access report, it is ordered by the Applicant (group header yes), then the class name/
Person
Address
Postcode
________________
Class 1. Class Name
Class 2. Class Name
Class 3. Class Name
etc
Any thought?
Cheeas.
I have an access database, and I have successfully made a number of mail merges linking to it. These have been prity basic documents, mainly where there are only one record per page, or a list.
Now, I have a document i need, which i have created quite easily as a report, but I want to see if its possible as a mail merge.
It is basically a bill, which shows the persons name and address (table; Applicant), but also a list of which classes they have enrolled in (table; classes).
So, i could easily have a document which has each page containing the persons details, but the bit im not sure if you can do or not, is the listing of the classes they have signed up for as shown below. In the access report, it is ordered by the Applicant (group header yes), then the class name/
Person
Address
Postcode
________________
Class 1. Class Name
Class 2. Class Name
Class 3. Class Name
etc
Any thought?
Cheeas.