function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
miss vmiss v 

Mail Merge - Custom Objects

I am trying to run a simple mail merge document that contains data from three objects (2 of which are custom objects): Account, Employees and Benefit. 
Both Employees and Benefit are on the detail side of a Master-Detail relationship with Account.  The Benefit Object is also related by Lookup to the Employees Object through a unique ID. 
 
Basically, I need to create an merge document (S-control, perhaps?) that contains data from Employees Object such as {!Employees__c.First_Name__c} and {!Employees__c.Last_Name__c}, and also contain data from the Benefits Object such as {!Benefit__c.Date_Seen__c} and {!Benefit__c.UPACC_TT__c}. My problem is that when I run this using standard Salesforce Mail Merge functionality, either the Employee information does not show up or the Benefit data does not show up.  I tried running it from the Accounts page too, as both objects are related through Master-Detail to Account, but no data shows up.
 
Does anyone have an idea of how to make this work?