Dynamic filename creation w/export

[Matthew Williams]

The list has been quiet so I figured I would stir up some conversation.

I currently have a invoice file, each invoice is flagged with a rep
code to distinguish who sold what.

Currently we print out hard copies and send them out to each of the reps.

I would like to setup a process that will export each invoice record
(not every field, just a few specific fields, this is no big deal) to
a simple delimited file which could then be e-mailed to the rep along
with a Word file to import the file to make it look pretty and
legible, this would save lots of time, paper and most importantly
money.

There are about 20 or so rep codes (3 digit code) so I would like to
be able to dump out all of these files at once in a batch.  The
filename would simply be <repcode>.txt.

I believe I have a decent approach to this situation (just a simple
output process with a selection set) but was curious to see how the
pro's would approach it.

My ultimate question is how would I dynamically set that filename to
the rep code?  Could it be done as a variable?  Could the date
possibly be added to it?  Any code examples out there?

Thanks a lot!
-Matt
Hale Mfg.