Mail merge with multiple tables

[norty303]

I'm trying to print letters to contractors that give details of all their relevant contracts. The database is set up as a one-to-many relationship with each contractor having possible multiple contracts. I want to create letters that are headed up with each providers contact details and have a list of all their relevant contracts beneath rather than having to resort to sending an individual letter for each contract. Can I achieve this with mail merge in word?

Many thanks

 

[nberryman]

Probably easier to use a Report. Use the Report Wizard and check out the grouping and summary options.

I seem to remember another thread on the same theme and the reports worked for him



Neil Berryman
IT Trainer
neil_berryman@btopenworld.com