>I am amending my current routines for printing statements for customers and trying to add the functionality for emailing the statements. I currently create a cursor that holds all invoices with balances. The frx is designed to create a new page each time a different account# is encountered.
>
>I am going to use frx2word to assist with emailing however if I do this I would get one word document with all account#'s(or pages) included.
>
>I intend to do this for a lot of programs once I get this working so I would rather make my modifications in the parent class of my report class. So, I'm thinking I need some routine to take my selected cursor, right before my "report form", and limit the cursor to one Account #'s invoices. and then issue my call to frx2word. This should be done in a loop so as to catch each account#.
>
>Has anyone done something like this? Am I even making sense in the first place? I guess what I'm looking for is some help with this particular routine.
Sounds easy, or I misunderstood :). I'll try some pseudo code:
cAll=alias()
select dist cAccount from (cAll) into array aAccnt
for i=1 to alen(aAccnt)
cAccnt=aAccnt[i]
select * from (cAll) into cursor cOneAccnt where cAccount=cAccnt
do frx2word( {you figure out the parameters} )
endfor
Is this what you had in mind? This can actually be a single routine, where the parameters would be those to pass to Frx2Word. You may also need something to build filenames for the bunch of documents you'll create.