You need to put your header text inside of an IF Field that tests for the last page.

{ IF { Page } < { NumPages } "header" }

"header" in the example above is whatever you want in the header including your Page field. Note braces {} must be inserted using Ctrl+F9, not by typing.

See How to control the page numbering in a Word document.