Help! Page numbering on mail merge

danikuper

Registered User.
Local time
Today, 00:41
Joined
Feb 6, 2003
Messages
147
I'm using a DB in Access 2000 to perform a mail merge.

I've created a report (the letter that will be sent out to customers) successfully and have each customer on a separate page. The problem is that some customers will receive a one-page letter and others will receive 2 or 3 page letters (depending on what their records have).

When including page numbers the first page of a customer letter could receive 'Page 54' if that's the 54th page of the report. Is there a way to avoid that and have the page numbers reset after each customer?

Ideas?

thanks! :)
 
on the groupheader for each new customer, use this [Event Procedure]:

Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As Integer)

Page = 1

End Sub


Paul.
 
Thanks Paul, I'll try that.

:)
 

Users who are viewing this thread

Back
Top Bottom