Macro for pagenumbering in Word

[theom]

Hi,
I am producing Word files from a database with SQL Word. The output is a single document in which inquiry letters to multiple vendors are combined. These letters contain multiple pages and need to be printed with a page indication (page x of y). Each letter needs to start with page 1 and the number of pages is not the number of pages for the total document but the number of pages for that specific letter. The start of a new letter is identified by a keyword on that page (e.g. INQUIRY).

Who has any idea how to program this via a macro?
Thanks in advance, Theo M.

 

[Lilliabeth]

When you do a mail merge, Word automatically puts in a section break at the end of each record, so you just have to tell Word to start numbering over at each section...

Do the merge without page numbers - don't merge to printer, but choose to edit the document before printing.

Ctrl+A to select all
Insert | Page Numbers
Choose a location and click the little Format button
Choose to start each at 1.