You need to sign in to do that
Don't have an account?
Luvara
Mail merge only certain Opportunity Product Line Items
Is it possible to only mail merge certain opportunity product line items? For instance I only want the mail merge doc to include line items from a single product family.
Has anyone done something like this?
Thanks,
Chris
Has anyone done something like this?
Thanks,
Chris
So you have line items on an opportunity that span multiple product families and you want to apply a custom filter to the generated result doc?
There is no way to do this using the standard clientside mail merge component BUT you could write your own custom datasource component using the clientside mail merge plugin system....
What I'm gathering is that I can't accomplish this even with the "SKIPIF" function in the mail merge template.
Thanks,
Chris
Am curious as to whether or not you ever resolved this.
As an SMB with a very slow hosted email solution Extended Mail Merge does not appear to be a reasonable solution.
Chris
I just tried SKIPIF, and it worked.
{SKIPIF MERGEFIELD OPPORTUNITY_LINEITEM_FIELDA = 0 \* MERGEFORMAT}
This would only display line items with fieldA != 0, didn't figure out how to display FieldB based on the value of FieldA yet.
Let me know if any find better solution.
Thanks,
Dawn
Any chance you could post the document you got to work? Here was what I was using with no luck..
Thanks,
Chris
I noticed one difference is you have { right after skipIF, and also you should have { between two fields.
My case would only work for filter on one field, so what I have in the previous post is all I used in the doc.
If you want to hide the whole line if certain criteria meet, would need to do more trial about the format.
Hope you can find solution soon.
Thanks,
Dawn