APEX

Hi,

I thought this would be a simple one, but not sure if the syntax is correct. Basically, I need to pick up the email from a text field and pass that email to the APEX MAIL. send procedure. Now when I enter the actual email in the APEX_MAIL.send e.g

previous code....
apex_mail.send(
p_to => 'some_user@somewhere.com', -- change to your email address
p_from => 'some_sender@somewhere.com', -- change to a real senders email address
p_body => l_body,
p_body_html => l_body_html,
p_subj => 'APEX_MAIL Package - HTML formatted message');
END;


works fine.

But when I try something like

apex_mail.send(
p_to => :P1_EMAIL_ADD, -- change to your email address
p_from => 'some_sender@somewhere.com', -- change to a real senders email address
p_body => l_body,
p_body_html => l_body_html,
p_subj => 'APEX_MAIL Package - HTML formatted message');
END;


I tried, V('P1_EMAIL_ADD') also in the ampex_mail.send call.

Can you advice?

Thanks,
Sun