Forms Auth, Sharepoint Group, Form Group, Workflow Email notification

Question

We have a publishing site using MOSS2007 that is using a Forms authentication and our own Membership and Role Provider

We want to have a workflow that sends emails to the Approvers sharepoint group when content is created in a list.

The problem we have is that we have to add our users directly to the Sharepoint 'Approvers' Group for the email's to be sent.

What we want to be able to do is add the custom Role to the Sharepoint group, and have any users who are granted that role in our custom role admin system to be emailed.

Sharepoint doesn't seem to be doing this

Sharepoint Group > Custom Group > CustomUser.email address traversal

Instead, it only seems to manage looking up.

Sharepoint Group > CustomUser.emailAddress

Answer 1

I take it this custom role / group resides within your custom membership and role provider. I'm a little rusty on this but SharePoint gets data like email addresses from its own profile store. You'll need to tell SharePoint where to get these email addresses from.