Counting them is relatively easy - something like
{ IF { MERGESEQ } = 1 "{ SET mycount 1 }" "{ SET mycount { ={ REF
mycount }+1 } }" }
should do it.
The real difficulty is that there is no easy way to tell that you are
merging the /last/ record so that you can then output the count.
In this case, one way to work around that would be to
a. output to a new document
b. output the count for every record in a format that is easily found using
Find/Replace. For example, you could output
##{ REF mycount }##
c. after the merge, delete the ## characters surrounding the final count,
then use Edit Replace to replace "##(*)##" by "\1" (leave out the "
characters, click the "More" button in the dialog box, and check the Use
wildcards option.
Peter Jamieson
"pschatz100" wrote in message
news
I have a database that stores membership information for my club. I can
export member information as a .csv file, and would like to create a
report that uses mailmerge to print selected member information,
including a count of the member types (active, expired, etc.) For
instance, using the .csv file as a data source I would print a list of
new members, plus a count of the total number of active members.
I can already read through the list of members, and using an IF
conditional, just print the ones that are new members. Pretty cool.
--
pschatz100Posted from -
http://www.officehelp.in