If in the table Contacts, the column of enum list type [Communications] has the “Quote Reminder” value selected, I would like the report to send the contact an email.
Using this expression to no avail plugged into the “To” field in the report action.
SELECT((Contact[Email], IN[Communications], “Quote Reminder”), TRUE)
Any help would be appreciated. I’ll need to build 6 to 8 reports based on a variation of this expression.
Please and thank you.