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.

if you can do it in a report - you can do it in a mailmerge-- justing thinking out loud
it might mean you need to use aggrigation fuctions and make tables -- these are not something i am evne halfway decent at --

In case you were still looking for an answer, see this example: http://cornell.veplan.net/article.aspx?&a=3815