A program is trying to automatically send email on your behalf (Outlook via Oracle Developer 6i)

60 pts.
Tags:
Microsoft Outlook
Oracle Developer 6i
Oracle development
whenever i am trying to send mail via outlook from oracle developer forms 6i it asked for a confirmation from user. ie:--- a program is trying to automatically send email on your behalf do you want to allow this? if this is unexpected it may be virus and you should choose no I dont want to show this message this mail should go without confirmation becouse this hampers our security level. Please solve my problem. i am sendeng you example of coding PROCEDURE inmail IS BEGIN Declare objOutlook OLE2.OBJ_TYPE; objMail OLE2.OBJ_TYPE; objArg OLE2.LIST_TYPE; objAttach OLE2.OBJ_TYPE; MSENT OUTWARD_CHALLAN_MASTER.SENTTO%TYPE; MISS OUTWARD_CHALLAN_MASTER.ISSUEDBY%TYPE; BEGIN objOutlook := OLE2.CREATE_OBJ('Outlook.Application'); objarg := OLE2.CREATE_ARGLIST; OLE2.ADD_ARG(objarg,0); objMail := OLE2.INVOKE_OBJ(objOutlook,'CreateItem',objarg); OLE2.DESTROY_ARGLIST(objarg); SELECT ISSUEDBY,SENTTO INTO MISS,MSENT FROM OUTWARD_CHALLAN_MASTER WHERE CHALLANNO=:OUTWARD_CHALLAN_MASTER.CHALLANNO; OLE2.SET_PROPERTY(objmail,'To',xyz@company.com'); OLE2.SET_PROPERTY(objmail,'Subject','t : Outward Challan Generated ('||:OUTWARD_CHALLAN_MASTER.CHALLANNO||') ..'); OLE2.SET_PROPERTY(objmail,'Body','This is to inform that Fixed Asset has been sent with following details. Outward Challan # = '||:OUTWARD_CHALLAN_MASTER.CHALLANNO||' Sent to := '||MSENT||' Issued By := '||MISS||' Pls look into ... for detail.'); OLE2.INVOKE(objattach, 'Add', objarg); OLE2.INVOKE(objmail,'Send'); END; END;

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hi you need to lower the security settings in Outlook in order to allow this.

———

This is from <a href=”http://support.microsoft.com/kb/263084″>a Microsoft Support article</a>:

“<b>Cause</b>:
When you apply the Microsoft Outlook E-mail Security Update, the Outlook E-mail Security Update provides additional levels of protection against malicious e-mail messages. The Outlook E-mail Security Update changes the way that attachments are handled by Outlook <i>and the way that Outlook can be controlled programmatically</i>.

<b>Note</b> The Outlook E-mail Security Update is included with Microsoft Outlook 2002, Microsoft Office Outlook 2003, and Microsoft Office Outlook 2007.

Workaround:
To work around this problem, you can customize the behavior of the Outlook E-mail Security Update. <b>You can customize the behavior only if you are running Outlook in a Microsoft Exchange Server environment, and your e-mail messages are delivered to a server-based mailbox.</b>

<b>Note If your mail is delivered to a Personal Folders (.pst) file, you cannot configure the settings for the update.</b>”

On the other hand, are you using an Oracle Database ?
If so, you could send mails from the database, with the help of the utl_smtp package, so you don’t need to use outlook at all for your automated e-mail messages.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following