Perfect. Thanks a bunch Isaac. Just needed a confirmation before providing an estimate on amount of time needed to build the functionality.
CC "S. Isaac Dealey" <info To: CF-Talk <[EMAIL PROTECTED]> @turnkey.to> cc: Subject: Re: CFMail - Multiple Attachments 12/19/02 12:53 PM Please respond to cf-talk > Hello, > I would think this is an easy question, but I have not > easily found the > answer yet. Is it possible to send multiple attachments > out with cfmail, > and can the number of attachments and attachment names be > dynamically > determined based on user selections within the > application. Basically Im > wondering can 2 or 3 forms be sent out via cfmail for > certain benefit > selections an employee has made within our benefit > selection system for our > annual enrollment process. I found 1 site referencing > cfmailparam. Can I > assume that the cfmailparam could be dynamically populated > to pull the > forms we needed. > Thanks! > Casey Cook Absolutely ... here's some pseudocode <cfquery name="rsSelected"> SELECT benefits.FileName FROM benefits INNER JOIN employee_benefits ON ( employee_benefits.employeeid = #employeeid# ) </cfquery> <cfset variables.sourcefolder = "c:\benefitsfiles"> <cfmail ...> <cfloop query="rsSelected"> <cfmailparam file=" #variables.sourcefolder#/#rsSelected.FileName#"> </cfloop> </cfmail> s. isaac dealey 954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm