Forum Discussion

Kathleen-KMB's avatar
Kathleen-KMB
Copper Contributor
Jan 12, 2022

Is there a way to hide a single page in multi-page mail merge document?

Hi! Mail-merge newbie here...I am trying to determine if it's possible to hide a single page with no mail merge data, that is contained in a multi-page mail-merge document.   Within Salesforce, we ...
data & ai
Tables
Kathleen-KMB's avatar
Kathleen-KMB
Copper Contributor
Jan 14, 2022

Doug_Robbins_Word_MVP awesome, thank you Doug!

 

Here is a download link: https://local-bigfoot.wetransfer.com/downloads/34540942621d0a8fe6f5182e98a34cab20220114173800/4815b6b71dea701c91dc38b19de6981420220114173800/e161c5 

 

As for the data source, this word doc is loaded into Salesforce and the data is generated through Conga. Let me know if you need more details!

Doug_Robbins_Word_MVP's avatar
Doug_Robbins_Word_MVP
MVP
Jan 14, 2022

Kathleen-KMB 

While I do not know anything about Salesforce and Conga, if it were a normal mail merge operation, you would select each page of the document and press CTRL+F9 to enclose the page in a pair of field delimiters { } After the opening { you would insert

 

{ IF { MERGEFIELD "Ticket #1" } <> "" "

 

as shown below

 

and inside the closing field delimiter }, which will be on the next page, insert a " as shown below

 

 

This process would be repeated for each page of the document.   If the field that dictates whether or not a ticket is valid, is something different from the "Ticket #1", "Ticket #2" and "Ticket #3" that I have assumed, you would replace my assumptions with the relevant field.

 

I have uploaded the modified document.