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.