I have a spreadsheet witrh a total of 327 rows, these are showing teh details of duplicate claims of a service for a total of 93 pharmacies.

i need to create a mail merge with 1 letter to each pharmacy, showing all of the information regarding duplicate claims on the one page. Could anyone help me?

at the moment, im either create a MM for all 327 rows, in which several pharmacies then get many letters, or 1 each, but without all the relevent info on.

Am using 2007.

Many thanks.