Hi,
I created a group based on a custom entity "RelEnt" (prefix is "Rel") for custom relationship data for both Company A and Company B, but Send To MailChimp button is hidden. I then followed up the following article to change the email address column name to rel_emailaddress but the button is still hidden.
The custom view will retrieve 2 email addresses: the first one, Rel_EmaiLAddress is for Company A, and the second one, Rel_EmailAddress_Comp2, is for Company B.
Here is the custom view used to create the group:
CREATE VIEW vRelCompView
AS
SELECT Rel1.Rel_RelEntID, comp1.comp_name, Comp1.comp_status, Comp1.comp_type, Comp1.comp_secterr, Comp1.comp_primaryuserid, Comp1.comp_channelid, (select Top 1 Emai_EmailAddress from email (nolock) INNER JOIN EmailLink on ELink_EmailId=Emai_EmailId INNER JOIN Company on comp_Companyid = elink_recordid and ELink_EntityID='5' WHERE Comp1.Comp_CompanyID = elink_recordid ORDER BY emai_EmailID desc) as Rel_EmailAddress, comp2.comp_name, Comp2.comp_status, Comp2.comp_type, Comp2.comp_secterr, Comp2.comp_primaryuserid, Comp2.comp_channelid, (select Top 1 Emai_EmailAddress from email (nolock) INNER JOIN EmailLink on ELink_EmailId=Emai_EmailId INNER JOIN Company on comp_Companyid = elink_recordid and ELink_EntityID='5' WHERE Comp1.Comp_CompanyID = elink_recordid ORDER BY emai_EmailID desc) as Comp1_Emai_EmailAddress, (select Top 1 Emai_EmailAddress from email (nolock) INNER JOIN EmailLink on ELink_EmailId=Emai_EmailId INNER JOIN Company on comp_Companyid = elink_recordid and ELink_EntityID='5' WHERE Comp2.Comp_CompanyID = elink_recordid ORDER BY emai_EmailID desc) as Rel_EmailAddress_Comp2
FROM RelEnt Rel1 LEFT JOIN Company Comp1 ON Rel1.Rel_CompanyID = Comp1.Comp_CompanyID
LEFT JOIN Company Comp2 ON Rel1.Rel_Company2ID = Comp2.Comp_CompanyID
WHERE Rel1.Rel_Deleted IS NULL AND Rel1.Rel_CompanyID IS NOT NULL AND Rel1.Rel_Company2ID IS NOT NULL AND Comp1.Comp_Deleted IS NULL AND Comp2.Comp_Deleted IS NULL
Thanks a lot!