Hi iansan,

Before that data can be used for a mailmerge, the data for each record must all be on one line. At present, you have two (or more) lines per record. Where there are more than two lines per record, you need to have one line per item, with all of the customer information repeated on that line.

As for having one invoice per person, you can do that using a Directory/Catalog merge, but there is no way Word can tell you which customer an item should be invoiced to if the details aren't in the data.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]