Our current system uses a many-to-many relationship to fill in the TO: address on outgoing emails from legasy workflow. So an example would be if the status on a lead changed to closed I send out emails to all persons related to this lead (a custom many-to-many relationship). Advanced Worflow doesnt have the ability yet to make use of many-to-many relationships to do this yet.
Does anyone have an idea how I might get around this? I was thinking about maybe making a new one-to-many relationship and tying it to a VIEW based on the many-to-many tableso that it would be up to date without extra SQL. Anyone got any better ideas?