Sending emails to checked address only
Posted on 2006-03-21
I have a database table that holds info about players on a soccer team. Name, Number, Position etc. I added the field 'PlayerEmail' to the table. After the coach logs in, I want him to be able to send emails to the entire team OR to individual players that he checks. (I would have a 'Send to all' link, a 'Send to Varsity' link and a 'Send to Junior Varsity' link at the top of the page so he doesn't have to check 20some boxes to send emails to a particular team. He does need the ability to send an email to just 1 or 2 players though, and I'm a bit stumped. I would like the coach to be able to check 1 or some of the players then be sent to a page with a form (textarea) where he can then type his email. He would then click send, and the email would only be sent to the checked players. In my mind this would have to be 3 pages.....ViewPlayers.cfm (where the player info and the 'send email to' checkbox would be)......ComposeEmail.cfm (where the coach would type in a textarea to provide the email content).....and the ComposeMailAction.cfm (where the cfmail would execute and mail to only checked players) I know how to code the 'Send to Varsity' or 'Send to All' piece, and am have a little bit of knowledge on cfmail but am baffled when it comes to checkboxes. Does anyone have an idea? Your help is appreciated.