<div>
Thanks for your help Graham.<br />
<br />
I followed your instructions up to the point where I embedded the page within curly braces but without adding the IF{MERGEFIELD statement. <br />
<br />
{ &quot;................Page Break.................¶<br />
<br />
I then tried the MailMerge to confirm that it would still work with the curly braces. But it didn't ! It didn't generate the second page at all.<br />
<br />
Why is this ? Does it need the IF statement to print the second page ?<br />
Regards<br />
Toco<br />
<br />
<br />

<pre><code id="code-20-41225124-1"></code></pre>
</div>


Thanks for your help Graham.

I followed your instructions up to the point where I embedded the page within curly braces but without adding the IF{MERGEFIELD statement.

{ "................Page Break.................¶

I then tried the MailMerge to confirm that it would still work with the curly braces. But it didn't ! It didn't generate the second page at all.

Why is this ? Does it need the IF statement to print the second page ?
Regards
Toco






<div>
Thanks for the excellent solution Graham. I got it to work eventually - the spaces were important !<br />
<br />
Toco
</div>


Thanks for the excellent solution Graham. I got it to work eventually - the spaces were important !

Toco

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
I have a Word document consisting of two pages (an Invoice, and a Balance Statement) which I use to MailMerge invoice data from an Excel worksheet. It works fine, generating both pages for each Excel row.<br />
<br />
However, I would like it to only create the Balance Statement (the second of the two pages) if the value in a 'Balance Due' field in the spreadsheet exceeds £500. is it possible to suppress a page in Word MailMerge ?<br />
<br />
Thanks<br />
Toco
</div>
</div>


Hi Experts,

I have a Word document consisting of two pages (an Invoice, and a Balance Statement) which I use to MailMerge invoice data from an Excel worksheet. It works fine, generating both pages for each Excel row.

However, I would like it to only create the Balance Statement (the second of the two pages) if the value in a 'Balance Due' field in the spreadsheet exceeds £500. is it possible to suppress a page in Word MailMerge ?

Thanks
Toco

How can I suppress a page in Mailmerge on condition of an Excel value ?

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Word is a commercial document editing program that is part of the Microsoft Office suite. It features numerous text-editing tools for creating richly formatted documents, along with tools for the use of macros in Word documents. Word's native file formats are denoted either by a .doc or .docx file extension. Plugins permitting the Windows versions of Word to read and write formats it does not natively support, such as the OpenDocument format (ODF) are available. Word can import and display images in common bitmap formats such as JPG and GIF. It can also be used to create and display simple line-art.