Invoice Mail Merge with Master Detail Information

[Philip L Jackson]

All

In one table I have a record which contains the master information for an
invoice (name address, totals etc)

In another table I have n records of line items to go on the invoice (stock
items)

How do I do this mail merge - I can see how for one but not how to get the
repeating line items.

Thanks in advance

 

[Peter Jamieson]

Word isn't designed to do this - if possible, use a Report generator
designed to do it (e.g. the one in Access).

Or try e.g.

http://www.knowhow.com/Guides/CompoundMerges/CompoundMerge.htm

which deals with a very similar requirement and/or

http://support.microsoft.com/default.aspx?scid=kb;en-us;211303

Peter Jamieson