Grouping records by supplier

[Franci]

Hi!

Is there a way to merge multiple fields from a database into the body of a letter in Word, grouped by the supplier and listing all supplier's items, like shown in the example belove?

Supplier 1
Address 1



..... some text here.....
Item 1 is approved for use
Item 2 is approved for use
Item 3 is not approved for use
.
.
.
Item xx (all items of the supplier listed here)

....some text here....

The database consists of the following fields:
Supplier name
Supplier address
Item name
Approval

Supplier Name Supplier Address Item Name Approval
Supplier 1 Address 1 Item 1 approved for use
Supplier 1 Address 1 Item 2 approved for use
Supplier 1 Address 1 Item 3 not approved for use
Supplier 2 Address 2 Item 1 approved for use
Supplier 3 Address 3 Item 1 approved for use
Supplier 3 Address 3 Item 2 not approved for use
.
.
.
.
Supplier XX Address XX Item XX not approved for use