Mail Merge Multiple Rows into one based on multiple columns

[cochranb13]

I am trying to create a mail merge that I can send to staff weekly that gives them individual data along with ONLY names of students that are failing. I have searched and found how to combine rows using one condition and a compare column, but I do not understand the syntax well enough to know how to include a second condition.



I have included screenshots below of data sheet, what I am getting when I run merge, what I want when I run merge, and what I have entered in merge.

 

[Macropod]

And I've already given you links to detailed instructions and examples for how to do that...

 

[cochranb13]

And I've already given you links to detailed instructions and examples for how to do that...

Yes, you have, and I apologize for my ignorance and ineptitude, but the Catalogue Mailmerge tutorial, which seems to be most directly linked to what I am trying to accomplish, does not make sense to me. In the tutorial, I am not clear how to enter the text from the tutorial into the Merge Document. For example, it is unclear to me when it says the text below produces the sorted list, where the text below is entered in the Merge Document.

[
«City» «Representative» «Sales»
]

In the sample document from the tutorial, there is a <<Recipients>> field and a <<Data>> field. But I cannot find in the tutorial where it says where to place the text above to achieve the sorted list.

The formula provided in the other post worked immediately and so I pursued that option.

 

[Macropod]

It seems, then, you haven't even read the Introduction, let alone any of the links demonstrating the implementation...