#1
|
|||
|
|||
mail merge from access query or two tables
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 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Combine Records when Mail Merge from Access | Tom Pickles | Misc | 2 | 08-24-2010 06:00 PM |
Mail Merge--different connections of Access in Single Word File. | Goldenbird | Mail Merge | 3 | 06-12-2009 06:42 AM |
Mail Merge Query | kangabanga | Mail Merge | 0 | 09-25-2008 04:07 AM |
Word / Access - Mail Merge | ibuilders | Mail Merge | 0 | 07-30-2007 06:18 PM |
Access 2003 query with wildcards into Word 2003 mail merge | Poingdexter | Office | 1 | 10-30-2005 06:17 PM |