Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
jdgretz jdgretz is offline
external usenet poster
 
Posts: 1
Default 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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
merge with Access can't find query Keith G Hicks Microsoft Word Help 0 December 18th 07 08:15 PM
Mail merge on an access query... Warrio Mailmerge 2 September 16th 06 12:49 AM
Merge with Access Query rsw Mailmerge 8 June 12th 06 07:01 PM
Mail merge with Access DB does not see a query SarahB Mailmerge 8 November 29th 05 07:18 PM
Mail Merge from Access - How to retrieve linked data with a one to many relationship J Guerry Mailmerge 1 May 10th 05 09:12 AM


All times are GMT +1. The time now is 05:30 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"