Tleish,
I tried the query method but it wouldnt work for me. Also, it appears that this method works:
<!--- send the email --->
<CFMAIL SUBJECT="Voided Lot #LotID#"
TO="#QuotedValueList(EMailAddresses.EMailAddress)#"
FROM="#ProgrammerEMailAddress#">
Lot #LotID# was...