Mail Merge and Group

[arobart]

I am trying to do a mail merge and group records by one common field. Unlike this example in thread68-1083959

I "will" be doing a mail merge. My condensed example is as follows.

Data Base - 5 Records

Cust # Sfx # Address
1234 000 123 12 Mile Road
1234 001 456 12 Mile Road
1234 002 789 12 Mile Road
2345 000 321 13 Mile Road
2345 001 924 13 Mile Road

Results will hopefully produce 2 letters by Cust #, listing each location within that customer.

Merged Document - 2 Documents from Grouped Cust #, listing all locations within
1st Doc
Customer 1234
Locations 000 123 12 Mile Road
Locations 001 456 12 Mile Road
Locations 002 789 12 Mile Road
2nd Doc
Customer 2345
Locations 000 321 13 Mile Road
Locations 001 924 13 Mile Road


Any assistance would be appreciated. Thanks in Advance

Annette