statement for dynamic to

Hi all,
my question is:
I have a table on db jos_comprofiler where i have some field cb_provincia, cb_cat, and cb_mail
I want send mail at result from query:
select cb_mail from jos_comprofiler where cb_provincia = post_provincia and cb_cat = post_cat;

Now I have
db multi loader
con model id = email
e field cb_mail
and where condition:

cb_provincia LIKE
'%<?php echo $_POST['provincia'];?>%'
and 
cb_categoria like '%<?php echo $_POST['categoria'];?>%'

if I read email:

<?php
$bb=$form->data['email'];
foreach ($bb as $b) {
echo ", ".$b['cb_mail'];
}?>

it's good whit my where condition excatly, but if i write email or {email} in dynamic to is wrong.
Please help me!!
excuse for my english, but i'm italian!!!! thnak you

Hi dagoma,

Is the DB Record Loader action before the Email action in the On Submit event?

Bob

HI grey,
thank you for your post.

this is.
It's clear?

Many thank you. Please help me!!!
I have some pics for you!!!

Hi greyhead,
yes, the DB Record Loader action is before the Email action in the On Submit event. I have stamp the photo for demonstrantion ok, please send me reply ... help me!!!

I think that the variable needs to be in curly brackets ie {email}

If you put a debugger action on the onsubmit you will be able to see what email address its trying to send it to.

Also greyhead has a nice custom email action that you may be interested in if your using V4.
http://greyhead.net/how-to-docs/cfv4-email-gh-action
I have used it in the way you want to and it worked without any problems.

Thanks
John

Hi john,
many thanks for your answer, but i can try this solution, but not function {email}. Maybe the question is in the result of my query are my is more than one mail?
The error is wrong send mail beacuse not valid mail but is array
In my form are a field email_ric i try insert in dynamic from email whit {email_ric} ... but not function????
I don't know please help me!!!
see you
many thanks for docs

Hi dagoma,

a) In the standard Email action you enter Dynamic values without curly bracket - just email*

b) You can't set multiple From Email addresses (it doesn't make any sense).

c) To set multiple Dynamic To addresses you must put the values in an array and put the array name in the Dynamic To box.

Bob

*In my custom Email [GH] action you do use curly brackets because you and add both static and dynamic values in the same box e.g. {email},user@example.com.

PS I strongly recommend that you do *not* use the Dynamic From Email element in your Email Setups. Using this often results in your emails being marked as spam and dropped into a spam filter. Instead use the static From Email with an address that matches the site domain name and use Dynamic ReplyTo Email for the user email. The result is the same but with a much better chance of good delivery.

Many thanks GreyHead,
i want send at more than one mail, not from. My array email create whit DB Multi Record Loader is (email).
If i write email in the box dynamic to, not send and write me error because is array. How code i can write for a good send more mail(when is all good i send mail whit BCC)??
It's clear?
I have Tryin Custome code:

<?php
$form->data['subject'] = "Prova OGGETTO CAZZO ";

$form->data['ditte'] = $form->data['email'][0]['cb_mail']." , ".$form->data['email'][1]['cb_mail'];
?>

the result in the debbugger is:
[subject] => Prova OGGETTO CAZZO
[ditte] => [email]dagoma9@email.it[/email] , [email]dagoma@yahoo.it[/email]

It's good for me, when Insert subject in Dynamic Subject it' ok, but when insert ditte in dynamic Bcc not send mail, and write " [email]dagoma9@email.it[/email] , [email]dagoma@yahoo.it[/email] not is valid email "

please help ME!!!


Thank you many