Matt, yep -- I scoped the variables. Seems to be working now. =) Eric
-----Original Message----- From: Matt Quackenbush [mailto:quackfu...@gmail.com] Sent: Sunday, December 02, 2012 6:00 PM To: cf-talk Subject: Re: question about lists and CFMAIL 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 <quackfu...@gmail.com>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 <e...@ebwebwork.com> 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="i...@nnvawi.org" >> 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:353333 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm