A program is trying to automatically send email on your behalf (Outlook via Oracle Developer 6i)
45 pts.
0
Q:
A program is trying to automatically send email on your behalf (Outlook via Oracle Developer 6i)
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;
ASKED: Apr 13 2009  9:06 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
0
29820 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   1
  •  -1
  • AddThis Social Bookmark Button
Hi you need to lower the security settings in Outlook in order to allow this.

---------

This is from a Microsoft Support article:

"Cause:
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 and the way that Outlook can be controlled programmatically.

Note 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. 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.

Note If your mail is delivered to a Personal Folders (.pst) file, you cannot configure the settings for the update."

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.
Last Answered: Apr 17 2009  0:36 AM GMT by Carlosdl   29820 pts.
Latest Contributors: Alessandro.panzetta   9615 pts.
0
0
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0