Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Mailmerge - total records?

Status
Not open for further replies.

GaryRW

Programmer
Mar 8, 2002
67
0
0
GB
This sounds so simple I'm certain I'm missing something.

Is there something along the lines of { NumRec } that would give the total number of records in the datasource for a mailmerge.

For background what I'm trying to do is to control the mail merge. I'm using the NEXT mergefield to show more than one record on a page, but I want to do a NEXTIF and only move onto the next record if the last record hasn't already been reached.

As it is, I am just using NEXT but I am dealing with small (varying) numbers of records. There are some fields that share the same data with all the other records, and then some fields with unique data for each record.

Essentially, there is a section in the middle of the merge doc that I need to show the unique data for each record, followed by a section at the bottom that shows the shared data. But the NEXT fields above that seem to move past the last record, and then all the shared fields come up as blank.

Any ideas?

As always, any help is much appreciated
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top