I need to send email with information from records related to the recipient contact though a N-N custom relationship. We have an in between record that have a lookup to the Contact and a lookup to the custom entity we want to get data from. ClickDimension Support suggested us the connection solution at this link (http://blog.clickdimensions.com/merge-any-custom-or-standard-entity-data-into-clickdimensions-emails-1/) , but that will not fit our needs because we have to maintain the functional relationship the recipient has with the custom entity to get only the related information.
Can i use Freemaker to use filters in the body of the email, so that we'll be able to get only custom entity records data that are related to the recipient of the outgoing Email? Is there another solution ?