Also, where is #FirstName# and #LastName# coming from? I am assuming they are also part of the query. If so, scope them as well.
#NotPaid.FirstName[currentRow]# #NotPaid.LastName[currentRow]# On Sun, Dec 2, 2012 at 4:59 PM, Matt Quackenbush <[email protected]>wrote: > 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:353331 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
