Try scoping the to email: <cfmail query="NotPaid" ... to="#NotPaid.UserEmail[currentRow]#">
HTH On Sun, Dec 2, 2012 at 4:53 PM, Eric Bourland <[email protected]> wrote: > > >>> No need at all for the cfloop. When you provide the query to cfmail it > does the loop for you. > > Well, I believe you. At first I did try: > > <cfmail > query="NotPaid" > server="#REQUEST.MailingListServer#" > from="[email protected]" > to="#NotPaid.UserEmail#" > .... > </cfmail> > > ... ColdFusion sends to only the first email address returned in query > NotPaid; and it also populated the CFMAIL message with multiple values of > #FirstName# and #LastName# -- for all records WHERE NotPaid=0. > > I am all for using the more efficient query attribute of CFMAIL. I am > missing something. I will try it again and report exactly what happens. > > Eric > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353330 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
