Say I have a company that has project teams

Team A
Team B
Team C
Team D

Employees can be a member of one, or more teams.

Employees use CC Form Builder to provide email addresses and what teams they are on.

I want to be able to send an email to all members of Team B

I want to send an email to all members of Team A and Team D

Currently my thinking takes me as far as all the form data being massaged by excel to get the email addresses, but then getting those addresses to the email is a little labour intensive.

Another possibility is a php script of some sort.

Ideas welcome.

Are you filling a Mysql with the info?

I am thinking that it will have to be in Mysql.

How do you want to be able to send the mail to each team? Do you want to use another form? What kind of info do you want to send and how complex does the email need to be?

Use web form builder to collect the team data, (ie email address) save it with MailChimp (Works with form builder and is free) then send your email to the teams from MailChimp. MailChimp will let you organize your emails into separate 'lists' (ie teams). Problem solved.

Mail chimp is an option if you don't need some kind of special processing with data between you and the teams.

The emails only need t be able to be the email and attachments, possibly web links in the emails, adding the info from another cc form would be good cuz you could "tick" off the teams you want to get the info. I'll look at mail chimp but free is not necessarily a requirement.

I set up a form which directed an email to different people in our art society.What I did was used the drop down then each different requirement sent to a different email address. However each was a unique address so I did not try dual addresses. Don't know if it has that capability. I had some problems but Eric advised me on that one.

Personally I would use php mail. have a look at the item in the last stored record in the csv and send accordingly. It is a matter of a few if then or else.

I will add that to my back end data handling project, that's a good one David. If you can wait a week I am helping a lady with a script currently. In the mean time find my contact No. on another post and send specific details. I will think of a simple solution in the mean time. Give me a break from dynamic responsiveness when I get bogged down.

Hmm! I have a strange design I am following, imagine an empty responsive grid page filled with empty php variables waiting to be filled on load. Still that's another story and Off Topic

I just got a new script up that allows us to log our pesticide applications at work online. I thought my Excel version was great but this version is so much more versatile. I have it setup to email all the users with the same pesticide license when a user deletes an application. It even sends a copy of what they deleted. So as Prism has already stated php mail can easily handle this.

I figured php was the way to go... and I probably will be screaming at you two for hep as I don't know php (blush) I know C++, VB, and assembly, but haven't gotten around to php yet