We use a custom query task in Workflow for this exact thing, it queries a SQL for members in the table from the affected department(s), and then adding a "for each row" task, containing a token builder to add each row in the token "Recipient List" append value, then in the email task, that token is used in the To field, then in token dialogue use the Apply Index feature, and All Values Separated by "Semi-colon"