merge multiple details to word document

C

Chris

Hope someone can point me in the right direction to get started.Understand
the idea of merging access data to a word document using bookmarks etc.
However I would like to merge data from a quote form containg various
products with prices etc to a word document.

The quote form consists of the main form with quote details like quote
number, project name etc and then has a subform which allows the user to
select products with prices, discounts and totals which make up part of the
quote. Any quote could have from one to many products in it.

I would like to merge the main quote informaion and quote details to a word
document showing the quote details in a tabular form at some point within
the document. Appreciate if someone can point me how to get started.

Thanks
Chris
 
A

Albert D. Kallal

In my case, I simply made nice report, and then send that report to word.
while graphics formatting is lost when you convert a report to a word doc,
the sub forms, and data comes out very nice. So, build a report that looks
like the doc, include the summary, or details data in the details section of
the report.

The above I think produces the best results, and is the least hassle. I sued
the above idea many times t make quotes to word with "many" data in the word
doc. It was easy, and I just had to create a nice looking report.


Another way which is more work is to use automaton. There are some examples
at:

http://homepage.swissonline.ch/cindymeister/MergFram.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top