'Advanced'(?) Mail merge w/ Access (1 Viewer)

loo8866

Registered User.
Local time
Yesterday, 22:28
Joined
Jan 11, 2007
Messages
106
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.
 

GaryPanic

Smoke me a Kipper,Skipper
Local time
Yesterday, 22:28
Joined
Nov 8, 2005
Messages
3,296
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 --
 

Users who are viewing this thread

Top Bottom