[SalesForce] Visualforce Email Template Not Showing Content

I want to send an email based on user specified language. For this we created an Visualforce Email Template with custom label:

<messaging:emailTemplate subject="15 Days of Salesforce.com Inactivity - Please Login" recipientType="User" relatedToType="User_Status__c" language="{!recipient.Email_Language__c}">
  <messaging:plainTextEmailBody >
    <apex:variable var="LastLogin15" value="{!$Label.LastLogin15}"/>
  </messaging:plainTextEmailBody>
</messaging:emailTemplate>

In the above code Email_Language__c will hold user language and LastLogin15 is a custom label which has the email content that has to be translated.

Problem: when tested using Visualforce pages this is working fine, but when I test by sending a test email it doesn't display any content. Where am I going wrong?

Best Answer

The problem is in your markup

{!relatedTo.c2g__c.User__r.Email_Language__c}

should probably be

{!relatedTo.User__r.Email_Language__c}

and 

{!User_Status__c.User__c}

should be

{!relatedTo.User__c}

Maybe a copy/paste error?

Related Topic