PDA

View Full Version : Page numbers disappearing when splitting a mail merged document



HannahA
06-27-2019, 06:13 AM
I have used a mail merge to create one large word document which I then split up using VB code into several documents, one for each client.

I am using a one page word template with my company logo on the first page which I call through VB using

mydoctemp = "Logo Template.dot"

The template has settings as Layout - Different first page.

When I run the code to split the large document it loses all page numbers from page 2 onwards, I want page numbers on each page of each individual document. Can anyone help?

gmaxey
06-27-2019, 07:09 AM
Is there a page number field applied to the PrimaryPage and EvenPage header or footer in your template?

Paul_Hossler
06-27-2019, 08:00 AM
I am using a one page word template with my company logo on the first page which I call through VB using mydoctemp = "Logo Template.dot"


Does each client get copy of the first page?

i.e.

Logo page
Client 1

Logo page
Client 2
Logo page
Client 3

etc.

macropod
06-27-2019, 05:57 PM
I have used a mail merge to create one large word document which I then split up using VB code into several documents, one for each client.
Instead of taking that approach, use VBA to generate a new document for each record as the merge is done. See Send Mailmerge Output to Individual Files in the Mailmerge Tips and Tricks thread at: http://www.msofficeforums.com/mail-merge/21803-mailmerge-tips-tricks.html


I am using a one page word template with my company logo on the first page which I call through VB using

mydoctemp = "Logo Template.dot"

That's not the correct way to do a mailmerge. Mailmerges should be run from a mailmerge main document, not from a template.