I have a Unique MS Access to MS Word Mail Merge Need.
I can create a single document in vba and save it
with a .dot template and multi recordsets
I need to create a mail merge
one word document with All the letters for All companies.
I will provide a .dot template and Access 2003 db with the working code
I need a developer to make it work like a mail merge document - instead of one document for a single company as it works now _ I want 1 mail merge document with all the companies in it - so it will all be in one file.
## Deliverables
I have a MS Access Table
tblCompanies
tblDirectors
1 to many (CompanyID)
tblOfficers
1 to many (CompanyID)
a Word Doc has a Bookmark in it - (CompanyName)
then the text of the letter
then a table with 1 row in a spec location (center)
this will show the directors
then more text
then another table for signatures Officers (far right)
Again - may be 1, 2, 3 or?
Sample Letter
------------------
company name
letter text
directorname
directorname2
directorname3
more text
___________________
officername 1
___________________
officername 2
-------
I need to put the list of dirs in the 1st table
inserting rows as needed
any company may have 1, 2, 3+ Directors
Then a List of Officers in the 2nd Table
I can create a single document
What i need is a mail merge document that has all the companies in one .doc file
I will provide the .dot template and a working database that generates the individual letter.