I would like to seek your help in troubleshooting a mail merge issue.
I create a mail merge document with the data come from an SQL database. The template has 2 pages, the first page contains mail merge client information, which it works properly. The second page - I am using page break - Section break, and insert the following merge field



{IF { MERGEFIELD A } = “” “” “{INCLUDETEXT "\\\\DIR1\Doc1.doc" \* mergeformat}”}

When the mergefield A is not blank then the document is included (Which is Ok). However, if the condition is satisfied, it include a blank page, which is not right
How can i remove the blank page?

Thanks

Hi Peterth,

The blank page is probably the result of something in the document referred to by the INCLUDETEXT field. You might get better results if you bookmark just the part of the reference document you're interested in (eg not including the final paragraph mark) and refer to the bookmark in the INCLUDETEXT field. For example:
{IF{MERGEFIELD A} <> "" {INCLUDETEXT "\\\\Dir1\Doc1.doc" "BkMk"}}
where 'BkMk' is the bookmark name. You probably don't need the '\* Mergeformat' switch.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Many thanks. I shall follow your advise.

blank page is produced when the condition is not sastified

Hi Peterth,

That suggests the blank page is already present in your mailmerge main document - which is consistent with ' I am using page break - Section break'. The IF test I provided outputs the bookmarked content from the reference document if the condition is satisfied and nothing if the condition is not satisfied.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]