Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
merge with Access can't find query | Microsoft Word Help | |||
Mail merge on an access query... | Mailmerge | |||
Merge with Access Query | Mailmerge | |||
Mail merge with Access DB does not see a query | Mailmerge | |||
Mail Merge from Access - How to retrieve linked data with a one to many relationship | Mailmerge |