Dynamic Email Attached Files

[falstaff]

I have an insurance claims business. I am currently passing information using email and attached files. Daily I will create an export file for each field agent who has new claims to be processed. The export file is prenamed. I then launch a second set of scripts to send the email to the adjuster. This means that I have had to specify the prenamed file in the script. I used the status error code to skip those adjusters who had no new files.

The system works fine except that I have to create new filenames and add to the master script to be able to add new adjusters. I will likewise have to delete adjusters that have left my business. Is there a way to make this process dynamic, where I could add the adjuster key field and export filename to a lookup table (or some such device) and then loop through the table having the adjuster key (id) and export filename substituted with each entry in the table.

Thanks