External e-mail problem [message #415209] |
Sun, 26 July 2009 06:17 |
imuharram
Messages: 48 Registered: January 2009
|
Member |
|
|
I am using the attached package to send mail from forms through outlook to users who are using the application. the problem is that our users have no permission for external e-mails (receiving neither sending), and e-mails sent from the application can't be delivered to our users because of this issue.
I tried to grant myself permission for external e-mails and it worked perfectly well.
Any suggestions on how to solve this issue without granting users access to external e-mails?
[EDITED by LF: renamed the topic; the original title was "I". @imuharram, please, choose a descriptive title next time.]
[Updated on: Sun, 26 July 2009 15:58] by Moderator Report message to a moderator
|
|
|
|
|
Re: External e-mail problem [message #415361 is a reply to message #415209] |
Mon, 27 July 2009 06:49 |
shaz
Messages: 182 Registered: June 2009
|
Senior Member |
|
|
imuharram wrote on Sun, 26 July 2009 16:47 |
I tried to grant myself permission for external e-mails and it worked perfectly well.
|
how did you grant permission to yourself???
|
|
|
Re: External e-mail problem [message #415367 is a reply to message #415361] |
Mon, 27 July 2009 07:23 |
imuharram
Messages: 48 Registered: January 2009
|
Member |
|
|
through the IT department
anyways I found the solution, by adding the following lines to the code I had in the first message
utl_smtp.command(g_mail_conn, 'AUTH LOGIN');
utl_smtp.command(g_mail_conn,UTL_RAW.CAST_TO_VARCHAR2(utl_encode.base64_encode(utl_raw.cast_to_raw(p_auth_user))));
utl_smtp.command(g_mail_conn,UTL_RAW.CAST_TO_VARCHAR2(utl_encode.base64_encode(utl_raw.cast_to_raw(p_auth_pwd))));
where p_auth_user is username of my e-mail account
and p_auth_pwd is the password of my e-mail account
Attached is the modified code
|
|
|
|
Re: External e-mail problem [message #415439 is a reply to message #415438] |
Mon, 27 July 2009 19:05 |
|
djmartin
Messages: 10181 Registered: March 2005 Location: Surges Bay TAS Australia
|
Senior Member Account Moderator |
|
|
The idea of having a special email account that DOES have external access and then use an Outlook macro to redirect any email that arrives in that email box. For example, place the real email address as the first line of the message or as part of the subject string.
David
|
|
|