Hello 

I am trying to create an e-mail template to send contacts an e-mail about product information using a visual force page.

I can send them the information such as the Product ID, the Quantity and the last date it was modified, but I can't send them the product 'NAME' as the name is not stored int he OpportunityLineItems Object

Is there a way to insert a join between OpportunityLineItems and Product2 based off the PricebookentryID to show insert the Product Name next to the Database ID?

Below is my code

Thank you

<messaging:emailTemplate subject="pd2" recipientType="Contact" relatedToType="Opportunity"><messaging:HtmlEmailBody ><center><table border="0">


 <tr>     <th>Product</th>     <th>Quantity</th>     <th>Last Modified Date</th>
 </tr>


<apex:repeat var="cx" value="{!relatedTo.OpportunityLineItems}"><tr>    <td>        <a href="https://na4.salesforce.com/{!cx.id}">{!cx.Description} </a>    </td></tr>     <td>{!cx.PRICEBOOKENTRYID}</td>     <td>{!cx.Quantity}</td>     <td>{!cx.LastModifiedDate}</td>
</tr>     </apex:repeat>


</table></center></messaging:HtmlEmailBody></messaging:emailTemplate>

<messaging:emailTemplate subject="pd2" recipientType="Contact" relatedToType="Opportunity"><messaging:HtmlEmailBody ><center><table border="0"> <tr>     <th>Product</th>     <th>Quantity</th>     <th>Last Modified Date</th> </tr><apex:repeat var="cx" value="{!relatedTo.OpportunityLineItems}"><tr>    <td>        <a href="https://na4.salesforce.com/{!cx.id}">{!cx.Description} </a>    </td></tr>     <td>{!cx.PRICEBOOKENTRYID}</td>     <td>{!cx.Quantity}</td>     <td>{!cx.LastModifiedDate}</td></tr>     </apex:repeat></table></center></messaging:HtmlEmailBody></messaging:emailTemplate>