Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Yossi Yossi is offline
external usenet poster
 
Posts: 1
Default How to do a Mail Merge from Access with 3 Tiers/Levels?

Hi,

I hope that Word can do this but I have no idea how this can be done.

Lets say I have an Access database with Customers, Invoices and Payments per
Invoice.

I want to create a mail merge document which would show for each Customer,
all their Invoices but within each Invoice, show all the Payments:

Customer 1
- Invoice 1
- Payment 1
- Payment 2
- Payment 3...
- Invoice 2
- Payment 1
- Payment 2
- Invoice 3 etc..

Customer 2
- Invoice 1
- Payment 1
- Invoice 2 (no payments)
- Invoice 3
- Payment 1

etc...

Each Customer, Invoice and Payment section has it's own special formating.

Understanding that Word may not be the medium to produce this output, can MS
Word do this in a mail merge or if not, how can this be accomplished?

Urgently looking forward to your comments,

Les
 
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
Mail Merge with Access Report (grouping levels equivalent) Jpod Mailmerge 4 September 27th 07 02:55 PM
Mail merge filters on office 2007 fail on multiple levels Michael Williams Mailmerge 0 July 18th 07 03:56 PM
Mail Merge .bmp from access? pope Mailmerge 2 February 16th 07 07:06 AM
word opens access in mail merge. Access is already opened.=twice Sherri Mailmerge 1 February 11th 06 05:59 PM
Mail Merge Grouping Levels Jeff Bendert Mailmerge 1 January 12th 05 03:27 AM


All times are GMT +1. The time now is 09:56 AM.

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"