Merged Lables: Why are all pages numbered 1?

[Texas Nuckols]

I have a label template that I merge with data from Excel Spreadsheet. Need
to keep the multiple pages of labels in consecutive order. So I entered a
Page Number in the footer on the template. All pages are numbered 1 after
the merge. So I removed the Page Number from the template; merged the labels
to a New Document and THEN inserted Page Numbers. They are STILL all page 1.
How can I do what I need to do? I am sure it has something to do with the
section breaks, but that's what you get when you merge pages of labels.

 

[Jay Freedman]

You're correct that it has to do with the section breaks. In a merged
document, each page is a separate section, and each restarts the page number
at 1.

Here's the tedious manual method: Open the header pane to display the
Header/Footer toolbar (that's in Word 2003 or earlier; in Word 2007, it
displays the Header/Footer tab on the ribbon). Click the Format Page Number
button (in 2007, click the Page Number button and choose Format Page Numbers
from the menu). In the dialog, click the "Continue from previous section"
option and OK. Go to the next section's header and repeat, until all
sections have been changed.

Here's the quick and easy macro method: Install this macro
(http://www.gmayor.com/installing_macro.htm) and run it after the merge:

Sub ContinuousPageNumbers()
Dim Sec As Section
For Each Sec In ActiveDocument.Sections
Sec.Headers(wdHeaderFooterPrimary).PageNumbers _
.RestartNumberingAtSection = False
Next
End Sub

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

 

[Peter Jamieson]

It /is/ to do with the section breaks.

If you use Alt-F9 to view the { PAGE } field code and change it to {
SECTION }, you should get the result you need (unless it has to do with
printing the pages you want - in that case, try specifying a print range
such as p1s10-p1s10 for "page" 10


Peter Jamieson

http://tips.pjmsn.me.uk

 

[Texas Nuckols]

How easy was that?! Worked Great. Thank you so much.