>>> 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:353329 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm