Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merge with Access Report (grouping levels equivalent) | Mailmerge | |||
Mail merge filters on office 2007 fail on multiple levels | Mailmerge | |||
Mail Merge .bmp from access? | Mailmerge | |||
word opens access in mail merge. Access is already opened.=twice | Mailmerge | |||
Mail Merge Grouping Levels | Mailmerge |