Merging from Access Query with one to many rocords

M

Mohammad Saeb

Dear All
I have a situation: I need to create a word documentwith access query as
record source. The query contains one to many records (suppliers and product
for example). How can I create such merged document in such a way , each
document contains ONE supplier and its corresponding MANY product.
Any ideas ...thanks
 
C

Cindy M -WordMVP-

Hi =?Utf-8?B?TW9oYW1tYWQgU2FlYg==?=,
How can I create such merged document in such a way , each
document contains ONE supplier and its corresponding MANY product.
Click to expand...
Word's mail merge doesn't really support this, but there are ways you
can get around it. Take a look at the short discussion in the mail
merge FAQ on my website. You'll find links to sample documents.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail :)
 

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

Similar Threads

Merging from an Excel file with graphics 1
Mail Merge skipping records/sending one at a time 0
Page numbering with Merged Document and IF statements 1
Adding data to MS Access from csv file 0
Start a mail merge upon opening the document 1
Integrating information from Word to Excel (not mail merge) 1
Some mail merge fields not pulling into document 2
Trying to create custom labels from an csv file + Need items numerically counted out 0

Top