Hi, I need to filter data in Mail Merge. I need to filter in Word Document, not programmatically with dataviews, etc…
I only find two options and I need help in both.
1.- Filter the data in parameters o something in “TableStart” mergefield. Exist something like this?
2.- I can “filter” with IF fields in the table, but I need to delete blank rows after mail merge. I have something like this:
Column1 | Column2 |
---|---|
{ MERGEFIELD "TableStart:DataTable1" { IF { MERGEFIELD "Type" = "A" { MERGEFIELD "Column1" } "" } |
{ MERGEFIELD "TableStart:DataTable1" { IF { MERGEFIELD "Type" = "A" { MERGEFIELD "Column2" } "" } |
And the result:
Column1 | Column2 |
---|---|
Data Column 1 Row 1 | Data Collumn 2 Row 1 |
Data Column 1 Row 4 | Data Collumn 2 Row 4 |
I need to delete empty rows not programmatically. Is this possible? with empty paragraph clean option?