...
- VF Email is being sent from Custom Object B and contains fields from all related objects.
- Emails sent from Custom Object A work with no problem.
Status
...
- Values from Custom Object C work show fine.
Doesn't work
Here's what I've tried that doesn't work
- Sending via a workflow on one hour timer
- Sending via workflow immediately
- relating all the required fields onto Custom Object B as formulas
- Using one workflow to set a status saying send the email and another workflow to send the email.The VF Email Template header is
<messaging:emailTemplate subject="My Email Subject" recipientType="Contact" relatedToType="ObjectB__c" rendered="true">
Steps
Steps to try to work out what the problem is and fix it
| Step | Notes | Result |
|---|---|---|
| Create formula fields for data | rather than {!relatedTo.ObjectA__r.Campaign__r.Account__r.Notes__c} I added the Notes field to Object B as a formula field so it was {!relatedTo.Notes__c} I did this for 3 fields |  No fields displayed |
| Send email immediately | The workflow was running after an hour | No fields displayed |
| Simplified the HTML Email | No fields displayed | |
| Added the IDs for all the objects into the email body |  ALL IDs Displayed!! | |
| Added the Names | If the Standard Fields of IDs display, do the standard fields of Names display? Because the field that is displaying from ObjectC is the Name field. | All Name fields displayed!! |
| Added the new fields without any HTML embellishment | Just replaced the name fields that did display with the fields I wanted to display. |