Have you ever looked at Mail Merge???
You can specify an Access database, both Queries and Tables.
I like queries cause you can use Access to make a powerful form and then launch Word casue it does documentation better. But have you certian fields in Word doc that are variable and come from and Access query.
I had one applicaiton that used 75 fields in Access to a 7 page Word doc Proposal.
I wrote two FAQ's on it:
faq181-271
FAQ181-28
PS someone else wrote an FAQ on that too, but slightly different approach
faq181-453 DougP, MCP
FAQ181-453 would have been great a week ago - but i have now reinvented the wheel again!
With a very strict format and 7 queries I found all the standard methods too restrictive. I think I have used the easist method - by using a template - which holds all formatting (and tables and text boxes!) and populate each as required.
This works a treat - but is exceptionally slow. The data is there instantly - but the entry take minutes. I do not understand why this should be so slow.
I will take a closer look at FAQ181-453 to check out its speed - and any suggestions you have will be welcomed.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.