Going mad....


I have two tables. (brilliant so far!)

The first is a typical client table or excel worksheet (tblClients in access) with the usual stuff in it like name address etc that you would create to form the basis for title, first name last name and address information to insert into a ms word letter. just like the fuzzy green thing!

The second is a document archive table (tblDocumentsHeld in access) where the clients listed above, store any number of documents. As a legal practice this could be wills, powers of attorney etc. One client can therefore have many documents in this table. (no great shakes so far)


I am trying to create a merge letter in word 2007 that is going to take the client information and insert this as the header, address and greeting based on word merge fields from the access data source. No problem here!

Here the trauma starts...
Also I would like in the same letter to let the clients know what documents they have in the archive.

eg
Mr John Citizen
12 Long Road
Blah Blah
OUTER WEST TIMBUCKTOO
4217
(All this stuff comes from tblClients)

Dear Mr Smith (Greeting from tblClients)
We hold the following documents (from tblDocumentsHeld, based on the ClientID)
1. Will
2. Power of attorney
3. Bank bonds

Stuck, Stuck, Stuck!!!!!!!!
Please anyone who cares about taking a humble crazed person out of the doldurms, you're more than welcome to lend a helping hand...CAUSE I AM GASPING FOR ADVICE