Mail merge page numbering in Word 2010 and printing same

My question is two-fold.

 

I have an 11 page Word 2010 training plan document which has an index.  The footer is set up as a table with the number 1 of 11 right aligned.  When I do a mail merge, e.g. for 10 people, the page number is continuous so that I end up with pages 1 of 110 at the bottom.  How can I stop this, so that each person's plan is still 1 of 11?

 

Also, I want to print these double sided but when I send print double-sided to the printer, I end up with the first page of the second set on the back of page 11 of the first set.  Any help gratefully received.

Answer
Answer
Did you use { SECTIONPAGES } instead of { NUMPAGES } for the 11?
Hope this helps,
Doug Robbins - MVP Office Apps & Services (Word)
dougrobbinsmvp@gmail.com
It's time to replace ‘Diversity, Equity & Inclusion’ with ‘Excellence, Opportunity & Civility’ - V Ramaswamy

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Answer
Answer
What field construction are you using in the footer?

It should be { Page } of { Sectionpages } - assuming a document with one section per record, which should restart the page count for each record when merging to a new document.

With respect to the double sided printing, you should treat each record as a separate print task (again assuming one section per record).

You could use a macro e.g. Sub SplitMergeLetterToPrinter()
Dim Letters As Long
Dim Counter As Long
Letters = ActiveDocument.Sections.Count
Counter = 1
While Counter < Letters
    ActiveDocument.PrintOut Background:=False, Range:=wdPrintFromTo, _
    From:="s" & Format(Counter), to:="s" & Format(Counter)
    Counter = Counter + 1
Wend
End Sub

to split the merged document

OR

You should be OK merging to the printer with http://www.gmayor.com/ManyToOne.htm  in one to one mode (provided your data source is Excel) and if you merge to separate documents then you can use NumPages or SectionPages.


Graham Mayor (Microsoft Word MVP 2002-2019)
For more Word tips and downloads visit my web site
https://www.gmayor.com/Word_pages.htm

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated October 5, 2021 Views 1,534 Applies to: