Then perhaps you need to post your sample data and merge document so we can see what you are doing. Sorting the data shouldn't remove records - but filtering it might.

An alternative might be to link the Excel data into an Access Database and create a report that shows the data in the format you want it.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia