Word Automation Data Sources

[Joe]

Hi,

My customer wants me to generate an invoice from data
contained in MS Access. He has a Microsoft Word - based invoice that
he currently uses and wants the new system to use the same document.
So I intend to use Word Automation and MailMerge to meet the
requirement.

Some of the information on the invoice is name, address, city,
state, zip - one record per invoice, no problem. But he also has a
detailed section of the invoice that will contain multiple line
items. So there will be multiple records per invoice for that part.

Question: Can one Word document have more than one MS Access-
based data source? I am thinking that it will require two separate
queries to populate one invoice. All of the documentation that I have
found on this topic seems to suggest that only one data source is
allowed.

Also - anyone know a good book on MS Access - MS Word
automation?


Any help appreciated,
Joe

 

[pietlinden]

Hi,

My customer wants me to generate an invoice from data
contained in MS Access. He has a Microsoft Word - based invoice that
he currently uses and wants the new system to use the same document.
So I intend to use Word Automation and MailMerge to meet the
requirement.

Some of the information on the invoice is name, address, city,
state, zip - one record per invoice, no problem. But he also has a
detailed section of the invoice that will contain multiple line
items. So there will be multiple records per invoice for that part.

Question: Can one Word document have more than one MS Access-
based data source? I am thinking that it will require two separate
queries to populate one invoice. All of the documentation that I have
found on this topic seems to suggest that only one data source is
allowed.

Also - anyone know a good book on MS Access - MS Word
automation?

Any help appreciated,
Joe

There's an example of how to do this in Access Developer's Handbook,
Desktop Edition. Kinda pricey, but well worth the money. (Read
reviews at Amazon.com... don't take my word for it.)

Pieter