I am having two problems with my mail merge document (attached) that I am having problems with.

1. a) its configured to display only one record per page. Due to Excel VBA code that prepares the mail merge document, its necessary to code these section breaks in the mail merge document. See https://www.msofficeforums.com/mail-...tml#post100274 as to why.
   With this report though, although one table is printed per page, the last page is always blank. So if there is only one record associated with the merge, page one is the table, page 2 is blank (except for header and footer).
   
   
   
   How can I prevent this blank page from being produced?
2. In my footer, I have two fields {PAGE} and {NUMPAGES}. These do not populate in the final document. They just show as the field codes. Where did I go wrong?

Thank you all in advance.

Attached Files

DT15v1.docx (414.9 KB, 9 views)

Disregard problem #2 ... I think I have it resolved.

When you execute a letter merge, Word adds a Section break after each letter. Presumably that's what's happening here. The simple solution would be to modify you code to delete the final section break & penultimate break.

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