Send email to email field of another table

Anybody? <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=78210&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />

What do you mean with "email field from another table"? You need to explain the details of your database structure

Below is the code I am using to send an email to the session user who created the supportupdate as well as a hard coded address ($email and $email2). I need an additional email to go out to the person who created the original ticket in the support table. The support and supportupdate tables are linked on SupportID. The field that contains the email address however is in the users.UserEmail field. It is the only place the email address exists. My first question would be, do I need to link the users to the support and supportupdate table or do a query of the users table for the email address based on the user ID? At the end of the day, I want the original creator of the support ticket to get emails every time there is an update to a support ticket item.
(After Record Added to supportupdate)
$email=$_SESSION["UserEmail"];

$email2="scurrier@coastaldatadynamics.com";

$sendto=$email . "," . $email2;

$from="supportQ@statmedcaredb.com";

$msg="";

$subject="New Support Ticket Added Successfully";
$msg.= "Support ID: ".$values["SupportID"]."\r\n";

$msg.= "Support Created By: ".$values["SupportCreatedBy"]."\r\n";

$msg.= "Update Date: ".$values["SupportUpdateDate"]."\r\n";

$msg.= "Submitted By: ".$values["SupportUpdatedBy"]."\r\n";
$ret=runner_mail(array('to' => $sendto, 'subject' => $subject, 'body' => $msg, 'from'=>$from));

if(!$ret["mailed"])

echo $ret["Email sucessful"];
Does this help? I hope this makes sense.

First, you must save user email in session variable.
In AfterSuccessfulLogin event:

and than you can use $_SESSION["UserEmail"]in After Record Added event

I have already saved my session value as I am already sending an email to the SESSION user successfully. This is not what I am trying to accomplish. I want to send an email to the person who created the support ticket when a support ticket is updated. So, I need to cross reference this user, who is not necessarily the SESSION user. The value for this user is in the supportupdate.SupportUpdatedBy field. There are three tables at play here.... 1- users, 2- support, and 3- supportupdate. (relations- 1 support ticket to many updates and one User to many tickets). Support items are created in the support table, updates to support ticket items are created in the supportupdate table and user table is reference only for SESSION variable or Username and UserEmail. These SESSION variables have already been set like you suggested.
Lets see if I can explain it better:
I already send an email to the SESSION user successfully and an additional email to a hardcoded address.

I want to send an additional (3rd) email to the person who created the original support ticket (field found in the support table SupportCreatedBy field). However, in order to obtain the email address of the original support ticket creator, it has to be cross referenced in the user table. So, "after Record Added" of the supportupdate table, an additional email to the original creator needs to go out with the updated record.
I realize that I might need to restructure my data but just need to have a little guidance. Would it be easier and more feasible to some how auto populate the email addresses of the creator of the support ticket into a field of the supportupdate table? If so, how can I auto populate this?
Steve

and than you can use $_SESSION["UserEmail"]in After Record Added event

If session variable $_SESSION["UserEmail"] stores email address of the current logged user then you can simply use $_SESSION["UserEmail"] as a default value of SupportCreatedBy field.
Another option is to use BeforeAdd event and the following code:

Yes, as admin said use

in before record addedevent. Every time a user fills the data then SupportCreatedBy field will be filled automatically with the value of $_SESSION["UserEmail"]
In After Record added use:

to send email

The $_SESSION email keeps coming up. I am already sending an email to the SESSION user successfully. I don't know how else to explain my need. Is there not a way to have a phone call with you Sergey?

The SupportCreatedBy has only a first initial and last name such like "scurrier". It does not contain an email address. I need to cross reference that user name with the User table to get the email address of the user to send an email to. It is not the SESSION USER. Here is my Flow:
Open support from Support Tab

Open supportupdate (link next to line item support ticket)

Add new supportupdate

on Save, send email to-

-$_SESSION[UserEmail]

-Hard coded email (scurrier@coastaldatadynamics.com)

-SupportCreatedBy from related support table (select "UserEmail" from "users" where "support.SupportCreatedBy" = "users.UserName")


As you can see above, there are three emails that need to go out when SupportUpdate is saved. The one in Bold is the one I am trying to figure out the correct syntax for.
Steve

in before record addedevent. Every time a user fills the data then SupportCreatedBy field will be filled automatically with the value of $_SESSION["UserEmail"]
In After Record added use:

to send email

Steve,
if you need help from support contact our support team directly. This is not even a support forum.
The problem is that you only providing us bits of info that is not enough to answer your question. We need to see the whole picture.

Try this :

Sending reply to this to support as I do not want to put this on the forum.

This is what worked at the end.
In each event of SupportUpdate table where you send that email add the following in the beginning.

Now instead of

you can use