Merge Access Query w/many-to-one relationship

Here's the problem:
A client needs to send out letters to clients showing open invoices from
their organizations. A Access Report built from a Query does this just fine,
but it's not a Mail-Merged letter.

Master Company Record
Division name
Division invoice
Division invoice
Division invoice
:
Division 2 name
Division 2 invoice
:
Division 2 invoice

Works fine as an Access Report - also the report exports correctly to a
grouped Excel spreadsheet, but with each invoice on a separate line
mail-merge only picks up the first invoice instance. Using the Access query,
I get a separate letter for each invoice - not what the client wants. Client
wants a single letter to each Corporation or master company showing all the
invoices for that master record.

Ideas??

John

See How to use mail merge to create a list sorted by category -
http://support.microsoft.com/?kbid=294686

Fellow MVP 'macropod' has posted a tutorial on this, with working field
codes and a sample Excel data source, at:
http://www.wopr.com/cgi-bin/w3t/show...?Number=731107

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



jdgretz wrote:
Here's the problem:
A client needs to send out letters to clients showing open invoices
from their organizations. A Access Report built from a Query does
this just fine, but it's not a Mail-Merged letter.

Master Company Record
Division name
Division invoice
Division invoice
Division invoice
:
Division 2 name
Division 2 invoice
:
Division 2 invoice

Works fine as an Access Report - also the report exports correctly to
a grouped Excel spreadsheet, but with each invoice on a separate line
mail-merge only picks up the first invoice instance. Using the
Access query, I get a separate letter for each invoice - not what the
client wants. Client wants a single letter to each Corporation or
master company showing all the invoices for that master record.

Ideas??

John