Hey guys,

We are trying to run a SOQL query to pull a list of email addresses, and then want to be able to draft and send an email to them.

We are basically copying the info from the visualforce developer guide and trying to adjust it to our data model, but are running into some issues in compiling the list of emails.(http://www.salesforce.com/us/developer/docs/pages/Content/pages_email_intro.htm)

Data Model:

We are trying to send this email from an opportunity.  Opportunities have a lookup to an object called the Panel Tool.  There is a junction object called "panelists" that links the panel tool to contacts, and so we are pulling the contact's emails via the soql query, and then trying to send to the list of emails.

This SOQL Query seems to work, but there could well be a better way.  We pulled the contact's email to the junction object via a formula field to try to simplify things, but the query works either way.

SELECT Name,(SELECT Name,Panelists_Email__c FROM Panelists__r) FROM Panel__c WHERE Id IN (Select Assigned_to_Panel__c FROM Opportunity WHERE Id= :ApexPages.currentPage().getParameters().get('id'))];

Here is the link to our code:

http://pastebin.com/fWEji9ry

Currently we are getting a compilation error: Invalid foreign key relationship: Panel__c.Assigned_to_Panel__r at line 22 column 25

Right now we don't really know how else to proceed, and would like some tips and/or feedback with our query/code.