Find your content:

Search form

You are here

Mail merge into Word template including child objects?

 
Share

Is it possible to use standard Salesforce Mail Merge (with a Word template) from a Master object in a Master-Detail relationship to include information from the related Detail records, for example in a table?

I believe the answer is no; however, I'm curious because it seems possible to do this with Opportunity Line Items, and wondered if it is possible it can be applied more generally? If not, does anyone know the reasoning?

I know this can be done with Conga, Drawloop and other similar products, and I know Visualforce templates are also an option, but I am just wondering about standard, Word based templates.


Attribution to: GBreavin

Possible Suggestion/Solution #1

Matt is right. Oppty is treated as a special object in standard mail merge for the purposes of generating proposals or invoices. You could potentially roll-up your detail data into fields on the parent object, but otherwise I'd recommend Conga.


Attribution to: hammnick

Possible Suggestion/Solution #2

Nope, as far as I know, this is not possible with the standard mail merge, even extended mail merge. You can't pull from child objects without a third party tool.


Attribution to: Matthew Lamb
This content is remixed from stackoverflow or stackexchange. Please visit https://salesforce.stackexchange.com/questions/773

My Block Status

My Block Content