Word Mail Merge

[danikuper]

Simple question: how do you do a word mail merge when you have the following table structure:

table: Customers
customerID
customername
customeraddress

table: Invoices
customerID
invoice_no
invoice_total

It's a one-to-many relationship between those two tables and my letter in word needs to show all invoices for one customer? Example:

John Doe
123 Street
Boston, Ma 02042

List of invoices:
Invoice Total
0123 $45
0223 $55
0321 $10

Total: $110

If I create a query that gives me customer, address and invoice data word uses each invoice as a separate record in a separate page....

Is there an easy way out of this?

Thanks!
daniel

 

[Brianwarnock]

I can't think how to do this as aWord mail merge, but daft question, why not just do it asan ACCESS report?

Brian

 

[danikuper]

Word gives you more flexibility when formatting your text and playing with pages.... and also because the person that will run and modify the letter is not familiar with Access.

 

[database]

Word gives you more flexibility when formatting your text and playing with pages.... and also because the person that will run and modify the letter is not familiar with Access.

Hi danikuper,

I have a similar problem . I have one person who is assigned multiple topics and i want to merge it in word . But when I do, it shows one page for every record (topics) and thus if one person has 10 topics assigned, then it shows 10 pages.
What I think is that I need to group data. But do you knwo the solution to this problem?