To set up the question:
My report is intended to send an email (weekly on Monday) to:
- Contacts who have “Quote Reminder” selected in the list of options (enum list) in the column [Communications]
- Send a copy of the same email to anyone who uses the app with the [Select Role] of 'Admin" selected (enum) in the [Select Role] Column.
Here are the expressions I am using at this time.
TO: SELECT(Users[Email],CONTAINS([Select Role],“Admin”),TRUE)
BCC: SELECT(Contact[Email],CONTAINS([Communications],“Quote Reminder”),TRUE)
Email Body Here.
I received an email as an Admin that inserted (it appears) every name in the database after “Hi,” regardless of if “Quote Reminder” is actually selected.
Is the expression correct to restrict to just those with the “Quote Reminder” option selected and how can I keep it from inserting every person’s name in favor of just the recipient’s name?