I am automating a mail merge and need to include multiple records on
one document. I create the data source document with the following
fields:

ClientID
Account#

Some clientids will have more than one account, some will have only
one. In my merge document, I want to be able to list all of the
accounts for one client on one document instead of printing a new
document for each account. Any ideas on how to do this?

Thanks.