CFMAIL list with different attachments

[scottd431]

I am using RH 6.2 SBE and Apache our database is using Informix Dynamic 4GL using the Java client. We have everything working but we need to provide the customer with one more project. We are needing to send out invoices which will be different for every customer. We can create individual files for each invoice and I see the CFMAIL and CFMAILPARAM commands will work for send to a list but I have been unsuccessful in locating how to send different files to different email addresses. Can anyone assist me in this process. I am very new at CF so any detail or links would be helpful or any other solution. Any help would be greatly appreciated.
Scott

 

[pigsie]

Store the *path* to the files in the db. When you run a query of all the people you would like to email use this new field to grab their relevant file.

HTH