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

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

Peter,

Thanks. the counting works great. People like you make this stuff
look easy!!


--
pschatz100Posted from - http://www.officehelp.in