This should be a very easy one here is my code
<tt>
APEX_MAIL.SEND(
p_to => 'master@oracle.com',
p_cc => 'events.CONTACT_EMAIL, complaints@gmail.com', <--- following does not work because events.CONTACT_EMAIL is a variable
p_from => 'noreply@polkcounty.org',
p_body => ' ',
p_subj => 'Critical Event Scheduled Date is approaching! Alert 1 - Variable try 3rd',
p_body_html => '<b>RESSA</b> Team Critical Event Notification!<br><br>The ' || events.EVENT_NAME || ' critical event has not been completed yet!<br><br>
Please complete all actions required and then mark event status as completed to prevent further escalation, thank you.
<br><br>A brief reminder of the event details:<br><br><table border="1" style="width:100%"><tr>' || events.EVENT_DESC || '</tr>
</table>');
</tt>
so the p_cc line doesn't error out but it doesn't work. if I change that line to "p_cc => 'marManager@companya.com, fredFinance@companyb.com',
It will work but I need to use variables and not hard coded email addresses. I am looking for the easiest solution please.
Any ideas? - Apex 4.2 - windows 7 pc