I have an excel spreadsheet
Column A is the section. There are 2 values for the section P and W. I want the names with section P to be one area and the names with section W in another.
I tried using some mail merge rules: Next Record If
Next Record If Not Blank and Section Equal To P
When I do this, it shows all of the records in the P section, not separated.