I solved my first problem. If all the email addresses are the same it only sends one message. Is there a way to get it to send a message for every row in the record set regardless of whether the email address is the same?
Thanks, -----Original Message----- From: Blake Johnson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 1:20 PM To: inFusion Support List Subject: [iMS] CFX_IMSMAIL query I have two problems the first is with the query param. It seems to only send one email from the result set even though the result set returns three rows. It's always the last row in the result set. The second problem is with imscid. It seems to be creating the embedded images but when you view the email (I'm using MS Outlook 2000) the images are not found. Thank you, -----------------------------Source------------------------------- <cfquery name="contact" datasource="planner"> select ID, firstname, lastname,categoryid,email from Contact where id in (#form.toid#) </cfquery> <CFX_IMSMAIL log="yes" query="contact" queryfield="email" qtoken_lname="lastname" qtoken_fname="firstname" header_to="recipients" header_from="#form.fromemail#" header_subject="#form.subject#" body="Dear <:fname:> <:lname:>, Your Invited !!! #form.message#" html="<html><head><title>You're Invited</title></head> <body> <table align=left> <tr> <td rowspan=5><img src=""<imscid=D:\inetpub\wwwroot\partyplanner\Invite1\main.jpg|image/jpeg>"" > <td rowspan=5><font size=3> </font> <td><img src=""<imscid=D:\inetpub\wwwroot\partyplanner\Invite1\HMIhouse.gif|image/gif >""><font size=4 face=""Arial""><b>YOU'RE INVITED!</b></font> <tr> <td> <tr> <td><font size=4 face=""Arial"">Please join us for a<b><br> Homemaker's Idea Company. </b>Show.<br> You are welcome to bring a friend!</font> <tr> <td><font size=3> </font> <tr> <td><font size=2 face=""Arial"">Hostess:</font> <p><font size=2 face=""Arial"">Address:</font> <p><font size=2 face=""Arial"">Date:</font> <p><font size=2 face=""Arial"">Time:</font> <p><font size=2 face=""Arial"">RSVP:</font> <p>#form.message#</table></body></html>"> -------------------------------------------- Blake Johnson CIO, CIPIO.COM 801.534.0544 ==^======================================================= This list server is Powered by iMS "The Swiss Army Knife of Mail Servers" -------------------------------------- To leave this list please complete the form at http://www.coolfusion.com/iMSSupport.cfm Need an iMS Developer license? Sign up for a free license here: http://www.coolfusion.com/iMSDevelopers.cfm List archives: http://www.mail-archive.com/infusion-email%40eoscape.com/ Note: You are subscribed as [email protected] ==^=======================================================
