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/showthreaded.pl?Number=731107
--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
jdgretz wrote:
[Quoted Text] > 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
|