I'm using conga composer with conga workflow.
And I'm trying to send an email using the conga parameter &EmailAdditionalTo="emailid@something.com"
Is it possible to address the email to a public group I have in salesforce? Is it possible to use it like a merge field?
Thank you.
Attribution to: Prabhat
Possible Suggestion/Solution #1
The &EmailAdditionalTo parameter requires a value of either A) a single email address or B) multiple email addresses separated by commas. Your requirement can be accomplished by using a SOQL Query (available to be used with Conga Composer by using a free add-on) to query Group Member email addresses. You'd then use the &QVar parameter to reference your query in your button URL, format the query string result using &QVar0Format, and pass the result to the &EmailAdditionalTo parameter.
Your eventual SOQL query might look something like this:
SELECT Email FROM User WHERE Id IN (SELECT UserOrGroupId FROM GroupMember WHERE Group.Name = '{pv0}')
In this case, the dynamic value for '{pv0}' would be a Group Name that you could pass in your Composer button URL. The parameters in your corresponding button URL would look like so:
&QVar0Id=a03i000000CGeFQ?pv0=Test+Group
&QVar0Format=10000
&EmailAdditionalTo={QVar0}
I got this to work just fine in a Dev org. Hope this helps!
Attribution to: Robert Boyd
This content is remixed from stackoverflow or stackexchange. Please visit https://salesforce.stackexchange.com/questions/32803