Emailing Invoices with CF 5

[scottd431]

We are trying to email invoices to our customers. We want to use CF. I understand how the CFMAIL and CFMAILPARAM commands work but we have a list of email addresses and each email address will have a specific file associated with it. Any help or suggestion on how to address this issue?

 

[GunJack]

I may be missing something but it seems like you just need to add a field to your database and list the file for each customer. During your e-mail loop, just specifiy the attached file as what you have stored in that customer's record.

GJ

 

[scottd431]

GJ
I am very inexperienced with CF. Should I still use the CFMAIL command with the CFQUERY and the CFMAILPARAM? Thanks for your suggestion