ForEachRowinTable vs. ForEntireTable

[Scott_Hall]

I’m creating a report to send shipping labels for boxes scheduled to ship the next day however if I select “ForEntireTable” my expression below does not work.

AND([Date Next Service] >= Today(),ISNOTBLANK([Assigned To]))

The expression works if selecting “ForEachRowinTable” however that will send a separate email for each record. I don’t want to recieve 2 dozen individual emails, I’d rather only receive 1 email.

How would the expression be different to get it to achieve the desired result if selecting “ForEntireTable”?

Much appreciate any guidance.