Email to group of addresses from recordset(s)

Hello,
I cannot find a specific answer in the forums that addresses my issue.

I would like to be able to have someone choose a group(s) of email addresses from a recordset based on a "team".

I see that UE can set "to" as one recordset result, however I need to allow users to choose from 5 different "teams". And possibly multiple teams.

I have read forum posts suggesting checkboxes for individual addresses, however not for multiple recorset results.

Questions:

Can UE pull the correct team email addresses from one big recordset based on a selection in the form, or do I need to create multiple recorsets, one for each team?

I was going to use a dropdown to choose, but even if I go with checkboxes, how do I assign the different recordset results (groups of emails) to each drop down, or checkbox.

Just to be absolutely clear, I want a visitor to be able to choose a team(s), fill out the form and have the form results emailed to everyone on that team.

Thanks
Alan

create a multiple select list that you can use to select the teams:

<select name="teams[]" size="5" multiple="multiple" id="teams">
    <option value="Team1">Team1</option>
    <option value="Team2">Team2</option>
    <option value="Team3">Team3</option>
    <option value="Team4">Team4</option>
    <option value="Team5">Team5</option>
  </select>

then create a recordset that will lookup the users by the selected, using the advanced recordset window, create the recordset as:

SELECT * FROM usersTable WHERE team IN(paramTeam)

create a new variable as:
name: paramTeam
Type: Text
Default Value: -1
Run Time Value: $_POST['teams']


this example recordset is using a table named "usersTable" and a column named "team", the example assumes the teams are stored in the team column using text values like "Team1", "Team1" etc.. You will need to make changes to use the correct table and column names and correct value.

Next, add the following code at line 1 to convert the multiple selections to a comma separated list:

<?php

if($_SERVER["REQUEST_METHOD"] == "POST")     {

    foreach($_POST as $key => $val) {

        if(is_array($_POST[$key])) $_POST[$key] = implode(", ", $_POST[$key]);

    }

}

?>

then in universal email, click the to button to go to the advanced to settings page and set the to address to use a recordest loop

Jason,

That ALMOST worked for me. Thanks first for your clear, concise reply, it was very helpful.

I still have 2 outstanding issues I cannot resolve:

1. I have created a form and it will send to ONLY one "team" from the multiple list...doesn't matter which, but can only do one at a time. If I CNTL click more than one "team" from the list NO emails will go out to anyone.

2. The email that does go out contains no data from the fields in the form, nor does it show the "from" email address that I specified from a recordset. It only shows the subject I specified in UE. I did not specify a html template for this form, is that required?

Thanks
Alan

it looks like you have hand coded the recordset loop for the to address?

1) Change this line:

if(is_array($_POST[$key])) $_POST[$key] = implode(", ", $_POST[$key]);

to:

if(is_array($_POST[$key])) $_POST[$key] = implode("', '", $_POST[$key]);

you may need to comment this line:
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;


2) in the from address recordset you are using a session variable, are you sure that session has a value? try adding this code at line 1:

<?php @session_Start(); ?>

if it is still not working, add this code after the body tag for troubleshooting:

<?php echo("SQL: ".$query_GetSender); ?>

post back the sql statement this generates.

for the form contents, the simplest way to get the form data in the email is to use one of the templates.


if you don't use a template, you need to click the DW edit button to design the email body and add the form bindings to the page manually.

Getting there....but still cannot send email to mutiple "teams"

1.
The only code I changed in the recordset loop is removing the (s) from teams. Being new to this I wasn't sure what could stay and what needed to match the column name in the database so I made everything "team". I have also changed it back to exactly what you sent where it says "teams" in the recordset loop parameter and the page code, but still no luck.

I have also made the other changes in your most recent suggestions but still no luck on getting the form to email multiple "teams".

Updated code attached.


2. SOLVED
The return on the sql statement you requested after adding the session start is
SQL: SELECT id, email FROM patroller WHERE id = 224661
Before the session start was added it returned -1
The form is now returning the correct email "from" address when the email is sent. There was no session start originally due there being one within a server side include which gets the logged in users name and displays that as a welcome message, but adding it to the form page makes the return address work now.

try commeting this line:

$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

change it to:

//$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

Unfortunately commenting out that line did not work. The form still only sends if I choose one of the "teams" but will not send any email when choosing multiple teams.

I have created a support ticket so we can look into this issue further.

To view and edit your support ticket, please log into your support history:
supporthistory.php

If anyone else is experiencing this same issue, please append to this thread.