Invoice Mail Merge with Master Detail Information

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Philip L Jackson - 07 Jul 2006 23:01 GMT

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

Reply to this Message

Peter Jamieson - 08 Jul 2006 08:45 GMT

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

> All
>
[quoted text clipped - 9 lines]
>
> Thanks in advance

Reply to this Message