Excel Mail Merge with Word

[bobder1]

I have an excel sheet with data and i need to merge into a word document. The data spans several rows. I need to stop the mail merge once the value in a specific field (column) changes. How do i code it so that a change in the set field will end the mail merge but if the value is the same as the prior value the mail merge continues?

Thanks

 

[Macropod]

Are you simply trying to group records, or to filter them? The former could, for example, put all records matching a particular value on one page, all those matching another value on a different page, and so on. The latter would only output those records matching a particular value.