ColdFusion 9.0.2
MS SQL Server 2005
Greetings. I have a question about lists and CFMAIL.
I need to send an email message to all email addresses in a data table that
are not marked PaidDues.
First, I query the data table to find all records with PaidDues = False (or
0).
!--- ask for userIDs
MS SQL Server 2005
Greetings. I have a question about lists and CFMAIL.
I need to send an email message to all email addresses in a data table that
are not marked PaidDues.
First, I query the data table to find all records with PaidDues = False (or
0).
!--- ask for userIDs who have not paid
[mailto:quackfu...@gmail.com]
Sent: Sunday, December 02, 2012 4:16 PM
To: cf-talk
Subject: Re: question about lists and CFMAIL
No, not on the right track. Look at the query attribute of cfmail. That's
what you want to use.
http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e08
payment
page:
/cfmail
/cfloop
!--- close cfloop ---
/cfif
!--- / is form.doRemind defined? ---
-Original Message-
From: Matt Quackenbush [mailto:quackfu...@gmail.com]
Sent: Sunday, December 02, 2012 4:16 PM
To: cf-talk
Subject: Re: question about lists and CFMAIL
? ---
-Original Message-
From: Matt Quackenbush [mailto:quackfu...@gmail.com]
Sent: Sunday, December 02, 2012 4:16 PM
To: cf-talk
Subject: Re: question about lists and CFMAIL
No, not on the right track. Look at the query attribute of cfmail.
That's
what you want to use.
http
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
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
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.comwrote:
Try scoping the to
I take it all back. It is working:
cfmail query=NotPaid
server=#REQUEST.MailingListServer#
from=i...@nnvawi.org
to=#NotPaid.UserEmail#
/cfmail
Why did it not work before? Very like, user error. =)
Thank you all again for your help. This is a success.
Eric
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
10 matches
Mail list logo